https://bugs.documentfoundation.org/show_bug.cgi?id=148747
--- Comment #36 from JPT <[email protected]> --- (In reply to ady from comment #34) > 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. > but perhaps there is some locale factor too(?). (In reply to JPT from comment #35) > I can try to install English in LibreOffice and see what it does there. If I change the local setting to English, the apostrophe suddenly appears in the D1:O1 cells, but when I change to Czech it disappears again. When I switch Locale settings to English, the "Date acceptance patterns" is set to "M/D/Y;M/D" and this changes the display of dates in the statement, so then the "calculation" sheet cannot calculate anything. If I set the English pattern to "D.M.Y;D.M.;D. M.;D. M. Y;D. M.;D. M. Y" , it stays in the settings, but the date display does not change. "D.M.Y;D.M.;D. M.;D. M. Y;D. M.;D. M. Y" will only stay there until I switch to another language and put it back. Then it's back to the original "M/D/Y;M/D". If I overwrite the values with an apostrophe to "01.2022", it switches to "1.2022", it doesn't stay there "01.2022", but that wouldn't help me anyway, because the dates in the listing have changed to "D/M/YYYY" because of the Locale setting, which can't be changed. So I can't replicate the fact that when I overwrite the cell with the apostrophe to the same value, it suddenly starts counting correctly (non-zero values appear). -- You are receiving this mail because: You are the assignee for the bug.
