| Summary: | EDITING: "Insert> Names> Insert" inserts the range as a formula, generating an error for multi-cell ranges | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | pierre-yves samyn <pierre-yves.samyn> |
| Component: | Calc | Assignee: | Kohei Yoshida <kohei> |
| Status: | CLOSED FIXED | ||
| Severity: | normal | CC: | gerard.fargeot |
| Priority: | medium | Keywords: | regression |
| Version: | 4.2.0.0.beta2 | ||
| Hardware: | Other | ||
| OS: | All | ||
| Whiteboard: | target:4.3.0 target:4.2.2 target:4.1.6 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
InsertNames.ods (spreadsheet with 2 names defined)
screenshot from 4.0.6 |
||
|
Description
pierre-yves samyn
2013-12-08 18:45:28 UTC
Created attachment 90479 [details]
screenshot from 4.0.6
Confirmed with 4.1.3.2
With 4.0.6 Insert> Names> Insert> Paste all insert the range with = sign but without calculation.
Cell Format is 'Standard'.
Edit without change displays the range
Edit xith change (insert and remove space): formula is calculated.
Opening the file with 4.1.3.2 after inserting names with 4.0.6 show the ranges without calculation (even with Ctrl+Shift+F9)
Editing the cell leads to the same behavior as 4.0.6
I got this. Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=891817922121765cef65ae73ebf7fdc524083d20 fdo#72491: 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=ca50752c34de4477c696471b707e1b8136e27661 fdo#72491: Always set input as text when that's requested. 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. Backport requests: 4.2: https://gerrit.libreoffice.org/8122 4.1: https://gerrit.libreoffice.org/8123 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=563516fc10f1590a5987606de5444643b1b83747&h=libreoffice-4-2 fdo#72491: Always set input as text when that's requested. It will be available in LibreOffice 4.2.3. 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. It'll be in 4.2.3 for real. I'll call this fixed. Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-4-2-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=50b46373b06545b81c68efc9f183cc5670c8517a&h=libreoffice-4-2-2 fdo#72491: Always set input as text when that's requested. It will be available already 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. 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 Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-4-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=016a231ef0a6bfb3c4b74a0e6d6d7431f42755c1&h=libreoffice-4-1 fdo#72491: Always set input as text when that's requested. It will be available in LibreOffice 4.1.6. 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. |