Page 1 of 1

Corrupted file (.xlsm)

PostPosted: Wed Jul 18, 2018 11:21 pm
by voldem
Hi!

In attached file lines from 38 to 121 are almost w/o data. But there were data before saving the file. Saved file and backup file are the same. With corrupted data. Is there any chance to recover file? PLS help. I will very apprechiate.

Re: SOS! PLS HELP! Corrupted file

PostPosted: Thu Jul 19, 2018 12:21 am
by FJCC
I looked at the content.xml file within your file and I do not see any data beyond what is visible when I open your file with OpenOffice. Maye someone else knows more than me but I believe your data are gone.

Re: SOS! PLS HELP! Corrupted file

PostPosted: Thu Jul 19, 2018 12:31 am
by RoryOF
I looked at the innards of the file; the data is there, but I don't know enough about the internal structure of a spreadsheet file to attempt repair.

Re: SOS! PLS HELP! Corrupted file

PostPosted: Thu Jul 19, 2018 12:34 am
by Villeroy
=COUNTA(A1:L121) => 345
with LibreOffice 5.4

Re: SOS! PLS HELP! Corrupted file

PostPosted: Thu Jul 19, 2018 12:42 am
by voldem
RoryOF wrote:I looked at the innards of the file; the data is there, but I don't know enough about the internal structure of a spreadsheet file to attempt repair.


Columns from A to L, Lines from 1 to 121, LibreOffice 5.4. Its very simple spreadshit. If it possible to put data even in new sheet without formatiing. It would be great.

Re: SOS! PLS HELP! Corrupted file

PostPosted: Thu Jul 19, 2018 12:57 am
by Villeroy
It was an Excel sheet with macros. Microsoft Excel Viewer can't open this particular file. I would think it is corrupted one way or the other.
xlsm is one of the most convoluted and complex file formats ever. It is impossible that this is a very simple spreadsheet.
If it possible to put data even in new sheet without formatiing. It would be great.

Copy, Edit>Paste-special text. There is not a single number in this calculation sheet.

Re: SOS! PLS HELP! Corrupted file

PostPosted: Thu Jul 19, 2018 1:15 am
by voldem
Villeroy wrote:It was an Excel sheet with macros. Microsoft Excel Viewer can't open this particular file. I would think it is corrupted one way or the other.
xlsm is one of the most convoluted and complex file formats ever. It is impossible that this is a very simple spreadsheet.
If it possible to put data even in new sheet without formatiing. It would be great.

Copy, Edit>Paste-special text. There is not a single number in this calculation sheet.


I dont understand ( it it possible to recover any data in lines 38-121? copy/paste doesn't work (

Re: SOS! PLS HELP! Corrupted file

PostPosted: Thu Jul 19, 2018 1:37 am
by Villeroy
There are 345 text values in A1:L121. That's all.

Re: SOS! PLS HELP! Corrupted file

PostPosted: Thu Jul 19, 2018 9:27 am
by RoryOF
voldem wrote:
RoryOF wrote:I looked at the innards of the file; the data is there, but I don't know enough about the internal structure of a spreadsheet file to attempt repair.


Columns from A to L, Lines from 1 to 121, LibreOffice 5.4. Its very simple spreadshit. If it possible to put data even in new sheet without formatiing. It would be great.


I can't do it - at present I have limited close-up vision post cataract operations and am managing with ad-hoc close up spectacles, pending receiving prescription glasses for close-up; This limits my computer and detailed work.

Use a zip utility to unzip the .xlsm file, and examine sheet1.xls which you will find within it.