Bug 919020
| Summary: | Converting String to Double | ||
|---|---|---|---|
| Product: | [Fedora] Fedora | Reporter: | gbhansen.dk |
| Component: | libreoffice | Assignee: | Eike Rathke <erack> |
| Status: | CLOSED ERRATA | QA Contact: | Fedora Extras Quality Assurance <extras-qa> |
| Severity: | unspecified | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 17 | CC: | caolanm, dtardon, erack, extras-orphan, ltinkl, mstahl, notting, sbergman |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2013-04-26 00:55:42 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
|
Description
gbhansen.dk
2013-03-07 12:20:44 UTC
In what locale are you running the application? I can't exactly reproduce this, but having tried with libreoffice-3.5.7.2-9.fc17 I experienced similar weird behavior in other locales with different separators. It works fine in an en-US locale. It may be that the underlying BASIC function uses a localized system library function to parse the string, which could also explain that it doesn't occur on Windows as there these functions are not localized. Note however that F16 is EOL, I changed the Version field to F17. The system works under DA-dk (Danish) I have tried to change locale to us-en and now the functions are working. In the description of Openoffice and Libreoffice is stated that the programs are using underlying system locale settings, which apparently is incorrect. It is rather inconvienient to have to change locale when running written macros. PROBLEM PARTLY SOLVED CDbl() and CSng() are mainly used to scan user input so it makes sense to have them localized, but the current implementation is wrong. Btw, if you want non-localized number scanning, use Val() instead that uses '.' as decimal separator and ',' as group separator. Fixed upstream http://cgit.freedesktop.org/libreoffice/core/commit/?id=9e9f39d171cafa035d7b8e74187e25c3581cb89d http://cgit.freedesktop.org/libreoffice/core/commit/?id=e96c7a60c88bc1e3008ebdeafd59327933d6707f Pending review for 4-0 as https://gerrit.libreoffice.org/2859 The case with converting failure is also a problem when using us-en locale in an localized system ex. da-dk. Then you cannot use the spreadsheet where the result from converting are going as the decimal and group separator is wrong. http://cgit.freedesktop.org/libreoffice/core/commit/?h=libreoffice-4-0&id=96b079e24f86f7f49a624573783c6e103012f942 http://cgit.freedesktop.org/libreoffice/core/commit/?h=libreoffice-4-0-2&id=f16e95c5c86256d3c3eb017654ce229839df6584 should be in 4.0.2 are we backporting this back to 3.5.X F-17, or punting it until F-18 ? It should be possible to backport it. Upstream 3-6 http://cgit.freedesktop.org/libreoffice/core/commit/?h=libreoffice-3-6&id=565c2dd3039a7c9aa1d82eadc4d5e54ea87cda9c Modified for libreoffice-3.5.7.2-12.fc17 for f17-candidate. libreoffice-3.5.7.2-12.fc17 has been submitted as an update for Fedora 17. https://admin.fedoraproject.org/updates/libreoffice-3.5.7.2-12.fc17 libreoffice-3.6.6.2-5.fc18 has been submitted as an update for Fedora 18. https://admin.fedoraproject.org/updates/libreoffice-3.6.6.2-5.fc18 Package libreoffice-3.6.6.2-5.fc18: * should fix your issue, * was pushed to the Fedora 18 testing repository, * should be available at your local mirror within two days. Update it with: # su -c 'yum update --enablerepo=updates-testing libreoffice-3.6.6.2-5.fc18' as soon as you are able to. Please go to the following url: https://admin.fedoraproject.org/updates/FEDORA-2013-6396/libreoffice-3.6.6.2-5.fc18 then log in and leave karma (feedback). libreoffice-3.5.7.2-12.fc17 has been pushed to the Fedora 17 stable repository. If problems still persist, please make note of it in this bug report. libreoffice-3.6.6.2-5.fc18 has been pushed to the Fedora 18 stable repository. If problems still persist, please make note of it in this bug report. |