Description: When I change the valours of a per cent formated sheet in a formula, the data don't change. Example: Sheet A1 = 10 Sheet A2 = 5 Sheet A3 (per cent format) = A2/A1 = 50 %. If I change A2 = 2; A3 doen't change to A3 0 20 %. In previous versions, the values changed correctly. Regards. Actual Results: When I change the valours of a per cent formated sheet in a formula, the data don't change. Example: Sheet A1 = 10 Sheet A2 = 5 Sheet A3 (per cent format) = A2/A1 = 50 %. If I change A2 = 2; A3 doen't change to A3 0 20 %. In previous versions, the values changed correctly. Regards. Expected Results: When I change the valours of a per cent formated sheet in a formula, the data don't change. Example: Sheet A1 = 10 Sheet A2 = 5 Sheet A3 (per cent format) = A2/A1 = 50 %. If I change A2 = 2; A3 doen't change to A3 0 20 %. In previous versions, the values changed correctly. Regards. Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: es Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no
Thanks for reporting. This issue actually has nothing to do with the percent format, but is a bug with auto-recalculation, and has been reported as bug 137248. It has been fixed and the upcoming 7.0.3 release will contain the fix. *** This bug has been marked as a duplicate of bug 137248 ***