https://bugs.freedesktop.org/show_bug.cgi?id=85548
Bug ID: 85548
Summary: slow FILESAVE and slow to exit from editing large
chart; only when name for data series spans more than
one cell (ie "Name In Range")
Product: LibreOffice
Version: 4.2.6.3 release
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: j...@compsci.corklab.com
Created attachment 108561
--> https://bugs.freedesktop.org/attachment.cgi?id=108561&action=edit
Testfile showing slowdown (~3000 point xy-dataset with chart)
Hello,
Given a LibreOffice CALC spreadsheet with ~3000 x-y data points in columns
(attached):
I create a chart (xy scatter) of the dataset,
and when I edit the range pointed to for the name of the Data Series (Name In
Range =...) such that this range now spans more than one cell (eg
$Sheet1.$D$3:$E$3) then suddenly...
the time taken for saving the file and
the time taken for exiting from the chart editor mode (after trivial change)
... both suddenly jump from a few(handful) seconds previously, to a painful
30sec for the absolute simplest(!) spreadsheet or >60sec for any real-world
analytical sheet.
This did not used to happen with LO CALC 4.1.6, which I used up to now; but it
did occur when I tried some 4.2 version a few months ago(I'm afraid I don't
know the exact version I was trying out at the time --- I reverted to 4.1.6 so
as to continue working)
[NB operating performance is otherwise perfectly acceptable so far with
4.2.6.3; Win7 32bit; dualcore 2GHz; 2GB RAM]
## Testfile illustrating the slowdown is attached:
SlowdownWhenSeriesNameSpans2Cells.ods ##
In the attachment, there are data in columns B and C, an xy-scatter plot of
these and a name for the data series in two cells at D3:E3 == "PrefixSpec
Sample Spec".
If a trivial modification is made to the chart (eg resize slightly; edit text
of axis-title; etc) then exiting the chart edit mode takes ~30 seconds for me.
Saving any changes to the file, also takes ~30 seconds.
The inordinate slowdown is removed by editing the chart, such that the name of
the data series is pointed to just one cell eg E3 == "SampleSpec"...
ie<DoubleClick chart> >> Data Ranges >> Data Series >> Select 'Name' >> Range
For Name >> click button to 'select data range', select cell E3 >> OK.
Regards, John.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
