Bug 97598

Summary: XLSX scenario should not be automatically loaded
Product: LibreOffice Reporter: Wolland <avondale1024-001>
Component: CalcAssignee: Justin L <jluth>
Status: VERIFIED FIXED    
Severity: major CC: jluth, raal
Priority: high Keywords: dataLoss, notBibisectable
Version: 3.5 all versions   
Hardware: All   
OS: All   
Whiteboard: target:5.4.0 target:5.3.0.2
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 112196    
Attachments: .XLSX Doc (Please open in latest excel to see what I mean)
PDF as it should look when opened.

Description Wolland 2016-02-05 16:02:49 UTC
Created attachment 122409 [details]
.XLSX Doc (Please open in latest excel to see what I mean)

When you open the document some of the descriptions on the order have been broken ie the wording is missing I will try and send the PDF as it would appear in Excel.

I think there is a template within excel that this invoice is made from i'm sorry I can't be more detailed that this.

Kind Regards
Carsten
Comment 1 Wolland 2016-02-05 16:05:58 UTC
Created attachment 122410 [details]
PDF as it should look when opened.
Comment 2 raal 2016-02-06 20:23:20 UTC
I can confirm with Version: 5.2.0.0.alpha0+
Build ID: 91a7580e03d5b47c6e2513afce85ddee45e730b6
CPU Threads: 4; OS Version: Linux 4.2; UI Render: default; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2016-02-04_00:17:43

after save as .odf are strings still lost, dataloss
Comment 3 Wolland 2016-02-15 23:35:18 UTC
This is still an issue in the latest version as above.
Comment 4 raal 2016-02-16 07:23:35 UTC
Version:
(earliest affected)
Comment 5 Wolland 2016-02-16 08:40:44 UTC
That would be 5.0.4.2 as far as I know.
Comment 6 Wolland 2016-05-04 07:12:13 UTC
This issue is still happening on the latest version of libre office.

Regards
Comment 7 Justin L 2016-12-26 07:26:45 UTC
confirmed this has ?always? been true using bibisect43all oldest.  Marking as notBibisectable.  Confirmed that this is still true today with Ubuntu 64bit and LO 5.3beta2.

The problem is that Scenario sample1 is being loaded automatically.  In Word, it doesn't.
Comment 8 Justin L 2016-12-26 12:56:34 UTC
proposed fix at https://gerrit.libreoffice.org/32432
Comment 9 Commit Notification 2017-01-10 21:32:57 UTC
Justin Luth committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=dfc6f4c1be58b088dd099f6f8bb6103bf962e144

tdf#97598 xlsx import: do not apply any scenarios

It will be available in 5.4.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 10 Commit Notification 2017-01-11 11:51:46 UTC
Justin Luth committed a patch related to this issue.
It has been pushed to "libreoffice-5-3":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=9fdb840b23889e2554740abcb99c71b566dbafc6&h=libreoffice-5-3

tdf#97598 xlsx import: do not apply any scenarios

It will be available in 5.3.0.2.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.