Summary: | Formula error if apostrophe in a sheet name | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | pierre-yves samyn <pierre-yves.samyn> |
Component: | Spreadsheet | Assignee: | Kohei Yoshida (inactive) <libreoffice> |
Status: | CLOSED FIXED | QA Contact: | |
Severity: | major | ||
Priority: | high | CC: | markus.mohrhard, vulcain |
Version: | 4.2.0.3 rc | Keywords: | regression |
Hardware: | Other | ||
OS: | All | ||
Whiteboard: | target:4.3.0 target:4.2.1 | ||
i915 platform: | i915 features: | ||
Attachments: | BugQuote.ods (sheet name with an apostrophe) |
Description
pierre-yves samyn
2014-02-04 16:06:55 UTC
I'll take this. Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=c4987cd730be2d4aa7c76e69fad4e3195413fb0c fdo#74512: Add test for this. 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. Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=83cdcdb9f0fe11309939f5dca4fb46e426559896 fdo#74512: Generate escaped sheet names after the grammer is set. 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. 4.2 backport request: https://gerrit.libreoffice.org/7947 Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=0b3342e214d2f9edffbdc595de3410cfc96322d4&h=libreoffice-4-2 fdo#74512: Generate escaped sheet names after the grammer is set. It will be available in LibreOffice 4.2.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. Fixed. Hello Thank you Kohei to work on this... Sorry to reopen but the patch does not fix the problem completely It is only ok from step 1 to 3 but the bug still occurs when you save and reopen the spreadsheet. I still reproduce from step 4 on windows 7/64 with: Version: 4.3.0.0.alpha0+ Build ID: e076b5290e706b8a69abd397a9f255eba6a0cd1a TinderBox: Win-x86@39, Branch:master, Time: 2014-02-13_23:23:34 and Version: 4.2.1.1 Build ID: d7dbbd7842e6a58b0f521599204e827654e1fb8b Regards Pierre-Yves (In reply to comment #7) > It is only ok from step 1 to 3 but the bug still occurs when you save and > reopen the spreadsheet. Exact steps please. (In reply to comment #8) > Exact steps please. Steps to reproduce 1. File> New> Spreadsheet 2. Insert> Sheet> Name: give a name with apostrophe ("test d'apostrophe" for example) 3. In Sheet1.A1 type the formula: ='test d''apostrophe'.A1 Expected result & Actual result: Ok, the 2 ' are kept ='test d''apostrophe'.A1 4. Save, close, reopen the spreadsheet: the formula no longer recognizes the sheet name and displays #NAME ? the formula was changed: ='test d'apostrophe'.A1 Regards Pierre-Yves Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=f45ce989589654128c08294dd4e7ba5c89dcb255 fdo#74512: Add export test for this. 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. Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=9a5ce676ede4828db0acde5db79d91320575ec08 fdo#74512: Fix the ODS export as well. 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. Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=fc7d5cfe5611a90beb16c15cc0a2304ef2c15acc&h=libreoffice-4-2 fdo#74512: Fix the ODS export as well. It will be available in LibreOffice 4.2.2. 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. Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-4-2-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=8deefff6659fda0e38734c2b3176826276debb5d&h=libreoffice-4-2-1 fdo#74512: Fix the ODS export as well. It will be available already in LibreOffice 4.2.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. Fixed again. since 4.2.1.1 is 4.2.1 release, only the first patch made it in, it will be fully fixed in 4.2.2 Hello WORKSFORME on windows 7/64 with Version: 4.2.3.0.0+ Build ID: 5fd90cdd1fdb20ab7f6a2b67c384f0994f09a86b TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-02-21_22:38:15 Thank you :) Regards Pierre-Yves |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.