Created attachment 85946 [details] Attendance sheet I try to open an XLS file, which I was editing until now with Libreoffice Calc and now most cells containing dates show an Err:502
Cannot reproduce this with 4.1.0.4 and 4.1.2.1 under Win7x64. Maybe it's a Linux-only problem? However, you have not specified the sheets and cells where the problem is visible. It's quite a complex document; maybe I just failed to find the place? Most dates are on the "Feiertage" sheet; no Err:502 there. The severity of this bug should be lowered, according to https://wiki.documentfoundation.org/QA/BugTriage.
You are right, it is a linux-only problem. The cells showing this Err:502 are columns A, P, Q, R, U, V on all months sheets, as well as some other cells in 'Jahresübersicht' and 'Kompaktübersicht' sheets. They contain days of the week or day number or time calculations.
Hi Ana, I think it is a duplicate of bug 69453 FILESAVE: Saving to XLS format omits to save formula expressions of cells where the formula result is an error. I think you need update the version to at least 4.1.1 and recover the formulas. For working purposes I think it is not a good idea go with the last version, if do not need any specific improvement, it is safer stay a step back, 4.0.5.2 in this case. http://downloadarchive.documentfoundation.org/libreoffice/old/ Changed status to RESOLVED DUPLICATE, please if you are not agree reopen it. *** This bug has been marked as a duplicate of bug 67571 ***
(In reply to comment #3) > *** This bug has been marked as a duplicate of bug 67571 *** Hi mariosw, I'm afraid it cannot be a dupe of bug 67571. That bug tells about improper filesave to XLS (some formulas are lost), while this one is about opening properly saved file (e.g., it opens in other systems OK, as I described in comment 1). Further, this is about errors in cells that were calculated properly before. I reset it back to UNCONFIRMED (because I cannot confirm this at the moment, will test in under Ubuntu when reach it).
Testing it further under Windows, I see that Januar.A1 contains the following formula: =DATEVALUE("01.01."&$Stammdaten.D2) The DATEVALUE function (https://help.libreoffice.org/Calc/DATEVALUE) relies on date system that is used by LibreOffice to calculate dates. And this, it is locale-dependent. If I change the formula to =DATEVALUE("01-01-"&$Stammdaten.D2) I have those Err:502 in the columns You mentioned in comment 2. It is possible that the problem is that you have changed the locale settings (in LO, or in your OS), or LO have changed its logic of determining default locale in the recent versions (which may be some intended change, or a separate issue). I would suggest to change that formula to more secure and portable =DATE($Stammdaten.D2;1;1) I set it to RESOLVED INVALID, as it is not a bug (if my conclusions are correct). Please reopen it if you think it is wrong decision. Please add a description why you feel so. Thank you for reporting.
Right Mike, I had not unprotected the sheet and only saw the error not the formula. Changing the locale setting to Germany (German) and calculating, dates are fine. So not a bug.
Thanks a lot. Change the local settings language worked for me too.