Bump? Or is this the wrong mailing list to ask such questions on?
On Tue, 18 Jun 2013 14:42:38 +0200 Paul <[email protected]> wrote: > Hi All, > > I'm running LibreOffice Version 4.0.3.3 (Build ID: > 0eaa50a932c8f2199a615e1eb30f7ac74279539) on Windows 7 64-bit. Files > are saved in native ods format. > > I'm using a custom format code on a cell in Calc to get a value > displayed as a rate per hour. > > This is the format code I want: > > [$R-1C09] #,##0.00 " / hour";[$R-1C09]-#,##0.00 " / hour" > > As it is, that code works fine. When I enter a value of 300, I can use > it in calculations, and it gets displayed as "R 300 / hour", just as I > want. > > The problem comes in when I close the file. Even if all I do is enter > the correct formula as above, then save and close the file, when I > re-open the file, the field now displays as "R 300.00 / hoRr". When I > go to the cell format, I see the format code has changed to: > > [$R-1C09] #,##0.00" / hRRr";[$R-1C09]-#,##0.00" / hoRr" > > This happens every time I close the file. When I re-open it, the > format has changed. This is not caused by the save, because once > edited, the formula stays correct for the duration of the session, > until I close the file. > > It's not just that "hour" has changed to "hRRr" and "hoRr", but the > space between the "0.00" and the quote has gone (in fact, the quote > now has two spaces after it, instead of the one before I closed the > file). This space is very important. If I edit the formula as it is, > and just change the "hRRr" to "hour", the format code is removed. On > the previous version of LibreOffice I had (not sure which version > that was, though, either 3.5 or 3.6 something), it would have no > effect. After editing the format code, the value would still be > displayed wrong, and going back to the cell format, I would see that > the format code had reverted back to the wrong code. Only if I put a > space between the "0.00" and quote would the code retain the "hour". > Now, on this version of LibreOffice, if I don't put a space between > the "0.00" and the quote, if I just change the "hRRr" and "hoRr" to > "hour", the custom format code is entirely removed, and the format > reverts to a standard number. If I correct the format, it stays until > I close the file, and then once I re-open it, it has reverted to the > incorrect custom format code. > > I have had this issue in several files, and can re-create it by > opening a new file, putting "300" in the first cell, going to "Format > | cells" choosing currency and putting ' " / hour"' after both > "0.00". This shows correctly. Then I save the file, close it, and > re-open it and it has mangled the custom format code. > > Can anybody else confirm that they are also having this problem? Does > anybody know anything about this problem? Should I submit a bug for > this problem, and if so, where? At https://bugs.freedesktop.org/ or at > https://www.libreoffice.org/get-help/bug/ ? I have tried searching > both the mailing list archive and the bugtracker for this problem, but > didn't turn up anything relevant. > > Regards > > Paul Steyn > -- To unsubscribe e-mail to: [email protected] 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
