Calc crashing often

[archie456]

Hi All!

I’ve recently migrated to Libre Office on my Win 10 and Win 11 machines.

I’m using Calc the most, and am currently working on a formula heavy spreadsheet with a macro I’ve created.

The problem I have is calc crashes so often on both machines.

It crashes most when scrolling around, sometimes when copying cell values and today my macro saved in the spreadsheet file has completely disappeared.

Are there any tips for using this software, I can’t believe others have this issue? Are there some settings I should check?

any advice would be appreciated - thanks!

[Hrbrgr]

First steps

Try step 1, 2, 4, 5 from the Link.

[Lupp]

Since you ( @archie456) mentioned migration to LibO:

• From what other application?
• Is your macro VBA?
• Are your documents stored to the respective ODF formats?

And: Depending on details macros may well be suspected to cause crashes. For investigations concerning possible causes the macro code is needed.

[EarnestAl]

@archie456

It crashes most when scrolling around

Probably graphical issue.

• Check the graphics drivers for your systems are up-to-date
• Click Tools > Options > LibreOffice > View and try ticking the box Force Skia software rendering.
  • If you still get crashes then Untick the box Use Skia for all rendering

[archie456]

Thanks for the responses.


So my document was in Excel, I’ve converted it to LibreOffice calc and am saving it in the ODS.


The Calc sheet has about 30 images in it with transparency set, I’m colouring cells based on the image and then using a macro to calculate the position of the coloured cells - the macro is very basic and simply inverts a the strings of text in a cell - the crashes tend to happen when scrolling around the document.


I’ve now realised the issue with the macro not saving was my own stupid fault - for not saving it in the right place…


I’ve set ‘Force Skia software rendering’ will see if that cures the crashes.