Bug 40853 - Contents not shown when FILEOPEN particular document
Summary: Contents not shown when FILEOPEN particular document
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.4.3 release
Hardware: Other Linux (All)
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-09-13 16:29 UTC by Nathael Pajani
Modified: 2012-08-31 10:07 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
original, which opens correctly (629.54 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-09-13 16:29 UTC, Nathael Pajani
Details
The apparently empty file after "save as" from the original without any modification. (666.13 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-09-13 16:33 UTC, Nathael Pajani
Details
Another file apparently empty but which content appear when adding the grddl:transformation attribute manually (93.10 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-09-30 07:20 UTC, Nathael Pajani
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Nathael Pajani 2011-09-13 16:29:51 UTC
Created attachment 51167 [details]
original, which opens correctly

When saving a spreadsheet I found that this attribute got removed from content.xml :

grddl:transformation="http://docs.oasis-open.org/office/1.2/xslt/odf2rdf.xsl"

then if I close and re-open the spreadsheet, it's apparently empty, though the content.xml file is still 14.5Mo big

If I add the grddl:transformation[...] attribute at the end of the office:document-content tag then everything back ...

This happens on files imported from xls format, sent to me by mail, created under microsoft office, possibly 2003 version, though not sure.
I already worked on this file (Previsionnel_Financier_test.ods) last week or two weeks ago, with no problems. Transformation to ODF format took place 4 weeks ago, and I made many modifications and saved many copies since then.


I did the test on a new file and on an old ODF file created under OpenOffice some time ago, no problem on any of them.


I'm using LibreOffice 3.4.3 OOO340m1 (Build:302) on Debian sid, distro build.
("dpkg -l" gives : libreoffice-calc  1:3.4.3-1)

Two files attached :
* original is Previsionnel_Financier_test.ods which opens alright,
* second (attached as comment) is test.ods, which opens as empty, though I only did "save as" test.ods after opening Previsionnel_Financier_test.ods


Sorry if this is a duplicate bug, I have no time to look after it, much too busy these days.
Comment 1 Nathael Pajani 2011-09-13 16:33:31 UTC
Created attachment 51168 [details]
The apparently empty file after "save as" from the original without any modification.

The apparently empty file after "save as" from the original without any modification.

The same happens if I do some modifications in the document and just use the "save" button.

The modifications are not lost, everything is back after adding the grddl:transformation attribute.
Comment 2 Nathael Pajani 2011-09-13 16:37:55 UTC
After adding the "grddl:transformation" attribute to the "office:document-content" tag in the content.xml file by hand I can save-as or modify-save-close and reopen the file with no problem.

It just happens on the original file, and on the new files received by email in xls format.
Comment 3 Rainer Bielefeld Retired 2011-09-13 22:49:37 UTC
FILEOPEN problem is NOT reproducible with reporter's "test.ods" and "LibreOffice 3.4.3 RC2 - WIN7 Home Premium (64bit) German UI [OOO340m1 (Build:302)]", lots of contents shown.

FILEOPEN problem is [Reproducible] with reporter's "test.ods" and with "LibreOffice Portable 3.3.3  - WIN7  Home Premium (64bit) German UI [OOO330m19 (Build:301  Tag 3.3.3.1)]", No document contents shown on 1 single sheet, It seems that LibO expects the document to be an EXCEL document, at least with "Save As" the default is "MS EXCEL XML 2003". FILESAVE problem (removes "grddl:transformation") also NOT reproducible with this version.

Problem might be Linux related, we need an additional LINUX tester

So it seems we have 2 problems:

A) Why does reporter's LibO have problem with missing "grddl:transformation", others not?

B) Why does reporter's LibO remove "grddl:transformation" when saving document? For this problem it might be useful to submit a different report, some more detailed information concerning creation history will be required
Comment 4 Rainer Bielefeld Retired 2011-09-18 21:43:57 UTC
@Jeffrey:
It woud be kind if you could do a test.
Comment 5 Rainer Bielefeld Retired 2011-09-29 06:02:00 UTC
@Tester8:
Can you please test?
Comment 6 Nathael Pajani 2011-09-30 07:20:02 UTC
Created attachment 51794 [details]
Another file apparently empty but which content appear when adding the grddl:transformation attribute manually
Comment 7 tester8 2011-10-08 15:25:02 UTC
>original, which opens correctly
Opens correctly.

>The apparently empty file after "save as" from the original without any >modification.
Opens empty.

When I save original file and reopen resulted file works. grddl:transformation=... is removed from style.xml.

>Another file apparently empty but which content appear when adding the >grddl:transformation attribute manually
Opens normally.

LO 3.4.3 OOO340m1 (Build:302)
Ubuntu 10.04.3 x86
Linux 2.6.32-34-generic Russian UI
Comment 8 Nathael Pajani 2011-10-08 15:29:18 UTC
(In reply to comment #7)

> When I save original file and reopen resulted file works.
> grddl:transformation=... is removed from style.xml.

grddl:transformation is in content.xml in original file, and I add it there (in content.xml) to get the content back.

I never openned style.xml
Comment 9 Björn Michaelsen 2011-12-23 12:37:56 UTC
[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1

more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Comment 10 tester8 2011-12-29 15:23:12 UTC
LOdev 3.5.0beta2 
4ca392c-760cc4d-f39cf3d-1b2857e-60db978
Ubuntu 10.04.3 x86
Linux 2.6.32-37-generic Russian UI

Both files opens correctly.

grddl:transformation="http://docs.oasis-open.org/office/1.2/xslt/odf2rdf.xsl" was removed. Should it be separated to another bug?

So fixed?
Comment 11 Florian Reisinger 2012-08-14 14:03:34 UTC
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian
Comment 12 Florian Reisinger 2012-08-14 14:04:30 UTC
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian
Comment 13 Florian Reisinger 2012-08-14 14:09:01 UTC
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian
Comment 14 Florian Reisinger 2012-08-14 14:11:01 UTC
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian