[Libreoffice-bugs] [Bug 117606] Problem opening excelfile edited with Libreoffice calc in MS excel 2010 - warning /Damaged file...

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

 Status|NEEDINFO|RESOLVED
 Resolution|--- |DUPLICATE

--- Comment #17 from Xisco Faulí  ---
Ok, I understand the problem now...
Since this bug was growing to fast, I've reported it in a new bug. Please
follow the conversation there...
Closing as RESOLVED DUPLICATED

*** This bug has been marked as a duplicate of bug 117926 ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117606] Problem opening excelfile edited with Libreoffice calc in MS excel 2010 - warning /Damaged file...

[bugzilla-daemon]

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

--- Comment #16 from sverre48  ---
Well, I resolved what I suspected was the problem - which should be clearly
described both by examining the screen shots (attachments). The problem is that
Libreoffice allows longer sheet names than MS office supports. So the reason
why you don't experience this problem now is that the link is updated with a
compatible shorter sheet name. 

BUT you must surely dissalow such stick long sheet names (max 31 chars, it
seems) - as it seems impossible to get any hints of what is repaired by MS
office (at least I am not able to get the details - which are competely
omitted...)

Do you follow me and resolve the compatibility problem to prevent the maximum
no of chars to 31 chars for sheet names.

This observation is also emphasized as another document had similar problem -
also resolved by renaming the _too_ long sheet name

Please confirm and update the status to reflect this crucial infomn provided!

I suggest this should be a prioritised issue to be fixed asap. Agree?

Cheers Sverre

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117606] Problem opening excelfile edited with Libreoffice calc in MS excel 2010 - warning /Damaged file...

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

 CC||xiscofa...@libreoffice.org

--- Comment #15 from Xisco Faulí  ---
I've opened
https://www.dropbox.com/s/3oqz5nl7myrgh30/All-Time%20English%20Football%20Top%20Flight%20Table%20from%20Season%201888-89%20to%202016-17.xlsx?dl=0
in

Version: 6.1.0.0.beta1+
Build ID: da49f4aeb8d5e9a7d2cba8855d911e7cc1d2f1e2
CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); Calc: group

Could you please try to reproduce it with a master build from
http://dev-builds.libreoffice.org/daily/master/ ?
You can install it alongside the standard version.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117606] Problem opening excelfile edited with Libreoffice calc in MS excel 2010 - warning /Damaged file...

[bugzilla-daemon]

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

--- Comment #14 from sverre48  ---
Created attachment 142369
  --> https://bugs.documentfoundation.org/attachment.cgi?id=142369=edit
Work around - rename sheet name

Both files are now possible to open in MS office without this sticky repair
warning/loss of data... Hence, you know what to fix (compatibility, crucial)

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117606] Problem opening excelfile edited with Libreoffice calc in MS excel 2010 - warning /Damaged file...

[bugzilla-daemon]

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

--- Comment #13 from sverre48  ---
Created attachment 142368
  --> https://bugs.documentfoundation.org/attachment.cgi?id=142368=edit
Original sheet name - gives error in MS Office

Hence, Libreoffice should not allow long sheet names (max 31 chars)

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117606] Problem opening excelfile edited with Libreoffice calc in MS excel 2010 - warning /Damaged file...

[bugzilla-daemon]

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

--- Comment #12 from sverre48  ---
In the original trouble report - there is also a long sheet name
maratontabell, fiks tusendel, s

which is not revealed due to overflow conflict. I will test this when I get
home to see if borth files can be fixed by using shorter sheet names (up to 31
chars)

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117606] Problem opening excelfile edited with Libreoffice calc in MS excel 2010 - warning /Damaged file...

[bugzilla-daemon]

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

--- Comment #11 from sverre48  ---
In other words, the longer sheet name created in Libreoffice 6.0.4.2
Rydding, turveier, Plankemyra-S

is not compatible with MS excel 2010 (and others). I beieve the full name was

Rydding, turveier, Plankemyra-Strømsbubukt

(it could be other reasons, I just pinpoint what I noticed is "repaired")

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117606] Problem opening excelfile edited with Libreoffice calc in MS excel 2010 - warning /Damaged file...

[bugzilla-daemon]

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

--- Comment #10 from sverre48  ---
Created attachment 142330
  --> https://bugs.documentfoundation.org/attachment.cgi?id=142330=edit
The file damaged - warning - in Norwegian [4]

I experienced a similar conflict with a document edited in Libreoffice 6.0.4.2
and may have found out at least missing information (repaired in MS office). 

I think the problem is that Libreoffice allows too long sheet names. This limit
should/must be compatible with MS office

PS I do not want to share the office docmt due to that it is private/privacy.
You should just test it yourself. The problem is to me proved (I know the sheet
name is longer than attmt 4 shows (MS off. 2010, repaired...)

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117606] Problem opening excelfile edited with Libreoffice calc in MS excel 2010 - warning /Damaged file...

[bugzilla-daemon]

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

--- Comment #9 from sverre48  ---
Created attachment 142329
  --> https://bugs.documentfoundation.org/attachment.cgi?id=142329=edit
The file damaged - warning - in Norwegian [3]

I experienced a similar conflict with a document edited in Libreoffice 6.0.4.2
and may have found out at least missing information (repaired in MS office).
See attmt 4

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117606] Problem opening excelfile edited with Libreoffice calc in MS excel 2010 - warning /Damaged file...

[bugzilla-daemon]

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

--- Comment #8 from sverre48  ---
Created attachment 142328
  --> https://bugs.documentfoundation.org/attachment.cgi?id=142328=edit
The file damaged - warning - in Norwegian step 2 [2]

I experienced a similar conflict with a document edited in Libreoffice 6.0.4.2
and may have found out at least missing information (repaired in MS office).
See attmt 4

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117606] Problem opening excelfile edited with Libreoffice calc in MS excel 2010 - warning /Damaged file...

[bugzilla-daemon]

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

--- Comment #7 from sverre48  ---
Created attachment 142327
  --> https://bugs.documentfoundation.org/attachment.cgi?id=142327=edit
The file damaged - warning - in Norwegian

I experienced a similar conflict with a document edited in Libreoffice 6.0.4.2
and may have found out at least missing information (repaired in MS office).
See attmt 4

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117606] Problem opening excelfile edited with Libreoffice calc in MS excel 2010 - warning /Damaged file...

[bugzilla-daemon]

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

--- Comment #6 from sverre48  ---
I even just tested opening the xlsx file in office 2016 x64 on win10. Same
problem so it is better that you debug problem with your product than blaming
the many users that certainly need to share office files across platforms using
yes dropbox and other file sharing resources. So I believe this problems
affects all MS office variants. Incompatible issues is close to saying goodbye
to the the same office platforms that do not provide fully compatible formats.
I know of a few in addition to the handful reported...

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117606] Problem opening excelfile edited with Libreoffice calc in MS excel 2010 - warning /Damaged file...

[bugzilla-daemon]

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

--- Comment #5 from sverre48  ---
I think you should be happy that users report of problems. The file says it
all, imo. So please resolve the problem without problemising that Libreoffice
creates incompatible office files!

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117606] Problem opening excelfile edited with Libreoffice calc in MS excel 2010 - warning /Damaged file...

[bugzilla-daemon]

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

--- Comment #4 from Timur  ---
Sverre, if you report bugs, please always give full history info like Regina
asked. 
Also attach file here, not Dropbox links. And if you give screenshot make sure
it's English UI with English errors. 
And do not complain here about other bugs - that were dealt with BTW, unlike
some that are open for years, having no volunteers to fix them.

Good practice is to first save as source .ods and than to save as .xlsx. So if
you attach. ods that we can reproduce an issue. Filesave issue in LO is
different to fileopen in MSO. 
If we have only the final damaged file, than it's guessing and I'd close this
as InsufficinetData. 
MSO says: Repaired Records: Worksheet properties from /xl/workbook.xml part
(Workbook)
Or you can recreate .ods with the same data (not via save as) and than save as
.xlsx and open with MSO and see if and when error happens. You can use LO
6.0.4.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117606] Problem opening excelfile edited with Libreoffice calc in MS excel 2010 - warning /Damaged file...

[bugzilla-daemon]

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

--- Comment #3 from sverre48  ---
I found out that the file was last changed in July 17, 2017, and no problem
opening the file using Libreoffice, 6.04 x64 (win 10). But file sharing across
platforms is an important compatibility issue. That is the problem (MS office
2010, 32-bit fails)

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117606] Problem opening excelfile edited with Libreoffice calc in MS excel 2010 - warning /Damaged file...

[bugzilla-daemon]

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

sverre48  changed:

   What|Removed |Added

 CC||sverr...@gmail.com

--- Comment #2 from sverre48  ---
Created attachment 142104
  --> https://bugs.documentfoundation.org/attachment.cgi?id=142104=edit
Version history in dropbox, created August 22, 2017

The file was created last Summer (august 22) using the latest published
libreoffice version at that time (August 22, 2017). So it was Libreoffice5.x
and always save and work only with .xlsx format. I have also set up this as
default but that information you are welcome to find out, yourself. I only
report this problem. The data is probably copied from some web source/page and
sorted using libreoffice5 calc.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117606] Problem opening excelfile edited with Libreoffice calc in MS excel 2010 - warning /Damaged file...

[bugzilla-daemon]

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

Regina Henschel  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 CC||rb.hensc...@t-online.de
 Ever confirmed|0   |1

--- Comment #1 from Regina Henschel  ---
Do you have worked in file format xlsx all the time? Or do you have worked in
LibreOffice format .ods as well? If yes, please attach the .ods file here.

You have selected "6.0.3.2 release" as earliest affected version, but the file
says "LibreOffice 5.3.4.2"? Which versions do you have used?

Have you worked on the file with Excel too? Or is it the first time, you have
tried to use it in Excel?

Is the file really damaged? Or does the "repaired" file contains all the
information?

I see the problem with the linked file and Excel 365, but it would be good to
know, how the file was generated.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs