[Libreoffice-bugs] [Bug 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 Eike Rathke er...@redhat.com changed: What|Removed |Added See Also|https://bugs.freedesktop.or | |g/show_bug.cgi?id=81633 | Resolution|DUPLICATE |FIXED --- Comment #24 from Eike Rathke er...@redhat.com --- For the records, 4.2.8 and 4.3.5 will restore the old behavior, for 4.4 the UpdateReferenceOnSort option will default to false/unchecked for compatibility. -- 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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 Eike Rathke er...@redhat.com changed: What|Removed |Added Blocks||85490 -- 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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 Alex Thurgood ipla...@yahoo.co.uk changed: What|Removed |Added Keywords||regression --- Comment #13 from Alex Thurgood ipla...@yahoo.co.uk --- Sort and update work in Version: 4.1.4.2 Build ID: 0a0440ccc0227ad9829de5f46be37cfb6edcf72 therefore regression -- 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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 --- Comment #19 from MICKRU i...@michael-krueger.org --- Fair enough - I do not understand what the original bug was. It can't be that the bug is that one feels that its unexpected that referenced cells worked as in 4.2.6 which was that sorting was updating references. Because that to me is not a bug but was expected behavior ... -- 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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 --- Comment #20 from Jean-Baptiste Faure jbfa...@libreoffice.org --- (In reply to Joel Madero from comment #18) This is literally like asking for a bug to be reintroduced into LibreOfficeKohei was nice enough to add an option for users to bring the bug back if they so choose. I disagree. It is _not always_ a bug. The difficulty is to know when in which case it is a bug and in which case it is a feature. That is the reason why a configuration option was necessary. Please try again my test file in bug 81633. I asked the ESC to consider the decision to revert this commit for branches 4.2 and 4.3. Best regards. JBF -- 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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 --- Comment #21 from Joel Madero jmadero@gmail.com --- It will not be backported - there is a new string involved - translation and all that fun stuff. So 4.4 it is. -- 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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 --- Comment #22 from ign_christian ign_christ...@yahoo.com --- (In reply to Jean-Baptiste Faure from comment #20) I asked the ESC to consider the decision to revert this commit for branches 4.2 and 4.3. Hope that reverting commits is possible. Unless we're facing dozens new bug report with similar issue until early 2015 and after 4.2.7 released. -- 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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 --- Comment #23 from Joel Madero jmadero@gmail.com --- Also not reverting the commit . . . removing myself from cc -- 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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added See Also||https://bugs.freedesktop.or ||g/show_bug.cgi?id=81633 -- 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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 --- Comment #12 from Alex Thurgood ipla...@yahoo.co.uk --- Confirming on Version: 4.3.2.2 Build ID: edfb5295ba211bd31ad47d0bad0118690f76407d OSX 10.9.5 1) Open attachment of comment 10 2) Sort on master sheet with Lastname ascending - data sorted accordingly 3) Click on Dependent sheet - note that data has not been sorted -- 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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 Alex Thurgood ipla...@yahoo.co.uk changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0 |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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 Alex Thurgood ipla...@yahoo.co.uk changed: What|Removed |Added Priority|medium |highest Severity|normal |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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 --- Comment #14 from ign_christian ign_christ...@yahoo.com --- (In reply to Alex Thurgood from comment #12) 1) Open attachment of comment 10 2) Sort on master sheet with Lastname ascending - data sorted accordingly 3) Click on Dependent sheet - note that data has not been sorted Looks similar with Bug 84055 which is marked as not a bug. New sorting behavior since 4.3.1 and 4.2.7 Perhaps this report should also be closed. -- 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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 --- Comment #15 from Alex Thurgood ipla...@yahoo.co.uk --- (In reply to ign_christian from comment #14) Looks similar with Bug 84055 which is marked as not a bug. New sorting behavior since 4.3.1 and 4.2.7 Perhaps this report should also be closed. Unfortunately, yes, but as a duplicate of 81633 (which is weird because actually much later bug declaration) - the behaviour will be configurable in LO 4.4 release and will not be backported - see bug 81663 for more details. Sigh. -- 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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 Alex Thurgood ipla...@yahoo.co.uk changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |DUPLICATE --- Comment #16 from Alex Thurgood ipla...@yahoo.co.uk --- *** This bug has been marked as a duplicate of bug 81633 *** -- 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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 --- Comment #17 from MICKRU i...@michael-krueger.org --- Too bad that I need this for my work... I tend to agree to some other guy saying that this basic functionality (not updating references) should not have been introduced in the first place on the otherwise wonderful working calc on the 4.2 branch. But what can I say. The guy that had the desire to get this for me intuitive and natural working thing removed from a stable version came first and won. If I would have a vote: revert that change, and have the new configurable feature introduced with V4.4. Anyway I appreciate that you are having a look at my issues. Thank you 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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 --- Comment #18 from Joel Madero jmadero@gmail.com --- This is literally like asking for a bug to be reintroduced into LibreOfficeKohei was nice enough to add an option for users to bring the bug back if they so choose. Anyways - feel free to download a daily 4.4 build or of course wait for 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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 Robinson Tryon (qubit) qu...@runcibility.com changed: What|Removed |Added Whiteboard|BSA, deleterequest |BSA deleterequest CC||qu...@runcibility.com --- Comment #7 from Robinson Tryon (qubit) qu...@runcibility.com --- Removing comma from whiteboard (please use a space to delimit values in this field) https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Whiteboard#Getting_Started -- 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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 MICKRU i...@michael-krueger.org changed: What|Removed |Added Status|NEEDINFO|REOPENED --- Comment #8 from MICKRU i...@michael-krueger.org --- (In reply to comment #6) It is impossible to test further without a test file. If you still encounter this bug with current stable version, could you attach an anonymized version of your original file ? An easy mean to anonymize your file is to replace all alphabetical character by x and numerical character by 9. Thank you for your understanding. Best regards. JBF I just tested the bug with the lastest release of 4.3.1 and it got worse. Sorting does not at all work on dependent tables. I added again a sample 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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 --- Comment #9 from MICKRU i...@michael-krueger.org --- Created attachment 105788 -- https://bugs.freedesktop.org/attachment.cgi?id=105788action=edit Sample file to reproduce the bug of sorting Comments are in the file. Can be used to reproduce the issue. File working well with 4.1 release and is not working with 4.2 or 4.3 releases of LibreOffice. -- 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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 --- Comment #10 from MICKRU i...@michael-krueger.org --- Created attachment 105789 -- https://bugs.freedesktop.org/attachment.cgi?id=105789action=edit File working with 4.2.4.2 - but not with newer Office suite I just realized that the 4.3.1 messed up my test file I uploaded before. This one is working with 4.2.4.2 just fine, but breaks e.g. with 4.2.5 or 4.3.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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added Status|REOPENED|NEEDINFO --- Comment #11 from Jean-Baptiste Faure jbfa...@libreoffice.org --- set back status to UNCONFIRMED -- 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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- 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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 --- Comment #6 from Jean-Baptiste Faure jbf.fa...@sud-ouest.org --- It is impossible to test further without a test file. If you still encounter this bug with current stable version, could you attach an anonymized version of your original file ? An easy mean to anonymize your file is to replace all alphabetical character by x and numerical character by 9. Thank you for your understanding. Best regards. JBF -- 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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 Joel Madero jmadero@gmail.com changed: What|Removed |Added Whiteboard|BSA |BSA, deleterequest CC||jmadero@gmail.com -- 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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 --- Comment #5 from Tollef Fog Heen tfh...@err.no --- The content of attachment 84641 has been deleted by Tollef Fog Heen tfh...@err.no who provided the following reason: Confidential The token used to delete this attachment was generated at 2014-05-05 15:33:48 UTC. -- 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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 Jean-Baptiste Faure jbf.fa...@sud-ouest.org changed: What|Removed |Added Attachment #84641|0 |1 is obsolete|| -- 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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 --- Comment #4 from MICKRU i...@michael-krueger.org --- One more thing. The behavior looks to me, as if in 4.0.x releases clears table cells on dependent sheets before filling them again. Thats why the functional roles appear correct in that release. In 4.1 releaes this seems to have been optimized such that cell data is overwritten with the new data depending on sorting results. However if an empty cell is put on top of a cell that previously contained data, then the cell content is no longer cleared. Therefore in 4.1.x the sorting appears broken in the dependent sheets for columns that do not contain data in every cell. Does this make sense? -- 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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 --- Comment #3 from MICKRU i...@michael-krueger.org --- Hi, thanks for having a look at my issue. I appreciate this very much. I just downloaded LibreOffice 4.1.3.2 and can confirm that the T(..) function now seems to work, because the mailto: URIs on the master sheet will produce the email address as text on the sheet called AdressListe. So one issue is remaining. The sheet is used for our voluntary fire-fighter department. For this we hand out the telephone/address list to all members of the fire-fighters. The sheet called TelefonListe should be sorted using the column Fkt-Sort. The goal is to have all people that have a specific role in the fire department at the top of the TelefonListe sheet so that their phone numbers are listed first. The lastname column on the master sheet is used to sort the sheet AddressList in alphabetical order based on the peoples last name. I can confirm that the sorting bug remains in the 4.1.3.2 version while in 4.0.4 it is working well. This is what you need to do: 1) Go on the master sheet and sort by lastname. 2) Verify that the members are sorted on the TelefonListe and AdressListe sheets in alphabetical order. Especially in the TelefonListe the functional role of the people should be the same on the master and on the TelefonListe. 3) I now print the AdressListe sheet to have that sheet in alphabetical order. 4) Next I use the Fkt-Sort column on the master sheet to sort the list based on the functional role of the fire-fighters. 5) Now you go on the TelefonListe sheet to see if the list has been sorted. With 4.1.3.2 the names are sorted correctly, but the column with the functional roles is not. When I use the release 4.0.4 the functional roles are sorted correct and reflect the order on master sheet. Hope this helps you to figure out whats going wrong here. Regards and many thanks, Michael -- 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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 Jean-Baptiste Faure jbf.fa...@sud-ouest.org changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||jbf.fa...@sud-ouest.org Ever confirmed|0 |1 --- Comment #1 from Jean-Baptiste Faure jbf.fa...@sud-ouest.org --- Please, could explain step by step what to do on your file to reproduce the problem? Your file opens without problem with versions 4.2.0.0.beta2+, 4.1.5.0+ and 4.0.6 under Ubuntu 13.10 x86-64 Best regards. JBF -- 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 68566] EDITING: Cross references between tables / cell data broken
https://bugs.freedesktop.org/show_bug.cgi?id=68566 GerardF gerard.farg...@orange.fr changed: What|Removed |Added CC||gerard.farg...@orange.fr --- Comment #2 from GerardF gerard.farg...@orange.fr --- What I understand: 1st presume bug: The T() function returns an empty string instead off the cell text when cell contains an URL. 2nd presume bug: When sorting master sheet, other sheets are not refreshed. Both presume bug are not reproducible with 4.1.3. Update with a most recent vesion and tell us if you still 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
