https://bugs.documentfoundation.org/show_bug.cgi?id=168864
Bug ID: 168864
Summary: Writer chart highlighting not sorting with the lines
Product: LibreOffice
Version: 25.8.1.1 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Writer
Assignee: [email protected]
Reporter: [email protected]
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.
--
You are receiving this mail because:
You are the assignee for the bug.
