Bug 97598 - XLSX scenario should not be automatically loaded
Summary: XLSX scenario should not be automatically loaded
Status: VERIFIED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5 all versions
Hardware: All All
: high major
Assignee: Justin L
URL:
Whiteboard: target:5.4.0 target:5.3.0.2
Keywords: dataLoss, notBibisectable
Depends on:
Blocks: Scenarios
  Show dependency treegraph
 
Reported: 2016-02-05 16:02 UTC by Wolland
Modified: 2017-09-03 19:10 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
.XLSX Doc (Please open in latest excel to see what I mean) (49.84 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2016-02-05 16:02 UTC, Wolland
Details
PDF as it should look when opened. (190.07 KB, application/pdf)
2016-02-05 16:05 UTC, Wolland
Details

Note You need to log in before you can comment on or make changes to this bug.
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.