https://bugs.documentfoundation.org/show_bug.cgi?id=120384
Bug ID: 120384
Summary: EDITING. Mouse error or user slip onto sheet tab
causes complete empty of that idle sheet contents and
breaks auto-update of all Charts on the active sheet.
Product: LibreOffice
Version: 6.0.6.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
The Charts affected are no longer able to be modified and checked unless the
user moves the graphic around the sheet. Although that has been mentionned for
several years, this bug reports two reproduceable steps to cause it.
Steps to Reproduce:
1.Opened on a sheet, when using the bottom scroll bar to slide the view from
left to right, if the user misses the scrollbar by 1mm and instead click/slides
on a sheet tab underneath a very small amount, a page icon appears, the sheet
accidentally clicked is abruptly emptied (all contents of all cells are
deleted!).
2.Continuing work on the active sheet - all the charts on that sheet are found
to be broken(see below).
3.Another way to break a Chart is to add a new fresh x,y scatter Chart (which
will update), save the spreadsheet, restart Calc in Safe Mode (to attempt to
restore the previous broken Charts), choose each successive option
unsuccessfully, then finally "factory" defaults all (choice furthest down the
safe mode list) then open the spreadsheet with dozens of broken Charts and one
that was working - and now it's broken too.
Actual Results:
All contents of the idle sheet that was slid by accidental touching of it's tab
are gone - emptied, deleted.
All Charts of the active sheet being worked on are broken and unable to update
in any automated way.
All Charts used for diagnostic purposes (what happens on the Chart when data is
modified) have to be reconstructed from scratch.
Stirring each graphic will provoke a modification to show yet the spreadsheet
truly is unusable and impossible to pass on to a colleague. It has to be
rebuilt.
A small black arrow and bold line sometimes appears on the tab affected (now
emptied). The user may not notice because the sheet actually being worked on is
at an empty area of cells too, that's why it was being slid using cursor. If
the user notices because the charts are being worked on - it's nearly
impossible to realise the deleted contents of sheets to the left were the cause
(to know to go back) because they're closed. If the document is saved, none of
the charts work at the next opening. Saving at intervals is always a good
idea, yet the user doesn't know that weeks or months of work have been added
after the broken Charts. Broken means that any change to data, style, Area,
border will only cause a change of the plot if the graphic Area is moved around
on the sheet. Although one commentator mentioned on a different Bug that this
is professionally acceptable - I admit that doing 400 graphics in Cancer
Research (workstation with two UltraHD monitors and a third possible) is nearly
killing me first. There are other causes for breaking Charts, but I've read
everything on the internet I can find (and all Bugs here) and not yet, not once
been able to repair a sheet or a single graphic. Every safe mode was/is
attempted, setting tools/options to always recalculate on loading (seemed to
work, but not after this bug).
Expected Results:
Automatic update of Charts is, perhaps (for many users) what a spreadsheet is
best at. The graphical possibilities are fabulous and the ease of inserting
functions in the columns makes it an analytical tool (else than for doing
powerpoint presentations).
Reproducible: Always
User Profile Reset: Yes
Additional Info:
LO 6.0.6.2 build 1:6.0.6-0ubuntu0.18.04.1 (Bionic Beaver) on a 64bit KabyLake
Shuttle PC and two giant UltraHD DP monitors.
Versions 6.04 and 6.0.6 and 6.10 were all used with Light Ubuntu this year and
there were regular broken Charts (nearly every day) without being able to find
the causes. In the end, the reload and repair work brought the Cancer research
to a standstill - so I can't add much evidence about that history (four years).
Calc 6.0.6.2 is now being used here three weeks with Bionic Beaver and it is
marvellous and stable. It's evident now just how much suffering was involved
before (With LightUbuntu KDE and 6.10 there were ten stoppages per day with or
without OpenGL and the stress level as user was extremely high). Ended - over!
Calc 6.0.6.2 is nearly rock steady (keeps running), perhaps because the Gnome
environment really is in favour of Users.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
