Bug 112297 - the contents of the cells are deleted when you reopen an xlsx file
Summary: the contents of the cells are deleted when you reopen an xlsx file
Status: RESOLVED DUPLICATE of bug 112571
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-09-08 21:55 UTC by hola
Modified: 2017-12-18 22:58 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Some pictures of the messages that appears (108.14 KB, application/pdf)
2017-09-08 21:59 UTC, hola
Details
XLSX file. Content deleted and format changed. (35.67 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-09-15 12:08 UTC, hola
Details
XLSX file. I can't open it (25.49 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-09-15 12:11 UTC, hola
Details
Some pictures of the messages that appears (172.90 KB, image/jpeg)
2017-09-15 12:16 UTC, hola
Details

Note You need to log in before you can comment on or make changes to this bug.
Description hola 2017-09-08 21:55:15 UTC
Description:
Hello:
Two things happen to us:

1. On several occasions, in some .xlsx documents, when we open one of them, several cells appear with the contents deleted and the format changed throughout the sheet.
2. We have documents in Google Drive shared with other user (collaborator). We always create spreadsheets in .xlsx format. On several occasions, when one of the users opens one of the xlsx files with the Excel program (Office 2010 version) because he does not use Openoffice, this message appears: "the name can not be the same as the name of the integrated document "(in Spanish," el nombre no puede ser el mismo que el del documento integrado"). Then, it only opens if some characters are typed in the window (it does not matter which characters). You have to write them several times and they must always be different. "_0" "_FilterDatabase_0" starts to appear. Sometimes you have to type different names many times and ask to come to form this "_FilterDatabase_0_0_0_0_0_0_0_0_0_0".

When the file is finally opened, the format of the cells is different from the one you had when last saved.

We do not know if fello 1 occurs due to failure 2.

Thank you

Actual Results:  
.

Expected Results:
.


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.79 Safari/537.36
Comment 1 hola 2017-09-08 21:59:45 UTC
Created attachment 136129 [details]
Some pictures of the messages that appears
Comment 2 m_a_riosv 2017-09-10 22:56:46 UTC
If 3.3.1 is the version,it is years outdated, please can you test with an alive version, there are a lot of improvements between, specially with xlsx files compatibility.

http://www.libreoffice.org/download/download
Comment 3 Timur 2017-09-14 17:42:25 UTC
And please attach those .xlsx.
Comment 4 hola 2017-09-15 09:51:44 UTC
Sorry, there was a mistake. The version with which we were working so far and that I had the bug that I said is 5.1.5.2, not 3.3.1.

Two days ago we downloaded the version 5.3.6, but I have verified that it is still happening with some files.

Thank you very much
,
Manuel
Comment 5 m_a_riosv 2017-09-15 10:12:17 UTC
Please attach a file having the used, remember to depersonalize it.
Comment 6 hola 2017-09-15 12:03:50 UTC
(In reply to Timur from comment #3)
> And please attach those .xlsx.

I attach 2 files:

1: CAJA_2017. Impreso_S.xlsx
When I try to open it in Excel, I can't. I see this message:
El nombre no puede ser el mismo que el documento integrado
Nombre anterior: _FilterDatabase_0
Nombre nuevo:


2: Alumnos pagos.xlsx
This file is corrupted. The contents of many cells have been erased and the format of almost all cells changed. Curiously, only comments remain.

Thank you,
Manuel
Comment 7 hola 2017-09-15 12:08:33 UTC
Created attachment 136260 [details]
XLSX file. Content deleted and format changed.

Alumnos pagos.xlsx
This file is corrupted. The contents of many cells have been erased and the format of almost all cells changed. Curiously, only comments remain.

Thank you,
Manuel

PS. There was a mistake. The version with which we were working so far and that I had the bug that I said is 5.1.5.2, not 3.3.1.
Two days ago we downloaded the version 5.3.6, but I have verified that it is still happening with some files.
Comment 8 hola 2017-09-15 12:11:02 UTC
Created attachment 136261 [details]
XLSX file. I can't open it

CAJA_2017. Impreso_S.xlsx
When I try to open it in Excel, I can't. I see this message:
El nombre no puede ser el mismo que el documento integrado
Nombre anterior: _FilterDatabase_0
Nombre nuevo:

Thank you,
Manuel

PS. There was a mistake. The version with which we were working so far and that I had the bug that I said is 5.1.5.2, not 3.3.1.
Two days ago we downloaded the version 5.3.6, but I have verified that it is still happening with some files.
Comment 9 hola 2017-09-15 12:16:19 UTC
Created attachment 136262 [details]
Some pictures of the messages that appears

On several occasions, in some xlsx documents (pe "Alumnos pagos.xlsx"), when we try to open one of them, several cells appear with the contents deleted and the format changed throughout the sheet.
2. We have documents in Google Drive shared with other user (collaborator). We always create spreadsheets in .xlsx format. On several occasions, when one of the users opens one of the xlsx files with the Excel program (Office 2010 version) because he does not use Openoffice, this message appears: "the name can not be the same as the name of the integrated document "(in Spanish," el nombre no puede ser el mismo que el del documento integrado"). Then, it only opens if some characters are typed in the window (it does not matter which characters). You have to write them several times and they must always be different. "_0" "_FilterDatabase_0" starts to appear. Sometimes you have to type different names many times and ask to come to form this "_FilterDatabase_0_0_0_0_0_0_0_0_0_0".

When the file is finally opened, the format of the cells is different from the one you had when last saved.
Comment 10 Gabor Kelemen (allotropia) 2017-12-18 22:58:24 UTC

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