https://bugs.documentfoundation.org/show_bug.cgi?id=120384
--- Comment #4 from matthewn...@yahoo.co.uk ---
Another way to break an x,y scatter plot Chart.
(prevents updating when series data is modified).
1.On a Bionic Beaver+LO 6.0.6.2 spreadsheet, several scatter plot Charts are
inserted on one sheet using columns for the series.
2.The toolbar for drawing is enabled.
3.Two ordinary lines are added on one Chart (on the data plots area). A
typical procedure is then to need one line parallel; one of the two lines is
selected for copy, then pasted onto the same plots area of the same Chart.
4.Clicking off the plots grid, off the Chart Zone area, elsewhere on the sheet
to continue with other work - the Chart is broken (updating of parent cells
fails to move the plots).
5.The other Charts on the same sheet still autoupdate.
6.Workaround (with difficulty). The damaged Chart needs to be reconstructed.
If much work has been done and there are dozens of Charts discovered later to
be broken, the whole spreadsheet is "saved as" format .xlsx.
7.Working on the .xlsx file - all the Charts function (autoupdates).
8.If the user tries to save that working .xlsx file by "save as" new.ods under
a new name, when opening the new.ods all data plot symbols on all Charts are
changed to coloured diamonds - except for the broken Chart (which has it's
original plot shapes and colours). The Chart (that worked in .xlxs) is still
broken in the new .ods file.
9.Restarting Calc in safe mode enables all use of the Charts, yet in normal
mode the Chart in question is still broken.
10.All restart in safe mode proposed changes are attempted; the one that makes
the new.ods file fully functional is "Reset to factory settings - Reset
settings and user interface modifications".
11.The user can then restart in normal mode, prepare their profile (measure in
cm, autospellcheck off etcetera) and edit the whole new.ods spreadsheet to
correct the symbols and colours used in scatter plots.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
