In a new Calc document: 1. Select A1:A2; 2. Open Number Format dialog (Ctrl+1) on Numbers tab; 3. Select Language: English (USA) - note that it's not "default" element; 4. Select Format: -1234.57 (third from top in the list); 5. [OK]; 6. Select A2 (one of the cells selected on step 1); 7. Open Number Format dialog (Ctrl+1) on Numbers tab; 8. Select Language: German (Germany) - note that it's not "default" element; 9. Select Format: -1234,57 (third from top in the list); 10. [OK]; 11. Select A1:A2; 12. Open Number Format dialog (Ctrl+1) on Numbers tab. => the dialog shows "default" in Language selector, and the third number format in the list. This is a wrong behavior. For comparison, in the step 9 above, select any other element, not the third from top, and see the result in step 12: it will be the dialog without format and language selected at all, which is how it must be.
https://gerrit.libreoffice.org/c/core/+/186794
Mike Kaganski committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/ae245ce3147468449dc5c3844245d4eed654d3c6 tdf#167161: different ATTR_LANGUAGE_FORMAT mean different number formats It will be available in 26.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Mike Kaganski committed a patch related to this issue. It has been pushed to "libreoffice-25-8": https://git.libreoffice.org/core/commit/91f79e292c263418d4171c86e062764bd7687b3f tdf#167161: different ATTR_LANGUAGE_FORMAT mean different number formats It will be available in 25.8.0.0.beta2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.