Download it now!
Bug 100517 - Comment-only cells not moving with data when sorting
Summary: Comment-only cells not moving with data when sorting
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Dennis Francis
Whiteboard: target:5.3.0
Depends on:
Reported: 2016-06-21 13:58 UTC by David Remelts
Modified: 2016-10-24 11:32 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description David Remelts 2016-06-21 13:58:35 UTC

Comment 1 David Remelts 2016-06-21 14:17:39 UTC
If a sort range contains a column with cells that have comments embedded in them and there are NO cells in that column containing numbers, text, formulas, etc, the column with the comments won't be sorted with the rest of the data.  
So, the comments will no longer be associated with the original row.


Pre sort:
Col A      Col B
Text A     Comment1
Text B     Comment2
Text C     Comment3

After sort on Col A:
Col A      Col B
Text C     Comment1
Text B     Comment2
Text A     Comment3

Note: This may be related to Bug 42705 & 45471
Comment 2 m.a.riosv 2016-06-21 21:31:02 UTC
Version: (x64)
Build ID: f99d75f39f1c57ebdd7ffc5f42867c12031db97a
CPU Threads: 1; OS Version: Windows 6.19; UI Render: GL;
Comment 3 Commit Notification 2016-10-24 11:29:14 UTC
Dennis Francis committed a patch related to this issue.
It has been pushed to "master":

tdf#100517 : Optionally include comment-only columns when sorting

It will be available in 5.3.0.

The patch should be included in the daily builds available at in the next 24-48 hours. More
information about daily builds can be found at:

Affected users are encouraged to test the fix and report feedback.