| Summary: | #NAME? error when using a number with percentage | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Andreas Blochberger <andreas.blochberger> |
| Component: | Calc | Assignee: | Eike Rathke <erack> |
| Status: | RESOLVED FIXED | ||
| Severity: | major | Keywords: | regression |
| Priority: | high | ||
| Version: | 5.3.0.0.alpha0+ | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | target:6.1.0 target:6.0.0.1 target:5.4.4 target:5.4.5 target:7.4.0 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
Sheet demonstrating the problem
Original file created in Excel |
||
|
Description
Andreas Blochberger
2017-12-11 13:48:02 UTC
Created attachment 138364 [details]
Sheet demonstrating the problem
Created attachment 138365 [details]
Original file created in Excel
Investigating. This happens only if the percent immediately follows a number, not an expression like (99+1)%, which is related to the fact that on manual input 100% is converted to 1. Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=f6b2349e880afa82f9267087fb48b6e4f8a9aa05 Resolves: tdf#114406 treat % as the operator that it is It will be available in 6.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Pending Jenkins build / review https://gerrit.libreoffice.org/46254 for 6-0 https://gerrit.libreoffice.org/46255 for 5-4 Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-6-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=b030bf19e29f031b0a640dd92c38d654785f1a99&h=libreoffice-6-0 Resolves: tdf#114406 treat % as the operator that it is It will be available in 6.0.0.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-4-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=edb92e348f422cd4db9d356419e4c36b9a7a67c4&h=libreoffice-5-4-4 Resolves: tdf#114406 treat % as the operator that it is It will be available in 5.4.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=51bb22f7a8f1d9fe02243aa58427d63916226793&h=libreoffice-5-4 Resolves: tdf#114406 treat % as the operator that it is It will be available in 5.4.5. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/215cbf1ad23399cb035781698aa28d1eabdb6489 tdf#114406: sc_ucalc: Add unittest It will be available in 7.4.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. |