[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #83 from Commit Notification libreoffice-comm...@lists.freedesktop.org --- Markus Mohrhard committed a patch related to this issue. It has been pushed to master: http://cgit.freedesktop.org/libreoffice/core/commit/?id=6f2957969bd72308ddf79cb2befa2373f2dc1dbe compare against IDF_HARDATTR, fdo#39484 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. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #82 from kouka...@gmail.com --- I think I have found a workaround for those who use an affected version of lo. If you want to copy exactly one cell/row/column [→element] copy element paste special Shift down/right cut new element (leaves blank element) paste delete blank element (Ctrl+delete) This way you don't use the undo command. It seems to be working fine but I have not tested this thoroughly. I hope it helps -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 Commit Notification libreoffice-comm...@lists.freedesktop.org changed: What|Removed |Added Whiteboard|target:4.2.0 target:4.1.2 |target:4.2.0 target:4.1.2 ||target:4.0.6 --- Comment #81 from Commit Notification libreoffice-comm...@lists.freedesktop.org --- Michael Meeks committed a patch related to this issue. It has been pushed to libreoffice-4-0: http://cgit.freedesktop.org/libreoffice/core/commit/?id=07a69320a7b475e8b09b2faca8b6f728a62372ech=libreoffice-4-0 fdo#39484 - don't loose outlines while trying to undo formulae changes. It will be available in LibreOffice 4.0.6. 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. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #80 from Ralf ralfs.mail.addr...@gmail.com --- According to my user checks things work fine including comments. Thank you very much to all contributors for having removed this nasty bug! The bug used to be a real annoyance in my work with LO Calc. I am impressed about the process how it could be reproduced and removed. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 Michael Meeks michael.me...@novell.com changed: What|Removed |Added Status|REOPENED|RESOLVED Resolution|--- |FIXED --- Comment #77 from Michael Meeks michael.me...@novell.com --- Eike seemed happy with it so it's: https://gerrit.libreoffice.org/5592 for -4-1. If that doesn't cause any concern after a release, we could back-port it to 4-0 I imagine in a month or so. Closing for now; do ping in a month if you're desperate for a -4-0 backport. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #78 from Winfried Donkers winfrieddonk...@libreoffice.org --- (In reply to comment #77) Eike seemed happy with it so it's: https://gerrit.libreoffice.org/5592 for -4-1. If that doesn't cause any concern after a release, we could back-port it to 4-0 I imagine in a month or so. Closing for now; do ping in a month if you're desperate for a -4-0 backport. Thanks a lot for your fast -and informative- digging and fixing! I will test with master if I can reproduce the problem with the comments getting lost (I hope I can't). -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 Commit Notification libreoffice-comm...@lists.freedesktop.org changed: What|Removed |Added Whiteboard|target:4.2.0|target:4.2.0 target:4.1.2 --- Comment #79 from Commit Notification libreoffice-comm...@lists.freedesktop.org --- Michael Meeks committed a patch related to this issue. It has been pushed to libreoffice-4-1: http://cgit.freedesktop.org/libreoffice/core/commit/?id=4205ca8003bc5c62a10620c7e54bdf9afb9d86bfh=libreoffice-4-1 fdo#39484 - don't loose outlines while trying to undo formulae changes. It will be available in LibreOffice 4.1.2. 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. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #72 from Michael Meeks michael.me...@novell.com --- void ScTable::CopyToTable( ... pDestTab-SetOutlineTable( pOutlineTable ); // auch nur wenn bColRowFlags Disabling this line stops us loosing the grouping; so - I guess that pOutlineTable is NULL in the undo information - which is interesting - but why only for this one sheet ? why don't we loos more :-) The hunt continues ... -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #73 from Winfried Donkers winfrieddonk...@libreoffice.org --- (In reply to comment #72) void ScTable::CopyToTable( ... pDestTab-SetOutlineTable( pOutlineTable ); // auch nur wenn bColRowFlags Disabling this line stops us loosing the grouping; so - I guess that pOutlineTable is NULL in the undo information - which is interesting - but why only for this one sheet ? why don't we loos more :-) The hunt continues ... Please keep hunting ;) BTW, we did have a loss of grouping and of grouping_and_comments (all cell comments on a sheet). I can't tell if we experienced loss in more than one sheet at a time, especially as we didn't know what caused the loss and loss in more sheets could have been caused by more than one undo action. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #74 from Michael Meeks michael.me...@novell.com --- Another interesting data-point is that this is exclusive to cut/paste, copy/paste doesn't suffer from the same issue; so back up to: bool ScViewFunc::PasteFromClip( sal_uInt16 nFlags, ScDocument* pClipDoc, The more I read this the more I marvel at what is going on - it looks rather fragile. It appears that the code wants to preserve formulae on ~all sheets so we can undo the effects of cut/paste. Unfortunately, the CopyToDocument method has two modes of operation: one where every tab is present (when it really copies the range you pass), and another when tabs are not present (when it only copies to existing tabs). First we try to CopyToDocument with a limited set of (the selected) tabs - to just copy that data for undo; so we only copy the outline data for sheets that are active. // all sheets - CopyToDocument skips those that don't exist in pUndoDoc SCTAB nTabCount = pDoc-GetTableCount(); +if ( bCutMode ) +{ +// fdo#39484 - needs to be done before the CopyToDocument to preserve +// outline other data on sheets that we're not viewing. +pUndoDoc-AddUndoTab( 0, nTabCount-1 ); +} fixes that; but of course it then starts to copy far too much. Then unfortunately, we do another copy into the pUndoDoc here: pRefUndoDoc-CopyToDocument( 0,0,0, MAXCOL,MAXROW,nTabCount-1, IDF_FORMULA, false, pUndoDoc ); Which is presumably intended to preserve formulae, however this was again not constructed for all tabs, so it now overwrites the outline data with NULL dummy data. So ... it seems that the basic problem here is a mis-understanding of how CopyToDocument interacts with outlining. We pass the IDF_FORMULA flag, but the code then operates on far more than just formulae. Having fiddled a fair bit here; I think the best sol'n is to add an IDF_OUTLINE - or IDF_NOOUTLINE bit to add in there, to allow the IDF_FORMULA mask to only mutate formulae. Or worse - add some IDF_FORMULAONLY - which would suck ;-) I'll try to come up with something pleasant. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #75 from Michael Meeks michael.me...@novell.com --- I just pushed a prototype fix; quite possibly it severely harms the rest of calc [ I hope not, but you never know ], and I'm no calc engineer. Looking forward to some testing of copy / paste / move etc. with outlines around - AFAIK there are no unit tests for this lot (anyone wanting to write them would be more than welcome). Things to look out for when testing: the code involved tries to restore formulae to the state they were in before the cut/paste - so worth checking some cases of this to make sure they are. Anyhow - I hope it will be in some master builds to play with in due course, and at some stage we can back-port it :-) Thanks so much for the reproducible test-case; it looks like this issue has been there for years. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 Commit Notification libreoffice-comm...@lists.freedesktop.org changed: What|Removed |Added Whiteboard||target:4.2.0 --- Comment #76 from Commit Notification libreoffice-comm...@lists.freedesktop.org --- Michael Meeks committed a patch related to this issue. It has been pushed to master: http://cgit.freedesktop.org/libreoffice/core/commit/?id=e851ea0ed30e9bb95c273a29aeab7f48f606145f fdo#39484 - don't loose outlines while trying to undo formulae changes. 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. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #69 from Winfried Donkers winfrieddonk...@libreoffice.org --- (In reply to comment #66) I did a bit of work on this; the undo object is ScUndoPaste: ScUndoPaste::DoChange (this=0xae48eb8, bUndo=true) at /data/opt/libreoffice/master/sc/source/ui/undo/undoblk.cxx:896 Seems to do some rather odd things - it appears eg. to touch other sheets than the current one (on which the operation is done) - no idea why: 937 for (size_t i = 0, n = maBlockRanges.size(); i n; ++i) 938 { 939 ScRange aCopyRange = *maBlockRanges[i]; 940 aCopyRange.aStart.SetTab(0); 941 aCopyRange.aEnd.SetTab(nTabCount-1); 942 pDoc-CopyToDocument( aCopyRange, nUndoFlags, false, pRedoDoc ); 943 bRedoFilled = true; Which of course only fills the redo data - but appears to copy every sheet rather than the current one [ perhaps that has something to do with it ] - still thinking ;-) @Michael: when you've thought it out ;-) , but haven't got the time to code and test, I am willing to help fixing this. It is a very annoying bug at our company. Having said that, I won't be able to do any coding in the first half of September. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #70 from Michael Meeks michael.me...@novell.com --- Not that it's news but this: void ScUndoPaste::DoChange(bool bUndo) ... for (size_t i = 0, n = maBlockRanges.size(); i n; ++i) { ScRange aRange = *maBlockRanges[i]; ScMarkData::iterator itr = aMarkData.begin(), itrEnd = aMarkData.end(); for (; itr != itrEnd *itr nTabCount; ++itr) { aRange.aStart.SetTab(*itr); aRange.aEnd.SetTab(*itr); ** pUndoDoc-UndoToDocument(aRange, nUndoFlags, false, pDoc); } } line - when uncommented avoids the issue occuring; I guess that's the core of Undoing pastes though ;-) Interestingly though, the *itr is 4 for this - and the inner loop only occurs once; 4 seems a plausible value for nTab called '1' which I'm editing; which looks correct. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #71 from Michael Meeks michael.me...@novell.com --- void ScDocument::UndoToDocument(const ScRange rRange, ... ... if (nTab2 static_castSCTAB(maTabs.size())) CopyToDocument( 0,0,nTab2+1, MAXCOL,MAXROW,maTabs.size(), IDF_FORMULA, false, pDestDoc, pMarks ); Appears to do a giant copy to undo a paste - of all the formulae in the document - which seems a tad steep. Either way - disabling that un-breaks the groups too. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #65 from Winfried Donkers winfrieddonk...@libreoffice.org --- (In reply to comment #62) I can reproduce the loosing of grouping in other calc documents as well: -select sheet before sheet with grouping -select row n -paste somewhere -undo : the grouping in th enext sheet is lost I have not tried other combinations, the steps in comment 58 and above should be a sufficient starting point for a developer. Instead of rows, columns can also be used to reproduce the loosing of grouping in the next tab sheet. I have not been able yet to loose the comments with these steps. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #66 from Michael Meeks michael.me...@novell.com --- I did a bit of work on this; the undo object is ScUndoPaste: ScUndoPaste::DoChange (this=0xae48eb8, bUndo=true) at /data/opt/libreoffice/master/sc/source/ui/undo/undoblk.cxx:896 Seems to do some rather odd things - it appears eg. to touch other sheets than the current one (on which the operation is done) - no idea why: 937for (size_t i = 0, n = maBlockRanges.size(); i n; ++i) 938{ 939ScRange aCopyRange = *maBlockRanges[i]; 940aCopyRange.aStart.SetTab(0); 941aCopyRange.aEnd.SetTab(nTabCount-1); 942pDoc-CopyToDocument( aCopyRange, nUndoFlags, false, pRedoDoc ); 943bRedoFilled = true; Which of course only fills the redo data - but appears to copy every sheet rather than the current one [ perhaps that has something to do with it ] - still thinking ;-) -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #67 from Ralf ralfs.mail.addr...@gmail.com --- (In reply to comment #65) I have not been able yet to loose the comments with these steps. I lose the the comments as well if I use koukasio's sheet from comment 58 and follow the described steps. After opening koukasio's sheet, the cursor is on sheet 2 in cell A12. I insert a comment in this cell. It is lost after following the steps in comment 58. I use Windows 7 with 32-bit architecture (x86). I assumed in comment 57 that the loss of grouping can be related with global changes of cell formatting. I could not verify this suspicion with koukasio's sheet. My assumption of comment 57 seems to be wrong. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #68 from Ralf ralfs.mail.addr...@gmail.com --- (In reply to comment #67) I use Windows 7 with 32-bit architecture (x86). Forgot to mention: LO 3.6.7.2 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #60 from Winfried Donkers winfrieddonk...@libreoffice.org --- (In reply to comment #58) Created attachment 84160 [details] reproduction_sample I hope this is useful, this thing has been such a pain for so long!! I confirm the getting lost of the grouping in sheet 2, using version 4.0.4.2 on Windows 7 and using version 4.2.0.0.alpha0+ on openSUSE 12.3 Unfortunately, I am not familiar with in this part of the calc code, so I can't try to fix it. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 tommy27 ba...@quipo.it changed: What|Removed |Added CC||kohei.yosh...@suse.de --- Comment #61 from tommy27 ba...@quipo.it --- I add Kohei Yoshida to CC list. maybe he can help. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #62 from Winfried Donkers winfrieddonk...@libreoffice.org --- (In reply to comment #60) (In reply to comment #58) Created attachment 84160 [details] reproduction_sample I hope this is useful, this thing has been such a pain for so long!! I confirm the getting lost of the grouping in sheet 2, using version 4.0.4.2 on Windows 7 and using version 4.2.0.0.alpha0+ on openSUSE 12.3 Unfortunately, I am not familiar with in this part of the calc code, so I can't try to fix it. I can reproduce the loosing of grouping in other calc documents as well: -select sheet before sheet with grouping -select row n -paste somewhere -undo : the grouping in th enext sheet is lost I have not tried other combinations, the steps in comment 58 and above should be a sufficient starting point for a developer. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #63 from Michael Meeks michael.me...@novell.com --- koukasio - brilliant :-) thanks so much for the reproduction steps; it's fantastic to finally have a good way to reproduce this. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #64 from kouka...@gmail.com --- (In reply to comment #63) koukasio - brilliant :-) thanks so much for the reproduction steps; it's fantastic to finally have a good way to reproduce this. It is the lo-people to thank, I am just a humble user :-) I hope I am being helpful... -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #58 from kouka...@gmail.com --- Created attachment 84160 -- https://bugs.freedesktop.org/attachment.cgi?id=84160action=edit reproduction_sample HALLELUJAH I have managed to reproduce the bug http://www.youtube.com/watch?v=YrLk4vdY28Q Let's get serious... I am attaching the file The steps to follow are: go to sheet named '1' select row 15 Insert→Rows select row 16 cut paste to row 15 undo Voilà!! Go to sheet named '2'... grouping/outlining is lost!! I hope this is useful, this thing has been such a pain for so long!! -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #59 from kouka...@gmail.com --- I started building the document yesterday on lo 4.1.0.4 on Ubuntu 12.04 , 08/16/2013, 15:41:44 . I started it from scratch , no M$ windows, office etc. The template I am using was started a year before on something like lo3.5. Would you like me to attach my template as well? -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #57 from Ralf ralfs.mail.addr...@gmail.com --- 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 Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 tommy27 ba...@quipo.it changed: What|Removed |Added Status|RESOLVED|REOPENED Resolution|WORKSFORME |--- Blocks|6 |54157 --- Comment #56 from tommy27 ba...@quipo.it --- @koukasio ok. I reopen the bug and move it to the mab4.0 list. it would be very important to obtain a test case and instruction to reproduce. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #51 from Winfried Donkers winfrieddonk...@libreoffice.org --- (In reply to comment #50) @Winfried do you still reproduce this bug with recent 4.0.4 or 4.1.0 releases? AFAIK we haven't encountered this bug with version 4.0 (4.1 isn't ready for company use yet). The bug occurs very rarely, but -given the data loss- it is a bad one. My guess is that it is connected to certain (long existing) files. With two files it has occurred multiple times, with hundreds of other files is has never occurred (and these files all have the same base file from which they originate, first an xls-file, now an ods file). -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #52 from tommy27 ba...@quipo.it --- so are you saying that it has never reoccurred yet in 4.0.x or that it still happens rarely? or that it happened rarely in 3.6.x... -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #53 from Winfried Donkers winfrieddonk...@libreoffice.org --- (In reply to comment #52) so are you saying that it has never reoccurred yet in 4.0.x or that it still happens rarely? or that it happened rarely in 3.6.x... The bug hasn't occurred with version 3.5.5 or earlier (we think), it seemed to start with 3.6, but we know of at least one instance when the bug occurred with version 3.5.7. We upgraded from 3.5.7 to 4.0.4 and so far, I have not received reports of the bug. (BTW we are currently moving the data from these calc-documents to our ERP-platform, which means that we are likely to experience the bug even less, as these calc-documents become read-only once the data is moved. I will so be of limited 'use' with respect to this bug.) -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 tommy27 ba...@quipo.it changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |WORKSFORME --- Comment #54 from tommy27 ba...@quipo.it --- Ok Winfried. I'm gonna set status as WORKSFORME since you said it's not happening anymore in 4.0.x even if we don't know what fixed it. feel free to REOPEN this report if you will reproduce it again in 4.0.x or 4.1.x -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 tommy27 ba...@quipo.it changed: What|Removed |Added Version|(See in Summary)|3.5.7.2 release -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #55 from kouka...@gmail.com --- (In reply to comment #46) (In reply to comment #44) I confirm the behaviour with 4.0.2.2 on Kubuntu 12.04 I have confirmed that the bug exists with 4.0.X with newly created files(not old ones)... I have been updating to the latest releases of libreoffice to help debugging. The problem is not fixed. I am still trying to figure out what is happening I don't want to change any status bymyself but I think that it is wrong to state as resolved. I will keep trying to help -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 tommy27 ba...@quipo.it changed: What|Removed |Added CC||ba...@quipo.it --- Comment #50 from tommy27 ba...@quipo.it --- @Winfried do you still reproduce this bug with recent 4.0.4 or 4.1.0 releases? -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #49 from Winfried Donkers o...@dci-electronics.nl --- We just found out another case of grouping loss on one sheet of an ods document. Last change was made on a Windows 7 machine with version 3.5.7 (machine was downgraded to avoid this problem as we suspected the problem started with version 3.6 - which assumption was clearly wrong). This time the notes were not lost, only the grouping of one sheet (other sheets in the document were still with grouping and notes). The document is available in version with grouping and without (i.e. before and after the occurrance of the problem). Given the content I cannot make them attachments of this public bug, but I can send them directly to the developer working on this bug. I can however upload fods files with the client information removed, allthough I fear that both files will be valid and the difference will be that one file has grouping setting for n sheets and the other has grouping settings for n-1 sheets (the settings are simply not there, they don't seem corrupted). -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #48 from Michael Meeks michael.me...@novell.com --- Hi David; I rather suspect that your test case just highlights the lack of grouping support in the XLSX export - which is a different bug. Some random code pointers: SID_OUTLINE_MAKE applies outline grouping - (not to be confused with any SID_*GROUP foo). It looks like that all ends up in sc/source/ui/docshell/olinefun.cxx - MakeOutline and RemoveOutline; hmm ... -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #44 from David Greaves da...@dgreaves.com --- Maybe things have changed but I found a very minimal test case Version 4.0.3.3 (Build ID: 400m0(Build:3)) from Debian Open new instance of localc New sheet highlight column D Press F12 - grouping appears Save as /tmp/grptst2.xlsx close sheet open sheet No grouping visible For background I hit this bug on sheets generated by http://search.cpan.org/~jmcnamara/Excel-Writer-XLSX-0.67/ That creates sheets which *do* have grouping and which is preserved in rows, but not columns afaict -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #45 from Winfried Donkers o...@dci-electronics.nl --- (In reply to comment #44) Maybe things have changed but I found a very minimal test case Well, this may help find the cause, which would be very nice. I confirm the behaviour of the minimal test case with openSUSE version 3.6 and with master (on openSUSE 12.3). The way to reproduce the problem may be different, but at least it is reproduceable. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #46 from kouka...@gmail.com --- (In reply to comment #44) I confirm the behaviour with 4.0.2.2 on Kubuntu 12.04 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #47 from Winfried Donkers o...@dci-electronics.nl --- (In reply to comment #45) I forgot to mention: I confirm the behaviour of the minimal test case with version 4.0.3 on Windows. Now we can only hope that this _is_ related to the bug and not a separate anomaly ;) -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #43 from kouka...@gmail.com --- I just had another incident with 4.0.2. Unfortunately I tried to reproduce it but failed. It happened while I was working on sample2. The steps that took place were Edit→Sheet→Select→Ctrl+a(all) and then I did insert columns, merge cells, undo stuff. I was checking the outlining. At some point I pointed with the mouse at the + sign of the outlining but was not pressable. I switched sheets back and forth and outlining was lost on several sheets but not all. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 kouka...@gmail.com changed: What|Removed |Added Version|3.3.2 release |(See in Summary) -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #38 from Winfried Donkers o...@dci-electronics.nl --- (In reply to comment #35) Winfried - does this continue with LibreOffice 4.0 ? Hi Michael, I have a script running daily that checks changed ods files for reduction in size; these files are then checked manually if grouping/notes are missing. So far, the problem has not reoccurred, which is forunate for us (reoccurrence is deadly for the confidence in libreffice of a group of users who still want to go back to MS Office), but not so fortunate for bug fixing ;) Currently, the department using the kind of ods file where the problems occurred use versions 3.5.7 (mainly) and some 3.6.5. Not yet 4.0 as bug 59405 blocks necessary functionality for us (haven't tested 4.0.3 yet though). Should we encounter grouping/notes loss, I will report asap, with version and if possible fods files before and after. (The original ods files cannot be provided to a public site because of client names.) -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #39 from kouka...@gmail.com --- Created attachment 78710 -- https://bugs.freedesktop.org/attachment.cgi?id=78710action=edit sample2 of document with outlining before breakage There has been loss of outlining before in the document history. For what I recall, this one happened after I added some columns and messed up with some undo stuff. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #40 from kouka...@gmail.com --- Created attachment 78711 -- https://bugs.freedesktop.org/attachment.cgi?id=78711action=edit sample2 of document with outlining after breakage There has been loss of outlining before in the document history. For what I recall, this one happened after I added some columns and messed up with some undo stuff. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #41 from Michael Meeks michael.me...@novell.com --- koukasio - did that happen recently - and if so with what version of LibreOffice ? If it is before 3.6, and given that Winfried can't reproduce this in six weeks of work with more recent versions; I'm inclined to close this as 'worksforme' and hope we nailed it in newer versions (though where I don't know). I wonder - could it be related to cut/paste/undo of grouped columns/rows somehow ? :-) -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #42 from kouka...@gmail.com --- (In reply to comment #41) koukasio - did that happen recently - and if so with what version of LibreOffice ? This happened just yesterday! I keep using this feature (even though the dissapointment is big at points) for debugging purposes, in case of an enlightenment... I am still having it in all multisheet files which become a little complex... There has been loss of outlining before in the attached document history. For what I recall, this one happened after I added some columns and messed up with some undo stuff. If it is before 3.6, and given that Winfried can't reproduce this in six weeks of work with more recent versions; I'm inclined to close this as 'worksforme' and hope we nailed it in newer versions (though where I don't know). I am the stable guy who doesn't update distros or software easily. It seems more productive to me to stay focused in my work rather than hunting the edge of things... I will update to 4.0.2 for debugging purposes, but I will be working on the files i've started with 3.5.4.2 . Would that mean anything to you? I wonder - could it be related to cut/paste/undo of grouped columns/rows somehow ? :-) I am very awkwardly suspicious about the undo thing. There's other things that I've noticed when undoing , I wonder if I should report them as bugs. When I want to copy the exact contents of a cell without using absolute references (which I do a lot), I have 3 choices: 1)(cellInsert→Ctrl+A→Ctrl+C→Esc→...→Paste Minor note: This last paste action cannot be undone?!..is never undone, I have to delete the paste manually if I have to... I have this action as a macro assigned to shortcut but it has the same behaviour as the manual one. The behaviour is right when I Ctrl+Shift+V(Paste_special)→Unformatted_Text... This action is only useful for copying contents of a single cell 2)(cell1)...Ctrl+X→Ctrl+Z→(cell2)...Ctrl+V Problem: The reference (cell1) is cut and pasted to cell2 even though I have undone the cut action. That's the reason I don't use this action. 3)(cell1)...Ctrl+X→(cell2)...→Paste→Ctrl+C→Ctrl+Z→Ctrl+Z→(cell2)...→Ctrl+V This action works (for multiple cells), even though I've noticed at awkward points that the reference is cut and pasted as well but I can't reproduce it right now... This action is useful for copying contents of a single or multiple cells but cannot write as a macro... I begun writing this cut/paste/undo comment before you post your question..! Should I report any of these? -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 kouka...@gmail.com changed: What|Removed |Added Hardware|x86 (IA32) |All OS|Windows (All) |All -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #35 from Michael Meeks michael.me...@novell.com --- Winfried - does this continue with LibreOffice 4.0 ? - I had a go at reproducing it; cranked down the undo level to only 2 steps to try to provoke things some more [ no joy ], did a number of random hide/show / column deeletion etc. The sample sheet is rather beautiful ! Thanks for that koukasio ! otherwise, I'm a bit stuck here as others have been; how annoying ! -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 Michael Meeks michael.me...@novell.com changed: What|Removed |Added CC||michael.me...@novell.com --- Comment #36 from Michael Meeks michael.me...@novell.com --- Diffing -u -w the flat-odf of before/after it is interesting to see things like: @@ -1804,8 +1804,6 @@ /table:table-cell table:table-cell table:number-columns-repeated=1015/ /table:table-row -table:table-row-group - table:table-row-group table:table-row table:style-name=ro1 table:table-cell table:style-name=ce6/ table:table-cell table:style-name=ce15 office:value-type=string calcext:value-type=string ie. the data appears un-changed itself - the only omission is the table:table-row-group elements - of which there are exactly zero in the broken file vs. ~400 in the original file. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #37 from Michael Meeks michael.me...@novell.com --- There are several instances of: @@ -10545,8 +10603,7 @@ table:table-cell table:style-name=Default table:number-columns-repeated=6/ table:table-cell table:number-columns-repeated=1015/ /table:table-row -table:table-row-group table:display=false - table:table-row table:style-name=ro1 table:visibility=collapse +table:table-row table:style-name=ro1 table:table-cell table:style-name=Default/ table:table-cell office:value-type=string calcext:value-type=string text:pz/(m)=/text:p @@ -10557,7 +10614,7 @@ table:table-cell table:style-name=Default table:number-columns-repeated=6/ table:table-cell table:number-columns-repeated=1015/ /table:table-row - table:table-row table:style-name=ro1 table:visibility=collapse +table:table-row table:style-name=ro1 table:table-cell table:style-name=Default/ table:table-cell office:value-type=string calcext:value-type=string text:p⇒z/(m)=/text:p The broken document has zero instances of a collapsed table visibility in parallel with it's lack of table-row-group elements; and independent of them. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #32 from Petr Mladek pmla...@suse.cz --- @koukasio: Ah, you set the blocker severity again. I understand that it is a blocker for you but it is not blocker for most other users who do not use this feature. The broader view is important in the time based release process, see https://wiki.documentfoundation.org/Release_Criteria. I am sorry to say but this bug could not and will not block 4.0.1 release and any further bugfix releases. I leave the severity as is because I am not able to persuade you and do not have possibility to make it read only. Any shufling just create mess and is waste of time. The current severity does not reflect reality and will be ignored in the release process decisions. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #33 from kouka...@gmail.com --- (In reply to comment #32) I did nothing, I expect your apology... -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 kouka...@gmail.com changed: What|Removed |Added Severity|blocker |critical -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #34 from kouka...@gmail.com --- (In reply to comment #33) (In reply to comment #32) I did nothing, I expect your apology... Apology is all mine, I was changing the severity of the bug accidentally, maybe something to do with the refreshing of the page in my browser. I am sorry for the mess I've caused. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 kouka...@gmail.com changed: What|Removed |Added Severity|critical|blocker --- Comment #31 from kouka...@gmail.com --- (In reply to comment #29) @koukasio / all How often do you see such problems? all 100 edits? all 10 edits? Only to get an idea how much edits might be needed to have a chance to see something interesting When trying to notice, I keep checking back an forth for any losses. At some point I find it really frustrating to keep checking but there comes a point of breakage. So I can tell you that it is more than 100. 10 sounds too much. Maybe a class of 100-1. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #29 from Rainer Bielefeld libreoff...@bielefeldundbuss.de --- I did some first investigation in contents.xml of sample 2013-03-02 10:36 UTC, kouka...@gmail.com and related broken document. I see that the groups (not unexpectedly) really are lost, compare: CONTENT.XML OK -- table:table-cell table:number-columns-repeated=1015/ /table:table-row table:table-row-group table:table-row-group table:table-row table:style-name=ro1 table:table-cell table:style-name=ce6/ table:table-cell table:style-name=ce15 office:value-type=string BROKEN same area (missing group definition): --- table:table-cell table:number-columns-repeated=1015/ /table:table-row table:table-row table:style-name=ro1 table:table-cell table:style-name=ce6/ table:table-cell table:style-name=ce15 office:value-type=string @koukasio / all How often do you see such problems? all 100 edits? all 10 edits? Only to get an idea how much edits might be needed to have a chance to see something interesting -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 --- Comment #30 from Winfried Donkers o...@dci-electronics.nl --- (In reply to comment #24) I gambled a little around with 3.4.5 (WIN) and fdo39484-sample, ... We have not noticed grouping/notes losses with versions prior to 3.6.4 (all Windows), except possibly once (with version 3.5.something) in November 2012. a) is it 100% clear when the loss happens? In our cases, all losses happened when the document was saved and was noticed when openened the next time. That is to say, grouping (sometimes notes as well) gets lost on a complete sheet, which need not necessarily be the sheet in view. So in some cases, the loss of grouping/notes was only noticed some time later. The groupings (notes) are simply not saved for that sheet, I examinated several backups and studied the xml-content. b) Am I right that normally only some groups are lost and replaced by hiding the rows / columns, but normally not all? It may be that I do not understand your question, but when it happens _all_ grouping (rows and columns) are gone on a sheet. I cannot say whether it happened on one sheet only or or one or more sheets, but it did not happen on all sheets. The sheet(s) with lost grouping (notes) were often not the selected/visible sheets. c) do we have any document set showing a before/after loss. I would prefer something like Winfried Donkers' sample what is simple enough for quick tests (might be with macro aid) Yes, I have several documents before and after as we have a lot of backups. I cannot upload them as they are (the documents include information from customers) to freedesktop. I can upload one or more fods with sensitive information removed, I can also send them (ods) as an attachment to Rainer or Petr directly on the condition that they are used discretely. d) due to fdo39484-sample.ods contains hundreds of ODF errors. Are sample documents with valid ODF 1.2 (strict) available? The documents with which we experienced the grouping/notes loss were all xls-docuemnts (Excel 2000) that were converted to odt in the autumn of 2010 and used with LibreOffice since. So yes, ODF-errors can be expected in the documents. I include 'notes' when I say grouping, as the loss of notes occurs together with the loss of grouping (in the same tab). I cannot say with certainty that grouping loss did not occur without notes loss, but the other way round (notes have not been lost without groups being lost) is definitivelt true. We have 8 people editing a total of 20-100 of calc-documents like the fdo39484-sample. Some are edited several time a day, some only once a year. We only noticed the data loss since December, 2012 and only found two documents which suffered data loss (we checked more than 50 of these documents that were modified in November/December 2012 and January 2013). One of these two documents, suffered data loss several times. My suspect is that it is a combination of document-content (ODF-error?) and FILESABE handling of LibreOffice. The people that edit these two documents regularly have downgraded to version 3.5.7. Since then we have not noticed grouping/notes losses. As it looks to me that it is document-related, the ratio with which the bug happens could be less than 1/1000 for documents in general or 1/10 (a guess) for susceptible documents. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 39484] All Outline groups of sheet lost while editing
https://bugs.freedesktop.org/show_bug.cgi?id=39484 Rainer Bielefeld libreoff...@bielefeldundbuss.de changed: What|Removed |Added Summary|Outline groups are lost |All Outline groups of sheet |while editing or after |lost while editing |re-opening a spreadsheet| --- Comment #28 from Rainer Bielefeld libreoff...@bielefeldundbuss.de --- @koukasio (In reply to comment #25): Thank you, that helps a lot. I will do some tests and research with your documents asap (unfortunately rather busy currently). @all: Can you please submit separate bugs for all similar problems what are not loss of all groups during workflow weth related to this one? Although all these problems might have the same roots, dividing the problem into smaller parts might ease tests and finding those roots. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs