Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index


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
fine. 

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!

Peace...

Tom

-- 
/When we dance, you have a way with me,
Stay with me... Sway with me.../

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.