Description: I have a Calc Sheet that I used to calculate some numbers from last year (2022). I copied the entire thing into a new empty sheet, and some of the formulas do not work in the new (2023) sheet). Steps to Reproduce: 1.Created sheet with formulas 2.Copied entire contents of sheet into a new empty sheet 3.Began inputting new data Actual Results: Cells with totals calculated nothing or incorrectly. Expected Results: Should have calculated sensible, correct results just as the original sheet. Reproducible: Always User Profile Reset: No Additional Info: Tried safe mode, however, the 2nd sheet still produced the same errors.
*** Bug 152893 has been marked as a duplicate of this bug. ***
Created attachment 184496 [details] Inconsistent Calculation in Same Formulas of (Copied) Different Sheets The times calculated are not always correct. Some of the totals at the top are not calculated. My "IF" formulas are to create an empty cell if the other cells from which it caluculates are empty to display a cleaner, more readable sheet.
See the totals cells.
(In reply to gentisle from comment #0) > 2.Copied entire contents of sheet into a new empty sheet In your 2023 file, cells that seem empty are not really empty, but contain a space character " ". So those cells contain text, and the formulas fail to do things like: " "-" " so they return #VALUE!. IMO, you just need to clear the contents of those cells containing " " and the formulas should work as expected. Could you please confirm that?
Sorry, I haven't been able to get on the computer for a couple of days. This is confirmed. Thanks. I would have never figured that out. Now if I can find out how to turn on viewing the invisible spaces. Thanks, again.
[Automated Action] NeedInfo-To-Unconfirmed
Open the workbook. Go to "Edit" -> "Find and Replace" (Ctrl+H). In the "Find" field, introduce one space character (i.e. " " _without_ the quotation marks). Mark the checkbox for "Entire cells" and press "Find All". Once you review that the resulting list is indeed exactly what you want to edit, you could use the "Replace" field. If you have the "Replace" field completely empty while the "Find" field has one space character and the checkbox for "Entire cells" is marked, you could press "Replace All". This procedure should delete the content of those one-space-character cells. I will now close this bug report.