Can't copy-past formula in new calc installation

[cj]

I’ve installed LO 24.8.3.2 on a new Win11 computer.

Adding a formula to a single cell in a xlsx document is no problem, but copying-pasting that formula (or “drag” the source cell to the next cell) is not working.

When copying a formula (like =a1), from a source cell to the next cell, the formula will update on the below rows (to =a2, =a3, etc) but the output is the same as the source cell (i.e. =a1).
When dragging the formula from the first cell the formula still updates but the output is now “0”.
When I manually write the formula in each cell I get the desired/correct result. But if I try to copy the source and overwrite the cell i typed manually, the formula stays the same but the result changes to the result from the source cell.

I’ve tried this on an xlsx source documents (w/o saving), in a saved odf-copy, and in a copy saved as xlsx. Same happened to all documents.
The copy-past function works fine in a new odf document.
I’ve also tried to open an older odf document, which has a xlsx source (from October 2023) where copy-past function works fine. But, if I open the xlsx-source document (from October 2023) to that file the problem still exist in the source xlsx document.
Testing on a xlsx document from December 2022 works fine.

So, in a saved ODF with an XLSX source
from 2024 it do not work
from 2023 it works
And in a saved XLSX
from 2024 it do not work
from 2023 it do not work
from 2022 it works

So it seems to me like LO have problems with some newer xlsx versions, maybe mixed with W11?

I guess there are some basic settings which have to be changes, but which one?
(I’ve updated tools->options->LO Calc->Formula-> to “always recalculate”)

Looking forward to any suggestions to how I might solve this.

I’ve uploaded a sample document
XLSX Test.ods (20.5 KB)
(If your version of LO works as intended the formula might look okay when you open the document and you might need to copying/dragging the formula again to reproduce the issue. )

[EarnestAl]

@cj

I’ve installed LO 24.8.3.2 on a new Win11 computer.

There might be an issue with the installation. I would be inclined to reinstall LibreOffice and to reset the user profile, LibreOffice user profile - The Document Foundation Wiki
.

Maybe after that if still an issue

• Click Tools > Options > LibreOffice > View and tick the box Force Skia software rendering in case it is a graphics issue. Allow LibreOffice to restart.
• If still a problem after that, click Tools > Options > LibreOffice > OpenCL and untick the box Allow use of OpenCL. This is not often a problem but read the Help linked from the dialogue.

[Wanderer]

@cj

(I could send a sample document if there are any ways to upload it)

There are: Where editing a post you should see the following symbols at the top:

This illustration is from the (sticky) help-topic you may see also in the language list

This is the guide - How to use the Ask site?

This is intended to help you use this website. There will be additions to this website as we go along. Bring a positive spirit to your posts, and thank you. Attention, this is not a real question, but a description of how to use this Ask site. [image] also available here : Ask/Guide - How to use the Ask site - The Document Foundation Wiki  Introduction / Basics The community …

[cj]

Thank you I’ve uploaded a document

[EarnestAl]

Click Data > Calculate > Recalculate Hard and then click Data > Calculate > AutoCalculate to enable AutoCalculate.

@cj

(I’ve updated tools->options->LO Calc->Formula-> to “always recalculate”

But not for ODF? In this case hasn’t yet been calculated.Normally it is et to don’t recalculate as it is assumed the calculation has been performed already.

[cj]

Yes, checked for all 3.

[EarnestAl]

AutoCalculate is turned off for this spreadsheet

[cj]

Thank you. I see that it helps to hit F9.
And by selecting Data->Recalculate it works for further editing