https://bugs.documentfoundation.org/show_bug.cgi?id=148747
--- Comment #34 from ady <[email protected]> --- (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? 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 and the content of these cells start with an 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. Is it possible that the recent change in how the apostrophe is working in LO has anything to do with this? The same goes to D2:O2. Of course, the way these cells are displayed is different, and they depend on the aforementioned formats. My point is that whatever you see, depend on several things. I don't care that the formulas are not ideal, because there might be a bug anyway, and there seem to be other factors too. Since raal was able replicate, and the screenshots also show non-zero values for older versions (whihc I don't see), there is not only a communication problem in this report, but perhaps there is some locale factor too(?). raal? Can you please clarify this? What are the steps you followed? Is there a bug that you can replicate, or not? -- You are receiving this mail because: You are the assignee for the bug.
