https://bugs.documentfoundation.org/show_bug.cgi?id=94945
andréb <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |UNCONFIRMED Ever confirmed|1 |0 --- Comment #3 from andréb <[email protected]> --- (In reply to Terrence Enger from comment #1) > I use a period for my decimal point, and that is evident in the rest > of this comment. Is there any reason to think that this could explain > why my results differ from andréb's? Thanks for your response. I hadn't thought of period/comma difference being related, but everything worked correctly in the (not very recent) past. > Format code '#.99#' does display the values unhelpfully: .99 and .998 > and .999 and .999 but > (a) this differs from andréb's description, and > (b) it seems right to me, seeing as '9' is a literal character > inserted into the display. Right, I wrote 9s instead of 0s. (Shouldn't write bug reports when exhausted.) > Format code '#.00#' gives the display that andréb asks for. I see > this in both daily dbgutil repository version 2015-10-10 and 3.5.4.2 > as delivered with debian-wheezy. #,00# works correctly for me in the session it is defined, but if I save and exit, the format is no longer defined when I reload the spreadsheet in question. Giving the other symptoms mentioned in the description. > So, andréb, can you confirm that you really mean 9's in the first > paragraph of the bug description? If so, can you attach a workbook as > it was left by a version of LibreOffice which displays it the way you > want? Remember that attachments to a bug report are visible to the > whole world, so do not include anything that you do not want the whole > world to see. > Terry. I added a new file showing the problem. Column A is using default format. Column B is same values, initially formatted as #,00# (english = #.00#) (No other personalized formats were added.) After saving, closing all open .ods files, and reloading the test file, Column B is formatted to automatically created format #,000 The #,00# format initially defined is gone. Note that this is somewhat different to the spreadsheet initially showing the problem. In that spreadsheet, on reloading, the format was set to default values, not #,000 Maybe because I have many personalized formats defined. But that spreadsheet contains a lot of personal data. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
