Another issue re important ods spreadsheet turned gibberish

Discuss setup / installation issues - Add a spell checker, Language pack?
Post Reply
Job888
Posts: 1
Joined: Mon Oct 25, 2021 12:28 am

Another issue re important ods spreadsheet turned gibberish

Post by Job888 »

Apologies if this is repetition, but I've looked at similar threads and I just can't separate what might be relevant/helpful to me, and what isn't. As soon as people use terminology that I'm not familiar with, and I'm not familiar enough with much, I just get brain freeze. And quite the same issue doesn't seem to have been referenced.

But the constantly updated spreadsheet that's turned into gibberish is a really important one, that interrelates to others, and although much older versions exist, the more recent copies I thought I'd made (or should have made) just don't seem to be there. So help to recover it would be HUGELY appreciated!

The first inkling of a problem was when a red cross showed up against the only affected file (as in having not been recovered) during what was otherwise a seemingly normal recovery of the documents that were open when OpenOffice shut down. Open Office has always shut down repeatedly (which is irritating as anything), but other than having to make sure that I save changes every 5 minutes and having to click through document recovery too often, there've never been any other issues associated with it.

Now, when I try to open the one affected .ods spreadsheet, instead of just opening, a "Text import" window opens instead. That "Text Import" title is followed by the file name, except that that has lots of %20 s breaking it up. I did try to delete the %20s, just in case that made a difference, but it isn't editable. The window includes a preview of the file, but it's all just gobbledygook and if I just accept the specifications of the Text import window (re a copy), another window opens to say the maximum number of lines has been exceeded and that the excess won't be imported, and if I then accept that, a spreadsheet of the same gobbledygook as the preview opens.

There aren't many specifications on the Text Import window. There are separator options and "semicolon" and "space" have their boxes ticked. And I've tried playing with other options, but although there are changes to the previewed document, nothing that I've tried fixes it.

The gobbledygook starts like/looks like this (below). IS THERE ANYTHING i CAN DO!! Please help if you can.........J


(function(){/*



*/
function
function
function
y("Symbol",function(a){function
y("Symbol.iterator",function(a){if(a)return
oN^*ã`óÅ.¼'——\{/GøšÀN€§_pˆwÁYfœŽ'~DÒàÑ=8÷¯IÄCG—¹¨ïG×þ²ÀøkJ*/dDׇ—Û$ùæêýÍ6.ža­ÇZûkaMp4&pI#žÔ5tHÙß 0¡ób]³«¿0ßµŠÀíyù¢‹ÃÈj|ÎòÄ>©Zœòcä·¾¹qªbøÈKù:SÅʶ”ÊEk/ÿ‰çD e4}œ²×óõëŠTX®Vw§~ü$†èÒ9ЀNiX
Ó'ÇÝV¿Ý‚“Æ1tÛ­£vÿ:ïé|<I@³¤²?»àMÇlL0ëåJè¤[ÍñPFé=i“-³ôž¼sá¯)ÆÙš²m·«øÙŒ/‰¡/ò
ö*¾Õžðû|I" ¯Ží`gK¹Y¡dz½ò‰xCÝžÂg:Ç°ƒÙצêšü¿ÝoËìa€@Ã=Ðxú>6.·DäƒÈg0OðwÐC ·Ž¾'|Ã/ÿî2‹8™{>e˜¬Ì¯~y»¶úßîDoÅ-IöÉF¦¿Þ‚èÝ”,…u×}»<—{ša†ð`Ï‹H,á}÷‚Ðý¸òfEwç…£{©Ø~ØoôšÇè|ìΡݜ_œž¶`¾¹äšÚ7þ%FúFŒˆÌòmߦ‰,ƒ‡A­Ø¾ïjËcxi³.3Ãó÷Êgø«"×)*eŸð~_%¹N乆xŒbïÀزmÅN–x©l¤×ÙvUpXY–k[öÚ[¥¬Ü(Å)—Èý0‘ÁÇ[Ÿf0qGþp(¨'ïp«ôŒ°{äOIšæ|v-x±­¹n׎®à¢–Æ~¢‘8>®iöUÒ¬®Ö4+f
Ó@®i¬2î]miŒ+o.fe\‰-æ!LWXC]Yî±¹¼%ăû
w…¶ÔbïÀ.äo
§|o
6ËW¼5x¹&ܵñe¢j?/Õ€[àÞCm*ݤsÜãbçˈÎÓD»ð1`d»ƒ‹.¡!Ž<–ºo™œÑßC,D«Q.µ^n…ž£¼`ï‹ž‚ªýF5kfIô{zM¢fo0âÁd&ñ”=…7œo'tz1P?x3‚€


ɶ®Ø‚pý²\CòºW©­8â
Íy±…uЄHÌó‚ÿþ{0%–ªï²à4ðà„2„þD¢†©c4¦Å ô: êªŽöuÍPáã QÓò«4k¨by@¼b¾1æažökD“4÷"}T7Ý6¬š¢ñH¬-Í6,obfµ
Kl1v:‚mÖy=Ì»Ö5MØÞðRÙ¬‹LÅ÷i¹fݵÆ{aOÀ
/ÜysA÷þõtá§páEÀE=wn–5c×2Ý]8c³Î#B ÃEÌ£ ¥ô½=hÌf$
ÈbØb>ŠÙ?È£õ¾ÆÝ—e®qwp—ï8‡8
Open Office 4.1.5 on Windows 10
User avatar
robleyd
Moderator
Posts: 5275
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Another issue re important ods spreadsheet turned gibber

Post by robleyd »

If you upload the actual file, someone might be able to offer advice. See How to attach a document for details regarding attaching a document.
Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.8.3.2; SlackBuild for 24.8.3 by Eric Hameleers
---------------------
Roses are Red, Violets are Blue
Unexpected '{' on line 32
.
John_Ha
Volunteer
Posts: 9584
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Another issue re important ods spreadsheet turned gibber

Post by John_Ha »

That .ods file is complete random junk.

See [Tutorial] How to find and un-delete AOO temporary files for detailed instructions on how to

a) use Previous Versions (W7 and later) to recover previous versions of the file (is there something similar on MacOS and Linux?);

b) recover your file as it was when you last opened or saved it, or as it was when it was last saved with AutoRecovery;

c) find previous versions of the file in the folder it is located in, but which have since been deleted;

d) find any temporary files AOO wrote while you were editing the file but which have not yet been deleted;

e) un-delete the temporary files AOO wrote while you were editing the file, and then deleted. d) and e) will recover your file as it was when you last opened or you last saved it.

If you cannot follow the instructions ask someone with more PC skills to help you. Act quickly - the longer you wait the more likely any temporary files are to be deleted.
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
Post Reply