https://bugs.freedesktop.org/show_bug.cgi?id=39484
--- Comment #57 from Ralf <[email protected]> --- I want to start with an introductory paragraph, which contains the most important information of this comment according to my non-technical judgment: The bug occured repeatedly after changing cell formatting globally in the sheet. The cause for global change of cell formatting can be deletion of a user-defined format code, change of the default settings in "Styles and Formatting" in the "Format" menu or similar changes. And now the long version: The reported bug causes a siginificant annoyance in my work with LO Calc for more than a year. I had not reported the bug because I cannot reproduce it. Today I found this bug report accidentally and realised that other users encounter the same problem and that reproducing the bug is not easy for them either. I encounter the bug in a rather big and complicated spreadsheet, which I had started setting up with MS Excel 2007. To migrate from MS Excel to LO Calc I had converted the sheet by saving it as XLS with MS Excel, loading it with LO Calc and then saving it as ODS with LO Calc. Since then I kept developing the spreadsheet considerably, and the bug occurs from time to time. The spreadsheet contains 18 worksheets, the cells contain several thousand links to other cells, and the spreadsheet size is 2 MB in ODS file format. I cannot share the file for confidentiality reasons. The bug occured with LO 3.5 and LO 3.6. I remember to have encountered the bug with LO 3.4 as well, but I am not absolutely sure about the occurrence in LO 3.4. I have not switched to LO 4.0 yet, because the bug had occured in my spreadsheet after version changes (i.e. when opening the sheet with the new version), so that I am very conservative with updating LO program versions. Besides, LO 4.0 contains another unrelated bug in LO Impress, which is significant for my work and which does not occur with LO 3.6. Currently I work with LO 3.6.7.2 under Windows 7 with 32-bit architecture (x86). If the bug occurs, I lose the groupings of columns and rows on all worksheets. However, I am not absolutely sure, if the bug might have occured by affecting only some worksheets in the spreadsheet. I think that the bug was not related to saving or opening the spreadsheet. Again I am not sure about it. I lost the comments in cells of the worksheet as well. Therefore, I gave up using comments. I can work on the spreadsheet without using comments, but I do not get along without grouping columns and rows. Therefore, my experience with the bug concentrates on loss of grouping columns and rows. Since I had found out that the bug occured mainly when changing cell formats globally (see introductury remark of this comment), I could minimise its frequency of occurrence. Nevertheless, the bug can still occur unexpectedly. There is a high probability that the bug occurs in my spreadsheet if I do a series of global cell format manipulations. I tried to reproduce it with a simple spreadsheet, which I had converted from XLS or XLSX to ODS. I was not able to produce the bug with a simple spreadsheet. I am not a developer. I assume that a comment like this one is technically of limited use. Nevertheless, I want to share my experience with this bug. Maybe my description helps though it is not extremely precise. Moreover, it documents that there are more users out there, who struggle considerably with the effects of this bug. A big thank you to everyone who has tried and will try to hunt down this bug considering its complexity and the difficulty to reproduce it with a simple spreadsheet. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
