Bug 131997 - Create chart dialog/wizard should restrict the data selection to the actualy used range of the sheet
Summary: Create chart dialog/wizard should restrict the data selection to the actualy ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All Windows (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf
Depends on:
Blocks: Chart
  Show dependency treegraph
 
Reported: 2020-04-09 11:24 UTC by Alain Brion
Modified: 2020-09-22 19:39 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 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.