[Libreoffice-bugs] [Bug 86321] EDITING, FORMATTING: diagram didn't automatic update when change variable (recalculation not triggered)
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Mon Oct 12 17:56:51 UTC 2020
https://bugs.documentfoundation.org/show_bug.cgi?id=86321
--- Comment #77 from matthewnote at yahoo.co.uk ---
(In reply to Buovjaga from comment #49)
> (In reply to Matthew Francis from comment #28)
> > OK, so I see what I did wrong before. The already fixed bug I mentioned in
> > comment 20 was for the chart in the "invoer" sheet, which works in 4.4
> > already
> >
> > The issue I now see was meant is for the "roX0_9" chart, and is reproduced
> > as follows:
> > 1. Open attachment 114246 [details]
> > 2. Go to sheet "roX0_9"
> > 3. Go to sheet "invoer"
> > 4. Delete H19:L19
> > 5. Go back to sheet "rox0_9"
> >
> > The diagram at A52:57 has not updated, but shows the updated values when
> > edited.
> > Note that the bug does not reproduce if step 2 is skipped.
>
> I still reproduce this problem.
>
> Arch Linux 64-bit
> Version: 7.1.0.0.alpha0+
> Build ID: f08ddf3d3df0ef12fef36e96ffe6f5b9a7fda9e3
> CPU threads: 8; OS: Linux 5.8; UI render: default; VCL: kf5
> Locale: fi-FI (fi_FI.UTF-8); UI: en-US
> Calc: threaded
> Built on 21 September 2020
USER WORKAROUND - QUIT ODF FORMAT - WORK IN XLSX UNTIL BUG FIXED
Please add your vast experience, overview and opinion for Users.
We (LibreOffice and Apache communities) have a fundamental problem.
Education is precisely where LibreOffice can be the best: yet students
(including Lars, up to PhD level) need to show a graph that shows the data.
I can (am able) to learn Python, having learnt Machine Code (bit manipulation),
Assembler (extreme efficiency), Fortran 4 (precise compiler), Coral 66, SciLabs
2012 (Equivalent MatLab) yet my experience is with Realtime processing
(Raytheon) and no time at all for a new adventure with ODF. Yet I am
investigating six files here with differences in .xml.
The workaround suggested below is completely ignorant of the multiple
limitations of working with LibreOffice in xlsx format - yet it seems to work.
USER POTENTIAL WORKAROUND while waiting for Bug Fix with more symptoms for
developer info (Step 7-12).
Charts not updating can be made to update by
1. Click and Drag the chart area a few pixels.
If there are many charts depending on one Series update, User must check all
charts on all sheets.
Charts not updating sometimes can be made to update by
2. File>Save Restart LibreOffice File>Recent Documents>Open
This rarely works, can take a lot of time and every number change requires
reload.
3. Zoom in/zoom out the sheet view has be known to cause chart update (but
very rare).
4. Using AppImage 5.3.6.1 is tested to open faulty files and show charts
updating immediately. However, it’s usual that the new *.ods file will fail to
update later after more edits. AppImage 5.3.6.1 as a regular rescue tool
every hour or every day is only available for Linux. The new *.ods file can
be shared. Yet opening several files (rescued with AppImage) at the same time
will cause different chart failures. A method is needed for Windows OS.
NEW FINDING. Charts not updating will always be made to update by saving in
xlsx format.
5. The User has a new decision to make. Using LibreOffice every day in xlsx
format depends on Charts with Data Series formats that transfer well
(triangles, squares, diamonds), simple colours. The User learns to avoid
Functions that are special to LibreOffice yet impossible to translate for
Excel. This is difficult (for advanced users). This method is described
below for Users to test (a clue for developers also).
6. Users don’t know if this Bug Report will ever be assigned. If you are a
Student, Teacher or using the spreadsheet to mostly calculate (with simple
graphics) it can be an option to change format now. If the Bug receives
attention in future, then it will be possible to save again in ODF format and
elaborate/clean the cell functions from that new LO version. Of course, for
engineers, scientists, students and teachers it is basic that the plot shows
the same numbers as the cell. The Bug causes much doubt, mistrust and stress.
An occasional review of the xlsx file progress is, perhaps, less painful.
Testing the file suitability with this method.
7. IF the spreadsheet file is mostly technical or mathematical, this
Workaround may be suitable. If the spreadsheet has scatter charts with the
series formatted in special colours and symbols for presentation, it will need
some work or can be done later (after BugFix) with ODF advantages. If the file
uses Indirect Adressing or Functions the new file need be checked thoroughly.
8. The Workaround (for a file with ordinary charts) is to change to Excel
2007-365 XLSX format until the ODF Bug is fixed.
9. When the charts fail to update or when testing to do it deliberately,
File>Save As> (bottom right filetype) select xlsx Excel 2007-365.
A new name is useful like "abcde XLSX.xlsx" to make it obvious when using a
File Manager. LibreOffice will ask are you sure? A warning will appear that
some details or calculations may be lost. User can check that later.
10. Click to confirm save Excel xlsx 2007-365.
The charts on the sheet being viewed at this time will all update correctly
while you watch. Magic!
Note: At the top of the LibreOffice calc (the black title bar) the file name
has changed to abcde.xlsx. (LibreOffice is still running in it's own display
system and other graphics may fail to update). LibreOffice is showing you a
display equivalent of the xlsx, not yet the true xlsx effect.
11. Save/Close all other .ods files. Close LibreOffice. Restart
LibreOffice.
12. File>Open only the xlsx file. All Charts are now updating.
This conversion/rescue can be done for more *.ods files. Restart LibreOffice
for each file (only one conversion at a time).
Note: It is also now possible to start LibreOffice and open all the new xlsx
files at the same time. All Charts update everywhere on all sheets of all
files (according to the tests done on two computers here. Please comment if
you find problems in future).
13. Inspect the new xlsx presentation for symbol, colour changes, Indirect
Address failures (if the ods file uses it), Chart scales etc. Minor
differences are that xlsx shows # for calculations that cannot be completed
(source data off or inhibited) where the ODF (*.ods) showed #VALUE!
14. It is possible to continue the project for the User always in Excel
format. LibreOffice does this very well! When the Bug is fixed, then Save
as>abcde.ods> (confirm) ODF version is new choice.
15. Unfortunately, editing the files in future will cause new Chart failures
(cause unknown, not yet identified). This Bug 86321 is still possible when
editing. However, save/reopen in xlsx seems always to work and is quick (on
Windows also). Please test for yourself.
DISADVANTAGES.
16. When the User inspects the new xlsx charts, some lines are changed from
dashed to continuous. If the user changes those line again, the Chart will
fail to update. File>Save File>Open xlsx needed again.
17. If the User has created the ODF project with many different formats for
scatter plot Data Series, those colours and symbols are changed to simple blue
squares.
18. The xlsx file can be nearly twice the size in MBytes. For example 9.9
MB in ODF became 21 MB in xlsx. Yet a different very large file (101.7MB) was
precisely the same size ODF/xlsx.
LIMITATIONS OF THE USER WROKAROUND
19. Users estimate that an xlsx file can be shared with colleagues using
Excel. It is necessary, before sending a file to check how it presents on a
working Windows/Office system. It will be very different again! The
workaround concerns using xlsx format to develope the user project until this
Bug is Fixed.
20. attachment 114246 is an example of a file that is suitable for xlsx
conversion and development. attachment 165696 is an example of a file that is
unsuitable (due to extensive use of LibreOffice tools that are excellent yet
not translated into xlsx formats).
[Example: With my four year project, it is too late to work every day now in
xlsx format (even if LibreOffice does it very well). My designs were all based
on analysis by x,y scatter and ODF functions].
Summary
21. File save/close/open again sometimes works with *.ods. Mostly it does
not solve the problem.
Testing here save/open of *.xlsx always repairs chart update.! This is the
unique advantage.
Workaround tested on:
Version: 7.0.1.2
Build ID: 00(Build:2)
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.0.1-0ubuntu1_oibaf~f
Calc: threaded
Version: 7.1.0.0.alpha0+
Build ID: 8eff280bc08ec3d7b2312ae4ee48df4d7328b7de
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64 at 86-TDF, Branch:master, Time:
2020-10-07_08:11:21
Calc: threaded
Version: 6.3.5.2
Build ID: 1:6.3.5~rc2-0ubuntu0.18.04.1~lo1
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3;
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Versie: 6.4.6.2 (Dutch language)
Build ID: 1:6.4.6-0ubuntu0.20.04.1
CPU-threads: 2; Besturingssysteem: Linux 5.4; UI-render: standaard; VCL:
gtk3;
Locale: nl-NL (nl_NL.UTF-8); UI-taal: nl-NL
Calc: threaded
Version: 7.0.2.2 (x64)
Build ID: 8349ace3c3162073abd90d81fd06dcfb6b36b994
CPU threads: 16; OS: Windows 10.0 Build 19041; UI render: Skia/Vulkan;
VCL: win
Locale: nl-NL (nl_NL); GI: nl-NL
Calc: threaded
WORKAROUND FAILURE
The last Chart on VLB's attachment last sheet in xlsx format - the data
triangles disappear - only the line is seen). Full details Xenial Puppy Linux
with LibreOffice 6.1.0.3 in *sfs executable form.
Version: 6.1.0.3
Build ID: efb621ed25068d70781dc026f7e9c5187a4decd1
CPU threads: 2; OS: Linux 4.4; UI render: default; VCL: gtk2;
Locale: fr-FR (fr_FR.UTF-8); Calc: group threaded
This failure may be most pertinent for SFS reading this comment.
Experience with Lubuntu (KDE) here is that there are multiple crashes running
LibreOffice which are resolved since Ubuntu moved to Gnome. A Lubuntu PC here
was crashing ten times per day (set LibreOffice autorecovery on!). When wiped
and replaced with full Ubuntu Bionic Beaver 18.04 - several months with no
crashes at all. In fact, I now switch off LibreOffice autorecovery when I use
6.3.5.2 or 7.0.1.2. The Linux is rock solid.
--
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/20201012/8349aafe/attachment-0001.htm>
More information about the Libreoffice-bugs
mailing list