https://bugs.documentfoundation.org/show_bug.cgi?id=167636
--- Comment #14 from [email protected] --- (In reply to ady from comment #13) > 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. By hard-written, I mean use a string like "p1 0,5" instead of a formula like =concatenate("p1";$formulas.B2) where $formulas.B2 cell contains the decimal value 0,5. (see column $data.A in documents provided as an example) In the first case the decimal separator may not match the decimal separator of the user's locale if the locale use a dot as decimal separator. In the second case, the formula adapts the decimal separator to the user's locale. > When I just open attachment 205071 [details], 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. Indeed, seems the result of the formulas are not recalculated on document load. So when the document is open on a platform with a different decimal separator, the result of the above "concatenate" formula remains the same until "Recalculate Hard" is used or the value of one of the cells used in the formula is changed. > 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). Don't know it's either a bug or a feature. (may be to speed up document load ?) > 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. Already tested and the result is same both when multi-threading is enabled or disabled. Furthermore, the problem does not occur when using integer values instead of decimal values. > 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). When I : - switch from a locale which use a comma to a locale which use a dot as decimal separator - recalculate hard - save the document - reload the document the same symbol is used in both spreadsheets, and multi-threaded calculation affect the end result : there's no error when multi-threading is disabled and errors reappears when multi-threading is enabled. -- You are receiving this mail because: You are the assignee for the bug.
