So, I installed LibreOffice 4.2.0 on a Windows 7 system today and was
showing the system owner how to use it. I created a new spreadsheet and
added two columns and four rows, the last row being a "total" row that
would show the sum of the previous rows.
The first row I added was column headings.
The second row I added had text in the first cell and the number "50" in
the second cell.
The third row I added had text in the first cell and the number "40" in
the second cell.
The fourth row was blank.
The fifth row was the "total" row. Cool.
So, I selected cells "B2..B5" and used the "Format/Cells" function to
change the format to a currency format. I chose the "-$1,234.00" in red
format. The numbers in column B were changed accordingly. Then, my
friend wanted only the first cell with a number to have a dollar sign
and the numbers below it to NOT have a dollar sign. So, I selected
cells "B3..B5" and used the "Format/Cells" function to change the
format. When the "Format Cells" window appeared, the "Currency" number
format was selected, as expected. I went to the "Format code" box and
simply removed the "$$" references, leaving the rest of the format code
intact. The Category immediately changed to "User Defined", which is
Here's the problem: after the category changes to "User Defined", the
modified format code, which is still displayed, doesn't apply to the
selected cells and I can't find any way to save the modified currency
format as a user defined format I can reuse. I tried changing the
comment of "User-defined" to something else, thinking that might be used
as a category name or something.
What am I doing wrong?
Thanks in advance!
/When we dance, you have a way with me,
Stay with me... Sway with me.../
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
- [libreoffice-users] Question about Calc and user-defined number formats · Tom Williams
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy