Bug 75150

Summary:	Un-hided cell comments copied twice when copy sheet
Product:	LibreOffice	Reporter:	Kevin Suo <suokunlong>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	minor	CC:	jluth, miguelangelrv
Priority:	low	Keywords:	preBibisect
Version:	3.5.0 release
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Screenshot

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]