We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

calc: Clean up/optimize an ods file?

asked 2021-05-01 08:58:20 +0200

newbie-02 gravatar image

hi @all,

with a document that reproducibly crashed i learned something about the content of my *.ods files.

they accumulate garbage.

besides some links to external files which i couldn't remove, they contain e.g. hundreds of style definitions like 'Excel cond format 10.4.1' and similar, which i'm quite sure not having created or used. and also some hundreds of 'validity definitions' which probably result form copying cells from other files where they had meaningful validity checks, but which are not in need in the final file, and where the final file doesn't have the appropriate ranges with the validity definitions. and probably plenty of other unused stuff collected over the years.

are there any tools / inspectors with which one can:

  • inspect a sheet for content / definitions for whatever stuff is in which is not visible on the screen,

  • check which of that is in use / referenced by which cells or functions,

  • and if superfluous remove it?

  • or something which automatically removes all such which is not in use or has broken referencing except predefined things by LO?

i suspect such stuff slowing down the sheet.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2021-05-02 14:07:06 +0200

JohnHa gravatar image

updated 2021-05-02 14:08:11 +0200

Copy the file contents to a new file - that strips all garbage.

i suspect such stuff slowing down the sheet.

I doubt that.

edit flag offensive delete link more

answered 2021-05-02 13:06:42 +0200

GrahamLees gravatar image

There is an online tool to perform this task called ScanWritr. Link here

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2021-05-01 08:58:20 +0200

Seen: 42 times

Last updated: May 02