Bug 152557

Summary: Chart data range reduces range / removes cell when adding series, shifts labels
Product: LibreOffice Reporter: Stéphane Guillou (stragu) <stephane.guillou>
Component: ChartAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: ilmari.lauhakangas
Priority: medium    
Version: Inherited From OOo   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=151753
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 90486    

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