https://bugs.documentfoundation.org/show_bug.cgi?id=165695
--- Comment #3 from studog <[email protected]> --- 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. -- You are receiving this mail because: You are the assignee for the bug.
