| Summary: | Comments duplicated on other sheet when saving as xls | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | G. Prager <g.prager> |
| Component: | Calc | Assignee: | Kohei Yoshida <kohei> |
| Status: | RESOLVED FIXED | ||
| Severity: | critical | CC: | bfo.bugmail, sophi, ta730, wdarden |
| Priority: | high | Keywords: | regression |
| Version: | 4.2.0.4 release | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | All | ||
| Whiteboard: | target:4.3.0 target:4.2.1 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | Spreadsheet with two sheets. A comment was added to cell B3 on the second sheet. The document was saved as .xls. When reopening the comment is added on sheet 1 B3. | ||
|
Description
G. Prager
2014-02-04 17:43:10 UTC
Bug confirmed to persist in libo-42~2014-02-04_11.26.19_LibreOfficeDev_4.2.1.0.0_Win_x86.msi Confirmed: Bug does not exist in LO 4.1.4 nor in LibreOffice_4.1.5.2_Win_x86.msi Please attach example document for easier check on different system/build. Created attachment 93420 [details]
Spreadsheet with two sheets. A comment was added to cell B3 on the second sheet. The document was saved as .xls. When reopening the comment is added on sheet 1 B3.
Spreadsheet with two sheets. A comment was added to cell B3 on the second sheet. The document was saved as .xls. When reopening the comment is added on sheet 1 B3.
This is especially annoying when working with larger files and a lot of commentaries. Then version 4.2.0 is unusable.
So I can confirm that the comments is added added on the second sheet appears in the first sheet and same cell after saving as .xls. Saving as .ods, the comment is not added, it works correctly, but saving again at .xls the comment is added again. But I can still edits the comments. Version: 4.2.0.4 Build ID: 05dceb5d363845f2cf968344d7adab8dcfb2ba71 Ubuntu 13.10 x64 set to New, added regression as it works correctly in 4.1.5.3 - change system to all. Sophie Edit the summary and change importance - Sophie http://www.libreoffice-forum.de/viewtopic.php?f=6&t=12975 seems to describe the same bug; discussion in German *** Bug 74611 has been marked as a duplicate of this bug. *** I'm looking into this. Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=7d71fd489c39f348c43477cafdc1bc150bf1ff68 fdo#74521: Write unit test for this first. 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=771b9d2718f28beedbc1a913e8965cdd1fc75a88 fdo#74521: Only pick cell notes for that sheet, and skip the rest. 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/7945 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=7586a2ebb8eacae6b45910cb248694c27dfdb901&h=libreoffice-4-2 fdo#74521: Only pick cell notes for that sheet, and skip the rest. 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 in 4.2.1. *** Bug 74534 has been marked as a duplicate of this bug. *** I can confirm that libo-42~2014-02-10_23.09.14_LibreOfficeDev_4.2.1.0.0_Win_x86.msi nightly build works fine ! GP |