Description: If i change Locale in USA then when i open a file with different Locale, every value is wrong because the decimal seperators, thousands separators and date formats are different! Maybe a good idea is to save the locale in the file and retrieve it from there when loading the file. Steps to Reproduce: 1.Change program Locale from Options/Languages/Locale 2.Try to open a file with different locale data 3. Actual Results: DD/MM/YY turns in to MM/DD/YY A value 100.252,13 turns to 100 if decimals not defined. Expected Results: Dates with DD/MM/YY must be DD/MM/YY A value 100.252,13 must be to 100,252.13 Reproducible: Always User Profile Reset: No Additional Info: None
This is on purpose. The default number formats are locale-agnostic and follow the locale the document is loaded in. If you want values to be displayed always in a specific locale then you need to assign a specific locale's number format. However, this > A value 100.252,13 turns to 100 if decimals not defined. would not happen, so I'm assuming you are not talking about saving in ODF .ods file format but some CSV or other plain text format instead, for which when importing you may have to specify a different locale. Please provide more information what exactly you are doing, what file format you are using, including what locales you are working in and the LibreOffice version; copy-paste the information from Help->About.
Dear nikos, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Dear nikos, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp