Hi Regina, Thanks for your response.
If I install the 4.1 beta, will it install side by side with the existing stable, or replace it? If it replaces it, can I revert to stable easily? Do I just re-install with the stable download? And how do I determine which locale and language settings I use? Do I simply go to Tools|Options|Language Settings|Languages and give you all the values there? Thanks again Paul On Sun, 23 Jun 2013 19:57:14 +0200 Regina Henschel <[email protected]> wrote: > Hi Paul, > > Paul schrieb: > > Bump? > > > > Or is this the wrong mailing list to ask such questions on? > > It is the right mailing list. But sometimes an email slipped through. > > I cannot reproduce the problem with LibreOffice 4.1. Please try it > with the LO4.1 beta. > > If you see the problem there too, it might defend on the locale and > you should tell us your language settings in that case. > > Kind regards > Regina > > > > > > > > > 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
