[Libreoffice-bugs] [Bug 81396] XLSX IMPORT: Data plots in chart not visible when cells have formula, needs Ctrl+Shift+F9 (Steps in Comment 5)

[bugzilla-daemon]

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

Markus Mohrhard (retired)  changed:

   What|Removed |Added

 Status|NEW |ASSIGNED
   Assignee|libreoffice-b...@lists.free |markus.mohrhard@googlemail.
   |desktop.org |com

-- 
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

[Libreoffice-bugs] [Bug 81396] XLSX IMPORT: Data plots in chart not visible when cells have formula, needs Ctrl+Shift+F9 (Steps in Comment 5)

[bugzilla-daemon]

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

tommy27  changed:

   What|Removed |Added

 Blocks|75025   |

-- 
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

[Libreoffice-bugs] [Bug 81396] XLSX IMPORT: Data plots in chart not visible when cells have formula, needs Ctrl+Shift+F9 (Steps in Comment 5)

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=81396

vlb v...@xs4all.nl changed:

   What|Removed |Added

   See Also||https://bugs.freedesktop.or
   ||g/show_bug.cgi?id=86321

-- 
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

[Libreoffice-bugs] [Bug 81396] XLSX IMPORT: Data plots in chart not visible when cells have formula, needs Ctrl+Shift+F9 (Steps in Comment 5)

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=81396

vlb v...@xs4all.nl changed:

   What|Removed |Added

   See Also||https://bugs.freedesktop.or
   ||g/show_bug.cgi?id=86572

-- 
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

[Libreoffice-bugs] [Bug 81396] XLSX IMPORT: Data plots in chart not visible when cells have formula, needs Ctrl+Shift+F9 (Steps in Comment 5)

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=81396

tommy27 ba...@quipo.it changed:

   What|Removed |Added

 CC||ba...@quipo.it
 Blocks|65675   |75025

--- Comment #14 from tommy27 ba...@quipo.it ---
still reproducible under Win8.1 using 4.5.0.0.alpha0+
Build ID: 84a6d8eeaab540e5b2ea3baffd919903dff8c247
TinderBox: Win-x86@39, Branch:master, Time: 2014-11-22_23:41:04
Locale: it_IT

moving to mab4.3 list since 4.2.x is end of life

-- 
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

[Libreoffice-bugs] [Bug 81396] XLSX IMPORT: Data plots in chart not visible when cells have formula, needs Ctrl+Shift+F9 (Steps in Comment 5)

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=81396

Christopher Chavez chrischa...@gmx.us changed:

   What|Removed |Added

 Attachment #103297|application/octet-stream|application/xml
  mime type||

-- 
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

[Libreoffice-bugs] [Bug 81396] XLSX IMPORT: Data plots in chart not visible when cells have formula, needs Ctrl+Shift+F9 (Steps in Comment 5)

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=81396

Luke lukebe...@hotmail.com changed:

   What|Removed |Added

 Blocks||75057

-- 
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

[Libreoffice-bugs] [Bug 81396] XLSX IMPORT: Data plots in chart not visible when cells have formula, needs Ctrl+Shift+F9 (Steps in Comment 5)

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=81396

--- Comment #13 from m.a.riosv mari...@miguelangel.mobi ---
Created attachment 103297
  -- https://bugs.freedesktop.org/attachment.cgi?id=103297action=edit
Configuration that makes it works. registrymodifications.xcu

Investigating a bit, I have found that with 4.4 works for me with the attached
configuration file (in the root profile directory), and with a resetting of the
user profile not without change the option or with a hard recalc.

But I'm not able to find which option is different in Menu/Tools/Options with
this file, perhaps a hidden option makes the difference.

Maybe someone is able to find what it's the option making the difference with
the attached file.

-- 
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

[Libreoffice-bugs] [Bug 81396] XLSX IMPORT: Data plots in chart not visible when cells have formula, needs Ctrl+Shift+F9 (Steps in Comment 5)

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=81396

Kevin Suo suokunl...@gmail.com changed:

   What|Removed |Added

 Blocks||65675

-- 
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

[Libreoffice-bugs] [Bug 81396] XLSX IMPORT: Data plots in chart not visible when cells have formula, needs Ctrl+Shift+F9 (Steps in Comment 5)

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=81396

--- Comment #8 from ign_christian ign_christ...@yahoo.com ---
(In reply to comment #5)
Tested with attached file, 
Also confirm that hard recalc needed in: 4.1.6.2, 4.0.6.2 
Not reproduced in: 3.6.7.2 (plot  line still exists, but charts slightly
stretched after saving)

IF reproduce from scratch with XY chart, 
Hard recalc not resolved the issue in: 4.1.6.2, 4.0.6.2, 3.6.7.2
Issue solved with hard recalc in: 4.2.6.1

Plot  line still exist in 3.6.7.2 with attached file, but missing if reproduce
from scratch. Perhaps not a regression.

Tested under Ubuntu 12.04 x86

-- 
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

[Libreoffice-bugs] [Bug 81396] XLSX IMPORT: Data plots in chart not visible when cells have formula, needs Ctrl+Shift+F9 (Steps in Comment 5)

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=81396

m.a.riosv mari...@miguelangel.mobi changed:

   What|Removed |Added

 CC||mari...@miguelangel.mobi

--- Comment #9 from m.a.riosv mari...@miguelangel.mobi ---
With 4.2.5.2 changing the option in:
Menu/Tools/Options/LibreOffice calc/Formula - Recalculation on file load Excel
2077 and newer to always recalculate, do the job.

Works for me with:
Win7x64
Version: 4.4.0.0.alpha0+ Build ID: 32551a546c83874f08aba9c0adb7a38230fa2e36
   TinderBox: Win-x86@39, Branch:master, Time: 2014-07-19_07:47:52

I think this option was implemented to reduce the loading time with large
files. Hard recalc is an usual action in calc, in fact some functions need it
to be recalculated.

OTH, It's not too much clear for me why this one is in MAB, I think we need to
be more strict about that, not the first developer commenting about he doesn't
take too much care on MABs. 

I think the problem now is how to find the patch to ask the dev for backport at
least to 4.3

-- 
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

[Libreoffice-bugs] [Bug 81396] XLSX IMPORT: Data plots in chart not visible when cells have formula, needs Ctrl+Shift+F9 (Steps in Comment 5)

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=81396

--- Comment #10 from ign_christian ign_christ...@yahoo.com ---
Yes if we set Always Recalculate to Excel 2007 and newer, it works as
expected.
Confirmed in 4.3.0.3 and 4.2.6.1

But I think not many users know about this, maybe some notice in release notes
or documentation would be helpful to many users.

-- 
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

[Libreoffice-bugs] [Bug 81396] XLSX IMPORT: Data plots in chart not visible when cells have formula, needs Ctrl+Shift+F9 (Steps in Comment 5)

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=81396

--- Comment #11 from Kevin Suo suokunl...@gmail.com ---
(In reply to comment #9)
 With 4.2.5.2 changing the option in:
 Menu/Tools/Options/LibreOffice calc/Formula - Recalculation on file load
 Excel 2077 and newer to always recalculate, do the job.
Yes this is true, but it's only a workaround.

 Works for me with:
 Win7x64
 Version: 4.4.0.0.alpha0+ Build ID: 32551a546c83874f08aba9c0adb7a38230fa2e36
TinderBox: Win-x86@39, Branch:master, Time: 2014-07-19_07:47:52

I am not sure what you mean by works for me. Does the chart loaded with all
plots shown correctly when you open with 4.4.0.0.alpha0+?

I tried with 4.4.0.0.alpha0+ TinderBox: Win-x86@42, Branch:master, Time:
2014-07-21_06:04:54, it's the same bug behaviour.


 I think this option was implemented to reduce the loading time with large 
 files.

Under Menu/Tools/Options/LibreOffice calc/Formula - Recalculation on file
load, it's also set as Never for ODS format, but chart loads OK in ODS file.
I think it may be related.

It's OK to implement sth to speedup the loading of xlsx file, but should make
sure that what we see are corroct. (For this case, the chart shown is totally
wrong!)

 Hard recalc is an usual action in calc, in fact some functions need it to be 
 recalculated.

As a normal user, they should never know this. I even do not know the
CTRL+SHIFT+F9 feature before I come to bugzilla and find it in the bug
reports in which someone tells to Hard Recalc.  

Also, Hald Recalc is not on the UI Tools - Cell Contents. What a normal user
may find is to use the Recalculate submenu, but that does not solve the
problem.

Just like Tom S. who reported this bug, he did not find the reason why his
chart is showing only one plot. He must have tried his best to find a solution,
but did not find it. 
I then got his test file, and spent 2 hours and finally find out the reason.

If his speadsheet has formulas in all the cells, there would be not even one
plot shown, which will be even harder to find the reason. 
See also this one in our Chinese libreoffice discuss forum:
http://libreofficechina.org/thread-173-1-1.html

 I think the problem now is how to find the patch to ask the dev for backport
 at least to 4.3
It's still reproducible in daily builds, so no patch.

-- 
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

[Libreoffice-bugs] [Bug 81396] XLSX IMPORT: Data plots in chart not visible when cells have formula, needs Ctrl+Shift+F9 (Steps in Comment 5)

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=81396

--- Comment #12 from Kevin Suo suokunl...@gmail.com ---
(In reply to comment #11)

  With 4.2.5.2 changing the option in:
  Menu/Tools/Options/LibreOffice calc/Formula - Recalculation on file load
  Excel 2077 and newer to always recalculate, do the job.
 Yes this is true, but it's only a workaround.

I mean, this XLSX: always recalculate option is not selected by default in a
fresh user profile.
By defalut, ODS is also set to Never recalculate, but shows correct chart
when load.

-- 
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

[Libreoffice-bugs] [Bug 81396] XLSX IMPORT: Data plots in chart not visible when cells have formula, needs Ctrl+Shift+F9 (Steps in Comment 5)

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=81396

Kevin Suo suokunl...@gmail.com changed:

   What|Removed |Added

Summary|XLSX IMPORT: Data plots in  |XLSX IMPORT: Data plots in
   |chart not visible when  |chart not visible when
   |cells has formula, needs|cells have formula, needs
   |Ctrl+Shift+F9   |Ctrl+Shift+F9 (Steps in
   ||Comment 5)

-- 
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

[Libreoffice-bugs] [Bug 81396] XLSX IMPORT: Data plots in chart not visible when cells have formula, needs Ctrl+Shift+F9 (Steps in Comment 5)

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=81396

Kevin Suo suokunl...@gmail.com changed:

   What|Removed |Added

 Whiteboard||possibleRegression

--- Comment #6 from Kevin Suo suokunl...@gmail.com ---
The exported xlsx file opens file in Apache OpenOffice 4.2. It's a possible
regression.

-- 
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

[Libreoffice-bugs] [Bug 81396] XLSX IMPORT: Data plots in chart not visible when cells have formula, needs Ctrl+Shift+F9 (Steps in Comment 5)

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=81396

--- Comment #7 from Kevin Suo suokunl...@gmail.com ---
Created attachment 103012
  -- https://bugs.freedesktop.org/attachment.cgi?id=103012action=edit
the exported XLSX file

-- 
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