https://bugs.documentfoundation.org/show_bug.cgi?id=167636
--- Comment #13 from ady <[email protected]> --- IDK how you create these documents nor what exactly you mean with commas "not hard-written". In other words, use either numbers (0&decimal_separator&5) or not (0¬_a_decimal_separator&5) in _both_ spreadsheets within the workbook. FWIW, I have multi-threaded calculation enabled. When I just open attachment 205071, I still see "0.5" in one spreadsheet while there is "0,5" in the other. After Recalculate Hard, they are all "0.5". IDK whether this is expected behavior, but as a user I am surprised. I don't even understand why users "must" manually use Recalculate Hard when the AutoCalculate setting is already enabled (but we have seen such issue before, even having to use it twice consecutively). Since Recalculate Hard is involved in the procedure, I should also mention that I have OpenCL disabled. I could understand that there might be some problem when the decimal separator is set as a comma, but why changing the setting for multi-threaded calculation would modify the end result? Using the same symbol in both spreadsheets, the end result should not be affected by the multi-threaded calculation setting. That would be indeed a problem. Just as an additional test, you might want to try using a completely different symbol (e.g. underscore), but the same one for both spreadsheets. Please re-test whether changing the multi-threaded calculation setting is really affecting the end result (while maintaining the same symbol in both spreadsheets, with multi-threaded calculation enabled, and when it is disabled). -- You are receiving this mail because: You are the assignee for the bug.
