[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Eike Rathke er...@redhat.com changed: What|Removed |Added Blocks||85490 See

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Eike Rathke er...@redhat.com changed: What|Removed |Added See Also|https://bugs.freedesktop.or |

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Eike Rathke er...@redhat.com changed: What|Removed |Added See Also|https://bugs.freedesktop.or |

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Eike Rathke er...@redhat.com changed: What|Removed |Added Status|NEEDINFO|RESOLVED

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 --- Comment #45 from Eike Rathke er...@redhat.com --- Please redo comparisons of 4.4 against earlier releases or Excel with a build of today or later, especially regarding the UpdateReferenceOnSort=false case. Anything else is moot. -- You are

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Joel Madero jmadero@gmail.com changed: What|Removed |Added CC|jmadero@gmail.com | --- Comment #44

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 --- Comment #42 from Luke lukebe...@hotmail.com --- Created attachment 108542 -- https://bugs.freedesktop.org/attachment.cgi?id=108542action=edit Comparision of Calc 4.4 vs Excel with Decending sorting A1:M500 This feature enhancement should

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 --- Comment #43 from Luke lukebe...@hotmail.com --- Created attachment 108549 -- https://bugs.freedesktop.org/attachment.cgi?id=108549action=edit RainersSample comparison 4.4 vs 4.2 vs Excel Sorting RainersSample in 4.4 shows how implementing

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added See Also|

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added Status|RESOLVED|REOPENED

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added Status|REOPENED|NEEDINFO

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Laurent BP jumbo4...@yahoo.fr changed: What|Removed |Added Resolution|WORKSFORME |FIXED --- Comment #38

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 --- Comment #39 from helplibreoff...@mailcatch.com --- While testing this issue, I found an unrelated issue (82915), and creating a separate bug report for that. When doing so, I realized that the spreadsheet I posted in post #27 of this thread

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 --- Comment #37 from helplibreoff...@mailcatch.com --- @Laurent BP: To clarify, did you verify this bug, or verify that the functionality is correct? How should the status be updated? -- You are receiving this mail because: You are the

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 --- Comment #36 from Laurent BP jumbo4...@yahoo.fr --- Verified with versions: - Version: 4.2.7.0.0+ Build ID: 8de2e9b4bc53e6c097897142bad223c100d36292 TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-08-08_21:42:21 - Version: 4.3.2.0.0+

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 --- Comment #35 from helplibreoff...@mailcatch.com --- Is this still RESOLVED WORKSFORME, or should it marked be UNCONFIRMED? -- You are receiving this mail because: You are the assignee for the bug.

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 --- Comment #34 from helplibreoff...@mailcatch.com --- Created attachment 103002 -- https://bugs.freedesktop.org/attachment.cgi?id=103002action=edit Demonstration of bug Sorting causes the formulas in the attached file to get messed up in

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Winfried Donkers winfrieddonk...@libreoffice.org changed: What|Removed |Added Status|UNCONFIRMED

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 --- Comment #32 from Kohei Yoshida libreoff...@kohei.us --- FYI, Bug 81309 might help. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 --- Comment #25 from Joel Madero jmadero@gmail.com --- Bugs are fixed by volunteers. Priority/Severity is just used to give pointers to the developers but even if it's marked Critical - Highest, developers can choose not to fix it (this is a

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Eike Rathke er...@redhat.com changed: What|Removed |Added Status|NEW |RESOLVED

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Eike Rathke er...@redhat.com changed: What|Removed |Added Status|RESOLVED|CLOSED -- You are

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 helplibreoff...@mailcatch.com changed: What|Removed |Added Status|CLOSED |REOPENED

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 --- Comment #27 from helplibreoff...@mailcatch.com --- I've created an easily duplicated spreadsheet that illustrates what I think may be a problem. I'm not sure if it matches the bug described in this (45156) or if it represents a different

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Joel Madero jmadero@gmail.com changed: What|Removed |Added Status|REOPENED|RESOLVED

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Joel Madero jmadero@gmail.com changed: What|Removed |Added Status|RESOLVED|CLOSED -- You are

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 helplibreoff...@mailcatch.com changed: What|Removed |Added Status|CLOSED |REOPENED

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Joel Madero jmadero@gmail.com changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Joel Madero jmadero@gmail.com changed: What|Removed |Added Status|REOPENED|NEEDINFO --- Comment

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 --- Comment #31 from helplibreoff...@mailcatch.com --- Thanks for your apology Joel. Accepted. And I apologize if I came across as too harsh. This is a tricky bug and how to report it is tricky as well because the correct behavior here may be

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 --- Comment #22 from helplibreoff...@mailcatch.com --- This is a severe bug because you wind up with a spreadsheet with the wrong results. It makes the sort function largely useless. -- You are receiving this mail because: You are the assignee

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 helplibreoff...@mailcatch.com changed: What|Removed |Added Severity|normal |critical

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Joel Madero jmadero@gmail.com changed: What|Removed |Added Severity|critical|normal

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 --- Comment #24 from helplibreoff...@mailcatch.com --- Given that this results in spreadsheets with erroneous values, how does it become escalated to a higher priority/severity? -- You are receiving this mail because: You are the assignee for

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 --- Comment #20 from Kohei Yoshida libreoff...@kohei.us --- (In reply to comment #19) This bug report concerns only sorting internal references to the *same* sheet, which does not appear working in any spreadsheet. So I'm sure there is an

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 --- Comment #21 from Laurent BP jumbo4...@yahoo.fr --- (In reply to comment #20) (In reply to comment #19) This bug report concerns only sorting internal references to the *same* sheet, which does not appear working in any spreadsheet. So

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 --- Comment #16 from Winfried Donkers winfrieddonk...@libreoffice.org --- from bug 79441: 'It is broken from the old time, and none spreadsheet I tested (AOO, Excel) are able to fix it. I'm not sure it is possible.' Excel does sort correctly

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 --- Comment #17 from Laurent BP jumbo4...@yahoo.fr --- Created attachment 100278 -- https://bugs.freedesktop.org/attachment.cgi?id=100278action=edit Test file to sort descending on column A (In reply to comment #16) from bug 79441: 'It is

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Winfried Donkers winfrieddonk...@libreoffice.org changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 --- Comment #19 from Laurent BP jumbo4...@yahoo.fr --- (In reply to comment #18) -when the reference is absolute and on the same row (attachment 100278 [details], range A24:C28) sorting goes well in Excel _and_ in Calc. OK. No problem if

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Laurent BP jumbo4...@yahoo.fr changed: What|Removed |Added See Also|

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Winfried Donkers winfrieddonk...@libreoffice.org changed: What|Removed |Added See Also|

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Winfried Donkers winfrieddonk...@libreoffice.org changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 --- Comment #14 from Winfried Donkers winfrieddonk...@libreoffice.org --- Created attachment 84629 -- https://bugs.freedesktop.org/attachment.cgi?id=84629action=edit file with 3 different behaviours when sorting attached file shows 3 different

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Winfried Donkers winfrieddonk...@libreoffice.org changed: What|Removed |Added Version|3.6.5.2 release

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 --- Comment #12 from Joel Madero jmadero@gmail.com --- *** Bug 64647 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug. ___

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 ign_christian ign_christ...@yahoo.com changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Joel Madero jmadero@gmail.com changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Joel Madero jmadero@gmail.com changed: What|Removed |Added CC||kohei.yosh...@suse.de

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Joel Madero jmadero@gmail.com changed: What|Removed |Added CC||p...@computer.org

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Joel Madero jmadero@gmail.com changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Joel Madero jmadero@gmail.com changed: What|Removed |Added Hardware|x86 (IA32) |All

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 --- Comment #6 from Joel Madero jmadero@gmail.com --- Rainer -any update on this one? -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Joel Madero jmadero@gmail.com changed: What|Removed |Added CC||jmadero@gmail.com

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 mohican mohi...@ouvaton.org changed: What|Removed |Added CC||mohi...@ouvaton.org ---

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 --- Comment #4 from mohican mohi...@ouvaton.org --- Created attachment 76045 -- https://bugs.freedesktop.org/attachment.cgi?id=76045action=edit test case showing simple formula becoming broken after simple sort I made this test case

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 mohican mohi...@ouvaton.org changed: What|Removed |Added OS|Windows (All) |All

[Libreoffice-bugs] [Bug 45146] EDITING: references in formulas do not follow referenced values to new location during sort

https://bugs.freedesktop.org/show_bug.cgi?id=45146 Rainer Bielefeld libreoff...@bielefeldundbuss.de changed: What|Removed |Added Summary|: Sort column