Problems with a specific Function: Substitute, and a File that keeps Crashing LibreOffice

English
#1

I have an ods File with over 5000 rows of information (and columns going long towards the “BZ” mark). Within this File, there is a section (~300 rows) I duplicate Five times (5x), but I also Substitute parts of the Cells I’m Duplicating (“Substituting” & “Duplicating”, as an example, in Cell Q3100 I would have: =SUBSTITUTE(Q2800,“EB”,$F$3000). Explained in Words: Duplicate the Cell Q2800, but change all occurrences of “EB” with the Text that can be found in Cell F3000, and so forth.

As I said, the Section I’m Duplicating has approx. 300 rows, and I’m creating Five (5x) other Sections that all operate the same (“Substituting” & “Duplicating”), but I Substitute that same Text for a different Pre-Determined text in each Section. All in all, 300 rows + 5x Sections = 1500 Duplicated rows, and 1800 total rows that all contain similar Text.

I thought my File might have some errors in it (corrupted parts or what not), so I went to task recreating it. As soon as I got to the part where I “Substitute” and “Duplicate”, my New File crashed LibreOffice as my old one did. I also want to note that the New File crashed only after creating the first Duplicated section. Also, when I save a File that has all these Duplicated rows, the save process is painfully slow.

Is there “SOMETHING” about LibreOffice that would make it crash like this? When I say crash, I mean I could be doing just about any operation or editing within the File and LibreOffice would just shut down on me (with a crash report and all that jazz), and this would happen every… 10~15min? It has become very frustrating.

I wouldn’t consider my File to be THAT big. It takes a little under 3MB. Is it possible my OS is the cause of these crashes? It’s not the lack of Ram. I monitored the consumption of it while editing my ods File and I am always well below any type of extreme utilization. I also thought my installation of LibreOffice might be corrupted, so I tried editing with the Portable Version of LibreOffice and the result was the same: Crash.

Any help or information is appreciated.

Additional info:
File Type: ods
OS: Windows 10
LibreOffice Version: 25.2.5.2 (x86)

#2

Please upload the problematic file and describe the sequence of actions that lead to the crash.

#3

With such a large file, I can’t suggest a practical solution for finding the faulty needle in the haystack. I suspect there’s a tiny procedural error somewhere.

As a maintenance technician, for example, I work like this, if the procedure is feasible:

  • halve your subject and test both halves; halve the faulty half and test both quarters; and so on.
  • Alternative: Copy everything as plain text and create a virgin file from it, admittedly removing all formatting and formulas.
  • Third option: Do you know an intelligent…?

For your future work, I can highly recommend saving the fallback versions that work up to that point, section by section.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.