Re: [libreoffice-users] Question about Calc and user-defined number formats

On 02/16/2014 02:36 PM, Brian Barker wrote:
> At 11:27 16/02/2014 -0800, Tom Williams wrote:
> > 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 ...
>
> Nothing happens until you confirm by clicking OK, of course.  But if
> you mean that the format didn't change even after you clicked OK, then
> the obvious first possibility is that you had made an error in
> modifying the string in the "Format code" box and had created
> something that was not a valid format code.  In this case, the format
> of the selected cells would not change and no new format example would
> be created in the User-defined category.  (You can test this by
> experiment.)

Thanks for posting this.  Duh!!!!  :)   Since no message of any kind was
issued telling me the modified format might be invalid, it didn't occur
to me that I was breaking the format code.  I'll experiment with this.

Thanks!

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