Description: Imported a word file with chart table [like excel only made in word] I made with color coding on certain rows and in certain cells. In MS Word, you can custom sort the rows by various columns, and the colors stay with the row. I tried to do the same with the document imported into Writer, and when I change the sort order, the colors "stay put" but the rows sort, and rows end up with colors they weren't meant to. For example, a chart with Pennsylvania towns were coded blue, and towns in Ohio coded yellow, sorted by state, all the blue was together, all the yellow was together. Then I sorted the order by towns, and what should have happened was a mix of blue and yellow, but instead the rows sorted and the colors stayed where they were, putting Ohio in blue areas and Pennsylvania in yellow. Likewise, a third column has a yes/no color code of green for yes, red for no. When I sorted, these colors didn't move with the rows either, so everything in the new order was "wrong," with the color-coding system I had. When I put the same chart in calc, it sorts the way it is supposed to. But not in Writer. Yet MS Word sorts properly and the highlighting shuffles with the sorting and sticks with the rows they are meant to be on, whatever the order. This ideally should happen in Writer. But it did not, at least not for me. I am not sure if it was because it began as an imported document, I have not tried to "remake" the chart in Writer from scratch, since the chart is rather extensive. Steps to Reproduce: 1.Make a chart table in Word,and use "fill color" to color rows and cells with different colors to color code [Don't use the highlighters]. At least two different colors in different rows to identify two different types of information. Make sure you have at least 3 columns with different information, and maybe 6 rows just to make sure the colors are moving with the info in the rows. 2.Import into Writer. 3.Try to sort the rows by different columns. Pay attention to whether the colors given to each row move with the row,or stay put when the rows move. Actual Results: When rows were sorted, the colors stayed where they were but the info in the line sorted, landing the row on a color that was entered and meant for another row. The color coding stayed in the same position, and the rows got sorted, and we end up with the wrong colors on the wrong rows after sorting by a different column. Expected Results: What should happen is if I put blue on rows 1, 2 and 3, and yellow on rows 4, 5 and six when they are sorted by column 1, when I sort by column 2, there should be some mixture of yellow and blue rows, and 1, 2, and 3 should still be blue, whatever order they end up in after sorting. 4, 5, and 6 should still be yellow, whatever order they are in. But what happened was the rows shuffled, but the colors did not go with them.The top 3 rows were still blue, even though the info in them had changed. The last 3 were still yellow, but the info in them had changed. The color-coding did not move with the rows, making the color-coding system useless. Reproducible: Didn't try User Profile Reset: No Additional Info: The sorting goes properly in Calc. What I ended up doing was recopying the Word table into Calc, and I was able to resort the chart/table there,and recopy it back into Writer. But you really should be able to do the same thing in Writer. You can do it in MS Word. I should not have to go into another program to sort a table to keep the color-coded lines "with" the color coding.
Created attachment 203346 [details] A test page I made that shows the problem imported from Word to Writer In my description of the problem I had a chart that had states and towns, but substitute "towns" for "bird names" in this chart. The chart as it is has color coding that is meant to stay with the rows. If you sort the rows by column one rather than 2, the color-coding stays put, and the rows move, which then makes the color coding useless, because it puts things in the wrong areas. Attached is the docx file. It is a test sample I made, it is actually not the original document, but it is doing the same thing as the first one, which was too long to attach. If I can attach more pictures, I will, but this is the first time I have posted here and I don't know how many attachments I can add.
Created attachment 203347 [details] Picture of the original sort order This is a png of the original sort order, sorted by state.
Created attachment 203348 [details] Picture of the ill-sorted chart, with rows moved but colors stayed put This is what it is doing that it should not be doing. The chart is sorted by bird names now. The colors should sort with the line. But instead the colors are exactly where they were in the original, but the rows have moved but the colors did not, making the color-coding irrelevant and wrong. In MS Word, the colors "stick with the row". In Calc, they stick with the row they were put in. But in Writer it isn't keeping the colors with the row. I will attach a third picture with what this chart "should" look like if Writer is doing what Word does when you sort.
Created attachment 203349 [details] What it should look like when sorting This is what the sort "should" look like when I resort by column 1. The color coding stays with the row. Pennsylvania is still blue, Ohio is still yellow, yes is still green and no is still red. I took this screenshot from Calc, not Writer. But MS Word will do this with the chart, without having to go out to excel to sort and come back. Writer should be able to do this without having to go out to Calc and sort it and come back to paste. I feel.
(In reply to rlubert619 from comment #0) > Description: > Imported a word file with chart table [like excel only made in word] I made > with color coding on certain rows and in certain cells. In MS Word, you can > custom sort the rows by various columns, and the colors stay with the row. I > tried to do the same with the document imported into Writer, and when I > change the sort order, the colors "stay put" but the rows sort, and rows end > up with colors they weren't meant to. For example, a chart with Pennsylvania > towns were coded blue, and towns in Ohio coded yellow, sorted by state, all > the blue was together, all the yellow was together. Then I sorted the order > by towns, and what should have happened was a mix of blue and yellow, but > instead the rows sorted and the colors stayed where they were, putting Ohio > in blue areas and Pennsylvania in yellow. Likewise, a third column has a > yes/no color code of green for yes, red for no. When I sorted, these colors > didn't move with the rows either, so everything in the new order was > "wrong," with the color-coding system I had. When I put the same chart in > calc, it sorts the way it is supposed to. But not in Writer. Yet MS Word > sorts properly and the highlighting shuffles with the sorting and sticks > with the rows they are meant to be on, whatever the order. This ideally > should happen in Writer. But it did not, at least not for me. I am not sure > if it was because it began as an imported document, I have not tried to > "remake" the chart in Writer from scratch, since the chart is rather > extensive. > > Steps to Reproduce: > 1.Make a chart table in Word,and use "fill color" to color rows and cells > with different colors to color code [Don't use the highlighters]. At least > two different colors in different rows to identify two different types of > information. Make sure you have at least 3 columns with different > information, and maybe 6 rows just to make sure the colors are moving with > the info in the rows. > 2.Import into Writer. > 3.Try to sort the rows by different columns. Pay attention to whether the > colors given to each row move with the row,or stay put when the rows move. > > Actual Results: > When rows were sorted, the colors stayed where they were but the info in the > line sorted, landing the row on a color that was entered and meant for > another row. The color coding stayed in the same position, and the rows got > sorted, and we end up with the wrong colors on the wrong rows after sorting > by a different column. > > Expected Results: > What should happen is if I put blue on rows 1, 2 and 3, and yellow on rows > 4, 5 and six when they are sorted by column 1, when I sort by column 2, > there should be some mixture of yellow and blue rows, and 1, 2, and 3 should > still be blue, whatever order they end up in after sorting. 4, 5, and 6 > should still be yellow, whatever order they are in. But what happened was > the rows shuffled, but the colors did not go with them.The top 3 rows were > still blue, even though the info in them had changed. The last 3 were still > yellow, but the info in them had changed. The color-coding did not move with > the rows, making the color-coding system useless. > > > Reproducible: Did try - and it did the same thing. Original chart was 73 pages long so I redid a smaller chart. Did the same thing. > > > User Profile Reset: No > > Additional Info: > The sorting goes properly in Calc. What I ended up doing was recopying the > Word table into Calc, and I was able to resort the chart/table there,and > recopy it back into Writer. But you really should be able to do the same > thing in Writer. You can do it in MS Word. I should not have to go into > another program to sort a table to keep the color-coded lines "with" the > color coding.
I can confirm that the bug is present in master. Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 620(Build:0) CPU threads: 12; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win Locale: en-US (en_FI); UI: en-GB Calc: threaded I also tried doing the same table from scratch in Writer and sorted the values. The result shows that the color stays on the same position. Steps to Reproduce: 1. Make the table in Writer. 2. Sort the values Actual Result: Values are sorted but the colors stays on the same position. Expected Result: The colors should move along with the values.
*** This bug has been marked as a duplicate of bug 48292 ***