https://bugs.documentfoundation.org/show_bug.cgi?id=148747
--- Comment #35 from JPT <[email protected]> --- (In reply to ady from comment #34) > (In reply to JPT from comment #33) > > In version 7.4.5.1 (probably from version 7.2.6 and above), ".M.YYYY" works > > on that same statement. > > But that is not the current content of "Calculation.D1:O1" (after pasting > the needed values from the other worksheet), is it? No. I have to change the original "MM.YYYY" to ".M.YYYY" to make it work like in 7.1.8.1 > > When I review "Calculation.ods" and review the cell format (ctrl+1): > > Calculation.D1: General > Calculation.E1: 0 > Calculation.F1: #,##0.00;[RED]-#,##0.00 I didn't even know that was the case. I didn't care what the format was when everything worked the way I wanted it to. > > and the content of these cells start with an apostrophe ('). I don't have the apostrophe there either in version 7.1.8.1 or 7.4.5.1. But to tell the truth, sometimes it happens to me that I have apostrophes in foreign documents, I think most often in the dates. I already have a macro saved for deleting the apostrophe. > > Under those conditions, and with the values of Statements.xls copied to the > Statement worksheet in Calculation.ods, then the results in the Calculation > worksheet are all zeroes for me (LO 7.4.5). > > Now, if I go to D1 and I type in "01.2022" (without quotation marks) over > the previous "'01.2022" (which includes an apostrophe), then I do get > non-zero values in the same column. I have zeros there (in versions higher than 7.1.8.1) but I have nothing to delete (apostrophe). Neither overwriting nor deleting and rewriting works. Still zeros. > but perhaps there is some locale factor too(?). I'll add that at first I thought I had set something in the settings and it changed from a certain version after reinstalling, but I installed a fresh installation of version 7.4.5.1 in a virtual PC, so it probably won't be that. It will probably be a locale setting. I can try to install English in LibreOffice and see what it does there. -- You are receiving this mail because: You are the assignee for the bug.
