Another spreadsheet destroyed.

users
#1

A couple of years ago LibreOffice Calc destroyed one of my most important
spreadsheets. Fortunately Apache OpenOffice was able to fix it for me, and
since then I use Apache OpenOffice for all my important work.

Since a few days back though, I started to use LibreOffice Calc (4.2.6.3)
again, also for my important files. I shouldn't have done that, because the
same thing happened again. Fortunately, the spreadsheet could be fixed
again, this time thanks to some backups, but files are supposed to be used
and worked with, not fixed…

The file itself is maybe not that important, but I have been working on it
for almost a decade, so I would probably be somewhat sad if I lost it.
Happy – good, sad – bad… :stuck_out_tongue:

Anyway, it seems that LibreOffice Calc mess up my dialogues. I had three
dialogues and today all the names of all their buttons were replaced with
some default crap. Anyone else experienced this? If so, maybe I (or someone
else) should file a bug report. Fortunately I export all my dialogues and
basic code, so I could easily import them again with Apache OpenOffice. I
tried first with LibreOffice, but when I imported the second dialogue it
crashed.

Ubuntu 14.04
LibreOffice 4.2.6.3.

Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

#2

Hi :slight_smile:
Over the decades i'd expect to need a few fresh starts, especially if it's
in fairly frequent use.

Is it possible to create a fresh new tab and copy&paste some of the
contents across? Perhaps as unformatted as possible to try to lose some
more hidden coding?

It might be worth posting a bug-report but you'd probably need an example
spreadsheet showing how it goes wrong. Also it's a fairly rare use-case,
to expect a spreadsheet to last so long without major revamps. Congrats on
keeping it going!
Regards from
Tom :slight_smile:

#3

Hi Johnny,

A couple of years ago LibreOffice Calc destroyed one of my most important
spreadsheets. Fortunately Apache OpenOffice was able to fix it for me, and
since then I use Apache OpenOffice for all my important work.

Since a few days back though, I started to use LibreOffice Calc (4.2.6.3)
again, also for my important files. I shouldn't have done that, because the
same thing happened again. Fortunately, the spreadsheet could be fixed
again, this time thanks to some backups, but files are supposed to be used
and worked with, not fixed…

The file itself is maybe not that important, but I have been working on it
for almost a decade, so I would probably be somewhat sad if I lost it.
Happy – good, sad – bad… :stuck_out_tongue:

With each LibreOffice new major version there is API changes. So please
see the release notes and maybe adapt your macros:
https://wiki.documentfoundation.org/ReleaseNotes/4.2#API_Changes

If you still experience problems, please file a bug and provide a
version of your file after removing sensible data.

Kind regards
Sophie

#4

Pardon my ignorance. What do you mean when you speak of dialogues in LO Calc?

#5

Sounds like you are using some macros?

And that the document is one you originally created 10 years or so ago?

The problem is most likely there. You probably need to completely
rewrite those macros, since they originated so long ago.

We have been using Openoffice since 1.0, and Libreoffice since its first
release, and the only problems we've ever had is with the new Microsoft
XML formats. We have never had it corrupt a native document format - and
I have seen numerous cases where it was able to repair a Microsoft
Office document that Office itself corrupted.

#6

Pardon my ignorance. What do you mean when you speak of dialogues in LO
Calc?

Tools → Macros → Organise macros → LibreOffice Basic → (Select something)
→ Edit → Insert Basic Dialog

Johnny Rosenberg

#7

Hi :slight_smile:
Ahh, have you tried creating a new file / work-book and copy&paste the
coding from there in the old one into the new one?
Regards from
Tom :slight_smile: