Bug 131997

Summary: Create chart dialog/wizard should restrict the data selection to the actualy used range of the sheet
Product: LibreOffice Reporter: Alain Brion <bugmoz>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: enhancement CC: miguelangelrv
Priority: medium Keywords: perf
Version: unspecified   
Hardware: All   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 90486    

Description Alain Brion 2020-04-09 11:24:39 UTC 
When you select a full column for data series in graphics, the rendering of the graphing is very slow and the file becomes huge, although the total data is tiny

To reproduce
------------

new calc file
enter numbers in A1, A2, B1, B2
create a new graph
Select a full column as series data (say $Sheet1.$A:$A, you must edit manually, calc does not let you select a whole comuln)

Everything becomes very slow. When saving, it makes a 3 MB file

In my case, it happened after converting an EXCEL file.

Wished behavior
---------------
The graphics engine should restrict the data selection to the actualy used range of the sheet
Comment 1 m_a_riosv 2020-04-09 14:07:14 UTC 
Agree, it's more a enchancement request than a bug.