[Libreoffice-bugs] [Bug 86321] EDITING, FORMATTING: diagram didn't automatic update when change variable (recalculation not triggered)

Sun Sep 20 12:08:47 UTC 2020

https://bugs.documentfoundation.org/show_bug.cgi?id=86321

--- Comment #46 from matthewnote at yahoo.co.uk ---
This Bug is still present in
LO Calc 6.3.4
LO Calc 6.3.5.2
(using OS Ubuntu 18.04 LTS)
LO Calc 7.0.1.2
(also on Ubuntu 18.04 LTS)
All safe modes tried.  LO reinstalls also.

For Joel.   This is proving very difficult to provide a "method" to create a
broken X,Y scatter diagram.  In four years I've not yet been able to cause it
deliberately step by step. So I contribute a sample file with broken graphics
(an early learning file not intended for presentation). 

General situation description.  Inserting an X,Y scatter chart, the plotting
updates for a few days work and follows new results in it's Data Range cells,
then abruptly stops updating.  Sometimes it's a graph done at the start,
sometimes it's only a copy, sometimes it's both, then half of all graphs stop
updating.  Sometimes reopening the file gives the user one more operation, you
can watch the result of a number change on the plot, yet only once. The
workload to continue using the file is huge.  

Here there are now three or four hundred files (Cancer data) based on about
five general structures and (as of January 2017 to September 2020),
regrettably, only one has all graphics following data input changes.

Calc 7.0.1.2. I was able to use a file more than twice. Testing Calc 7.0.1.2
with another near identical file (recently modified using 6.3.5.2) of the same
size too, that second file opens and none of the X,Y scatter plots update, none
at all.  Never seen that before either (all plots broken after File>Open). 
(Usually some plots keep updating occasionally then break and never repair.)

This is else than "minor";   the workload is crushing.  Reason. Unfortunately a
bug report moderator considers that autoscale on the Y axis doesn't need to
function correctly for X,Y scatter (although users are desperate to have it
function the same as autoscale X axis and write macros to try to do what the
moderator refuses).  When the data preparation for a graphic changes from y
values to LN(y) values (for example), you not only have half or more than half
the plots don't update at all  -  If you double click on any, the new
presentation will jump and show the Y values squashed at the top.   If you go
back to click a cell on the sheet (for example to change a 1.0 to a 1.1) all
the plots go off again to the old values.  Moving or rescaling all the plots to
cause one update to be shown once - well, I spent about two months of the
twelve in 2019 only doing that, sometimes collapsing with exhaustion. 

Why is autoscaling for technical users important?  The sample file has very
many plots.  The actual Cancer data work chooses to make only a few plotters to
minimise the processing load.  On it's sheet, that plotter fetches or reads the
data from columns.  Those columns are indirect adressing so that the user
selects the data sheet name for X axis and another data sheet name for Y axis. 
That way, there can be fourty simple sheets of numbers and only one X,Y plotter
is needed. 

Note: One screenshot or copy of one plot for a slide presentation using
histogram style autoscaling or forcing a manual Y axis scale may be the
intention of some Calc users or administration staff.  It's unusable for
investigation work.  

For Xisco Pauli.  Please assign this subject to someone "technical" rather than
"presentation". Personally I only ask Calc to use +, -, *, /, LN() and EXP()
then plot.  I can exhaust myself yet feel unable to share any of the four years
work.  I stay with LibreOffice with some sort of confidence that it will work
out.  (As a Raytheon real-time software testing engineer you learn to share Bug
information without worry and never ever put down the user point of view as
trivial or minor.  That attitude is absent, so, well, without effort to not do
it either) :).

Therefore I add a sample file.  Although it were best to prepare a smaller
file, I've tried trimming and deleting sheets with new problems every occasion. 

LO 7.0,1.2 purged, LO 6.3.5.2 default for Ubuntu 18.04 installed.
Opening sample "BMI BM BMH switch expt10.ods" displays sheet
"TheSWITCHexpanded".
X,Y scatter (reading columns P,M,D) is on the area C283 to P342.
Cell L259 multiplies x values for that scatter diagram (default value is 17).
Step one.  Click on L259, enter 25.
Result.  The graph below fails to update.
Expected result.  The plot moves red and violet points to the new x positions.
Step two. Clickandhold on the frame of the graph, dragging it one or two
pixels.  Release the mouse button.
Result.  The graph updates to the new data.
Step three.  Double click the plot itself and change Y axis scaling to
autoscale.
Result.  The y axis scale changes to 0 <-> 45 with all data squashed in the top
third.
Expected result.  y axis autoscale perform precisely the same as x.  This is
very important for technical use of any data.  x values same as y values should
always produce a linear trend line to an origin of (x,y) where x and y are
identical too.
Step four.  Click again once on any cell to quit the graphic.
Step five.  Double click the plot and change Y axis scaling to manual 15 <->
45.
Result.  The plot adopts the new scale.
Step six.  Click on any cell to quit the graphic.
Result.  The plot displays Y axis scaling on 25 <-> 45, ignoring the user
entries.
Expected result.  The manual scale 15 <-> 45.
Step seven. Clickandhold on the frame of the graph, dragging it one or two
pixels. Release mouse button.
Result.  The plot updates to the user requirement (but only once).
Expected result.  Plot updates to any of it's Data Range cell changes always.

My thanks.  Calc 6.x.x.x and 7.0.1.2 plots are astounding quality.  I use 4K
monitors; the antialising is brilliant and the scatter plots with trend lines
surpass all other software used here (Paraview, Scilabs equivalent Matlab). 
Ubuntu 18.04 is rock solid (thanks to choosing Gnome) and Calc 7 is marvellous.
 If someone wishes to see a Cancer data analysis user file with the indirect
addressing and all X,Y scatter plots (suddenly) working (to have a look at a
technical/scientific use of Calc - where it can go), I have one file that
works.   It's 102 MB, uses external links to files of 30 MB more and runs quite
comfortably on a Kaby Lake 3.6Ghz 16GB desktop.  Calc is very impressive
software.  Sometimes I just sit and think about the talent.  Thankyou.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200920/0de3bf70/attachment.htm>