Please attach a sample file, reduce the size as much as possible without private information.

Request seen. This may take some time to generate.

Took less time than expected.

I tested with a fresh user profile, so there's no interference from my actual user profile.

I created Holdings-165695-bug--AutoCalculate-true.ods by:
- open Calc, save a new blank spreadsheet
- organize macros, add Module1, paste in the Basic code from external storage
- run macro Create_Blank to make a blank sheet
- fill in one line of data and a couple of details
- save Holdings-165695-bug--AutoCalculate-true.ods
- observe blanks in the formatted section below the freeze line, as expected
- close Holdings-165695-bug--AutoCalculate-true.ods

Then I unzipped Holdings-165695-bug--AutoCalculate-true.ods , changed the AutoCalculate setting in settings.xml to false and rezipped the file to Holdings-165695-bug--AutoCalculate-false.ods .

- open Holdings-165695-bug--AutoCalculate-false.ods
- observe zeros where blanks should be

The macros are probably not part of the issue but the sheet calls a few of them, so I didn't cut them out.

Created attachment 199798 [details]
Example test case, working as expected

Created attachment 199799 [details]
Example test case, broken

The only change between this and the working case is the AutoCalculate setting in settings.xml

Just in case it matters:

    unzip_ods ()
    {
        local filename="${1}";
        if [[ -z "${filename}" ]]; then
            echo "ERROR: Required parameter <filename> missing";
            return 1;
        fi;
        local dirname="${filename}.dir";
        if [[ -e "${dirname}" ]]; then
            echo "ERROR: '${dirname}' exists, not overwriting";
            return 2;
        fi;
        mkdir "${dirname}";
        cd "${dirname}";
        unzip "../${filename}";
        for f in *.xml;
        do
            local name="${f%.*}";
            local extension="${f##*.}";
            local bakfilename="${name}-bak.${extension}";
            cp -pr "${f}" "${bakfilename}";
            xmllint --format "${bakfilename}" > "${f}";
        done
    }

    zip_ods ()
    {
        local filename="${1}";
        if [[ -z "${filename}" ]]; then
            echo "ERROR: Required parameter <filename> missing";
            return 1;
        fi;
        if [[ -e "${filename}" ]]; then
            echo "ERROR: '${filename}' exists, not overwriting";
            return 2;
        fi;
        zip -0qX "${filename}" mimetype;
        zip -DqrX "${filename}" Basic/ settings.xml;
        zip -DqrX "${filename}" $(find Configurations2 -type f);
        zip -0qX "${filename}" $(find Configurations2 -type d -empty);
        zip -DqrX "${filename}" Scripts/ styles.xml manifest.rdf content.xml meta.xml Thumbnails/ META-INF/;
        echo "====================================================================================================";
        echo "WARNING: This is a hand-rolled solution and may be incomplete";
        echo "         Please verify against the original ODS file where possible";
        echo "====================================================================================================";
        echo;
        unzip -v "${filename}"
    }

Example files provided some time ago. I thought that would get seen and the status would change away from NEEDINFO, but I was wrong. Trying to update the status manually now.

NOTE: It is not necessary to "Enable Macros" when opening the godo and bad test cases, the problem is present either way.

Reproduced on:

Version: 25.2.5.2 (X86_64) / LibreOffice Community
Build ID: 520(Build:2)
CPU threads: 16; OS: Linux 6.11; UI render: default; VCL: gtk3
Locale: en-US (C.UTF-8); UI: en-US
Ubuntu package version: 4:25.2.5~rc2-0ubuntu0.24.04.1~lo1
Calc: threaded

I did not test but please see if duplicate of bug 153766.

(In reply to Timur from comment #9)
> I did not test but please see if duplicate of bug 153766.

I checked my examples.

This bug is a duplicate of bug 153766 in that, [ Data -> Calculate -> Autocalculate ] is off for my bad case and is off for 153766's case.

This bug is not a duplicate in that, my bad case isn't doing any conditional formatting. Rather, there is some mishandling of macros occurring; either not being run, or not properly displaying the output.