Bug 152557 - Chart data range reduces range / removes cell when adding series, shifts labels
Summary: Chart data range reduces range / removes cell when adding series, shifts labels
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Chart
  Show dependency treegraph
 
Reported: 2022-12-16 19:04 UTC by Stéphane Guillou (stragu)
Modified: 2023-01-03 11:15 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Stéphane Guillou (stragu) 2022-12-16 19:04:57 UTC
When modifying a chart data range that is not entirely rectangular, the smaller range is further reduced upon saving, ultimately losing data in the chart.

Steps:
1. Open attachment 183259 [details]
2. Open data ranges dialog
3. Add ";Table1.C1:C4" to the range to add a series
4. See that extra bar was added
5. Reopen data ranges dialog to see that range was simplified to "Table1.A2:A4;Table1.B1:E4" (still only top-left cell excluded from range)


Result 1:
"A" label is gone, other labels are shifted to the left, even though the range still says cell A2 is included.

6. Save, reload

Result 2:
Data range was updated to "Table1.A3:A4;Table1.B1:E4" (i.e. two top cells of column A have been excluded), which matches the glitch witnessed in the chart.

In:

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 4e4a31ac7d920c71e26ca4acd18c11ec2bd015bb
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

Also in OOo 3.3:

OpenOffice.org 3.3.0
OOO330m20(Build:9567)
Comment 1 Buovjaga 2023-01-03 11:15:05 UTC
Repro

Arch Linux 64-bit, X11
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 88ebc324a51f16df0248d6a0d53d2169b1995dda
CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded Jumbo
Built on 3 January 2023