Bug 75150 - Un-hided cell comments copied twice when copy sheet
Summary: Un-hided cell comments copied twice when copy sheet
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.0 release
Hardware: All All
: low minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: preBibisect
Depends on:
Blocks:
 
Reported: 2014-02-18 09:49 UTC by Kevin Suo
Modified: 2015-12-17 07:38 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Screenshot (28.81 KB, image/png)
2014-07-25 16:01 UTC, Kevin Suo 		Details
Show Obsolete (1) View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Kevin Suo 2014-02-18 09:49:41 UTC 
Problem:
When copy a sheet with un-hided cell comments, the cell comments are copied twice in the target sheet.

Steps to reproduce:
1. New calc spreadsheet, insert a comment in A1, set the comment as "Show";
2. Copy sheet1 as "Sheet1_2";
3. In Sheet1_2 drag-and-drop the comment box. You will see another comment box "under" it (at some cases it's not "under", but shows two arrows).

Current behaviour:
The comment appeared twice in Sheet1_2.

Expected behaviour:
The comment is not copied twice, as it is in Sheet1.

Tested in 4.2.1.1 and 4.1.5.3, all of which are the same behaviour, no matter the file is .ods, .xls, or .xlsx.

Not reproducible when the comment is set "Hide".

OS: Ubuntu 13.10 x86.
Comment 1 m_a_riosv 2014-02-19 00:06:28 UTC 
Hi suokunlong, thanks for reporting.

Reproducible.
Win7x64Ultimate
Version 4.0.6.2 (Build ID: 2e2573268451a50806fcd60ae2d9fe01dd0ce24
Version: 4.3.0.0.alpha0+ Build ID: ecf22894f522374cbdb8196d3bdef88e2fba7af9
TinderBox: Win-x86@39, Branch:master, Time: 2014-02-15_01:01:17

As duplicate disappears after reopen the file, I think we can reduce a bit the importance.
Comment 2 Kevin Suo 2014-06-13 14:35:29 UTC 
Set platform to ALL according to comment 2.

I can also reproduce with LibreOffice 3.6.7.2, set version to 3.6.7.2 accordingly.
This bug still reproduce with 4.3.0.0 beta2 and 4.2.5.2.
Comment 3 Kevin Suo 2014-07-25 16:01:11 UTC 
Created attachment 103453 [details]
Screenshot

Actually it's not truncted. It's the highlight and transparancy isse.
See the number "9" in the screenshot.

Still reproducible with 4.2.6.2 version.
Comment 4 Kevin Suo 2014-07-25 16:03:08 UTC 
Comment on attachment 103453 [details]
Screenshot

Sorry, I uploaded to the wrong bug number. Should be for bug 77076.
Comment 5 Justin L 2014-09-05 15:14:56 UTC 
confirmed that the "duplicate" problem still exists in 4.4.0 development and is "resolvable" by closing and re-opening.

Issued has existed since at least 3.5.0.  Issue/Regression does appear in oldest version of bibisect-43all.tar.xz and must be older.
Comment 6 Kevin Suo 2015-06-23 09:41:01 UTC 
The bug behaviour do not appear any more with:

Version: 5.0.0.1
Build ID: 9a0b23dd0ab9652e0965484934309f2d49a7758e
Locale: zh-CN (zh_CN)

Mark as RESOLVED WORKSFORME.
Comment 7 Robinson Tryon (qubit) 2015-12-17 07:38:18 UTC 
Migrating Whiteboard tags to Keywords: (prebibisect)
[NinjaEdit]