Created attachment 81880 [details] File saved with 4.0.3 or earlier version Basicly, I have 2 problems here, but my guess it's same root cause. Maybe I'm not correct, but I'll report it both in this bug. This is also regression since all this works without problems in LO 4.0.3 stable version. BUG 1 ---------- TEST1.xls 1. Open file with 4.0.3.3 for example. 2. In cell D9 enter 1st of July (1.7.2013). 3. All cells from E9:AH9 will change value and represent all days on month. Now repeat steep 1 to 3 with 4.1. RC1 and you will notice that cell AH9 lost it's formatting. If I open file saved with older version of LO which has date in cell AH9, for example file from May which has 31 days in month, that cell will keep it's formatting. But if I for example take file from february (TEST1FEB.xls), all cell that didn't have date in february (AF9:AH9) will loose it's formatting. ---------- BUG 2 ---------- TEST2.xls I can't tell you how to reproduce this since I didn't manage to do it my self, but this happened with files saved with LO 4.1 RC1. TEST2.xls is same file as TEST1.xls after saved with LO 4.1 RC1 I have 3 files like this, but didn't manage to reproduce it deliberatly. ----------
Created attachment 81881 [details] File for february 2013 save with LO 4.0.3.3
Created attachment 81882 [details] File saved with LO 4.1 RC1 Formatting lost in cells C7:AH9
@moggi: AH9 has General number format (sheet is protected, need to unprotect to see) and in 4.1 doesn't inherit the format from AG9 anymore if the result changes, which earlier versions did.
Created attachment 81889 [details] TEST1 without sheet protection Did you try to remove sheet protection? This is also bug, it doesn't asks for password at all. I removed it with 4.0.4.1 which I have installed home, and it didn't as for password (both sheet and document passwords).
(In reply to comment #4) > Did you try to remove sheet protection? > This is also bug, it doesn't asks for password at all. That is NOT a bug, it is possible to setup protection without password.
My bad then, but since I made those files and have both (ODS and xls) versions, I know I didn't make them that way. :)
Created attachment 81891 [details] TEST1 - ODS version I'm really sorry for spamming this bug report, but I just want to help at finding problem faster. When I posted last comment it occured to me that I didn't test this on original ODS file. Tested it now and it shows same problem. Attached you can find test ODS file.
I think I have an idea what is going wrong with the number formats and why the issue does not sow up in master. In master my code for inherited number formats has been broken by one of Kohei's merges. In 4-1 we don't have that merge so we still have my old code which tells the formula cell that it needs a number format because the number format is not yet set. Maybe the easiest solution is to first import the number format and set it to the cell and after that import the cell. I'll fix the problems from the merge in the first step and then have a look at this bug here.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=f45c47af72369859d1937cb8b46cba370031509a xls cells have all hard number format, fdo#66506 The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Not sure what does inherriting number formats means, but all those cell are formated as date, DD.MM.YY format. Checked both xls and ODS file versions.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-4-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=a4a9100d70a5074b6537223fa2ab3a29cde5213b&h=libreoffice-4-1 xls cells have all hard number format, fdo#66506 It will be available in LibreOffice 4.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
I was editing one file yesterday and today when I opened it again, all number formatting was gone. No % formatting, no 1000 separator, no fixed number of decimal places... Even some aligments and conditional formatting were gone. I guess 4.1 RC1 has real problems with that and I would call it a blocker since it's destroys all document formatting. If you want I can send you files privatly on email since I can't post them publicly.
Great work! Everything is working again for XLS files. But this problem remains for ODS files. Try opening my TEST1.ods file and changing first date to 1.7.2013 , issue remains. Bug from comment 12 is corrected also. I assume it was bug 66242.
Bump. Just wanted to divert attention that this is half fixed since it's not yet working for ODS files in LO 4.1. Couldn't test XLSX since when I save as XLSX all hell breaks loose and formatting collapses, but I'll report that in seperate bug when this is fixed.
according to previous comment I modify summary notes in order to include the .ods format
Still present in Version: 4.1.3.1 Build ID: b42498da0e3f91b17e51b55c8295ec4f8f22087 - Sophie
(This is an automated message.) Setting priority to highest as this is a 4.1 MAB. This is part of an effort to make the importance of MAB reflected in priority too.
@Mikeyy - L10n HR please give update of the status of this bug with current 4.2.3.3 release. if all issues are gone set status to FIXED while if some part of the bug is still here, I suggest to close this one, set status to MOVED, then open a new clean report with only the relevant residual buggy behaviour (including new test files) and drop it's link here under "See also"
When opening with 4.2.4.1 ODS (last attachment in list), enter 1.1.2014 in cell D9, and you still have date formatted as number instead of date on last 3 date cells (29.01 / 30.01 / 31.01).
Ok. moving it to mab4.2 list
You can add D.M.Y in the "Date acceptance patterns" in the Options dialog under Language settings - Languages and see if that solves the problem. Eike said that (and I agree with him) date recognition is a super hard problem and "fixing" for one would likely "break" for another, which is why he added that option.
My locale (HR) has this pattern as default: D.M.Y;D.M;D.M.Y.;D/M/Y;D/M So D.M.Y is already included and tested with. Bug started with 4.1 version and it's still present in 4.2. There was no problems in 4.0 Problem with xls was solved in this bug, but not ods.
The ods file is protected which makes working with it a pain. Can you please upload a document without a password or state the password.
You got mail.
The problem with ODS is already in the file and works for a new and clean file or after fixing that file. So there is nothing we can do here. This file was at one point written with a broken exporter and there is no way to recover from that.