Since your re-using the older one, merely changing the numbers -
[that's my system too]
it should work, therefore I would guess there's now a bug
somewhere - but not with you;
can you revert back to an older - workable - version of LO?
[I've never updated since 3.4 ;-) ]
Lots of luck in finding a solution to this weird problem,
On Fri, May 10, 2013 at 3:32 AM, Mathias Koerber <firstname.lastname@example.org>wrote:
I am using Libreoffice to write invoices.
I have a table with several fields that need to be formatted
as currency (SGD).
I basically re-use an older document to save as a new one.
Then I change the values.
Most of the time one of the following happens:
a) when I change just the numerical digits of the value,
the cell is no longer detected as numerical (and thus
counts as 0, detectable by the wrong sum in a SUM field
further down). It seems that it converts the old 'S$'
prefix found in the cell as text now.
b) the 'S$' prefix gets lost and the value stands naked.
Trying to correct this by selecting the value and
Table/Number format/selecting 'SGD' and
pressing ENTER often does nothing.
Neither does selecting a different cell that still has the
correct format applied, selecting the brush and trying
to brush the format back into the cell that was screwed u.
It takes me usually several minutes to clean out the cells
and try to correct everything.
It gets worse when I need to add or delete a row from the
table and thus reapply the format to the new row or such.
Is there no way to 'fix' the format for those cells, so that
editing cannot screw up the format?
Currency formatting in LO seems to be really broken :(
Version 188.8.131.52 (Build ID: 4c82dcdd6efcd48b1d8bba66bfe1989deee49c3)
TinderBox: MacOSX TDF Release, Branch:libreoffice-4-0, Time:
To unsubscribe e-mail to: email@example.com
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
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