Bug 47904 - FILEOPEN MS2007 .xlsx shows comments what should be hidden
Summary: FILEOPEN MS2007 .xlsx shows comments what should be hidden
Status: RESOLVED DUPLICATE of bug 45874
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.0 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: bibisected35 bibisected35older
Keywords: regression
: 49150 49288 (view as bug list)
Depends on:
Blocks:
 
Reported: 2012-03-26 08:10 UTC by Dirk Huizenga
Modified: 2012-08-09 14:39 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:

Attachments
Calc Comment Mess image (262.59 KB, image/png)
2012-03-26 08:10 UTC, Dirk Huizenga 		Details
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 Dirk Huizenga 2012-03-26 08:10:05 UTC 
Created attachment 59075 [details]
Calc Comment Mess image

My client uses popup comments to extensively document his spreadsheets.  When I open these documents, all the comments are shown opened.  I normally use Ubuntu and LibreOffice to open and view these spreadsheets, but I just began using LibreOffice on Windows 7.

I cannot find a way to close all the comments for the whole spreadsheet.  And it takes a long time to close them one by one.

Could this be added?  Maybe to the View menu or configuration for Calc (Tools: Options: Calc: View).
Comment 1 Rainer Bielefeld Retired 2012-04-30 04:29:20 UTC 
[Reproducible] with parallel installation of Master "LOdev 3.6.0alpha0+  – WIN7 Home Premium (64bit) ENGLISH UI [Build ID: 52348aa]" (tinderbox: Win-x86@6-fast, pull time 2012-04-27 21:25:23) and sample document from "FILEOPEN MS2007 .xlsx shows comments what should be hidden" <https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/990868/+attachment/3114178/+files/Workbook1-2.xlsx>

Not shown in 3.4.5, so Regression.

Old Master bug, already visible with Server installation of Master "LibO-dev 3.5.0 – WIN7 Home Premium (64bit) English UI [(Build ID:  3b32204-7f92fce-2ba0a9f)]" (2011-09-03) and in
even more old Master build from July 2011

OS=All due to DUPs

@Kohei:
Please set Status to ASSIGNED and add yourself to "Assigned To" if you accept this Bug
Comment 2 Rainer Bielefeld Retired 2012-04-30 04:30:11 UTC 
*** Bug 49150 has been marked as a duplicate of this bug. ***
Comment 3 Rainer Bielefeld Retired 2012-04-30 04:31:05 UTC 
*** Bug 49288 has been marked as a duplicate of this bug. ***
Comment 4 Aaron 2012-05-02 09:42:39 UTC 
The bug still exists in LO 3.5.3.
Comment 5 Chris Peñalver 2012-05-03 03:34:38 UTC 
As per https://bugs.freedesktop.org/show_bug.cgi?id=47904#c1 , Version -> LibO 3.5.0 Release.
Comment 6 Rainer Bielefeld Retired 2012-05-03 03:57:43 UTC 
@Christopher M. Penalver
No. The problem appeared much before 3.5.0 in LibO-DEV 3.5.0 – for details see Comment 1.
Comment 7 Aaron 2012-05-03 10:25:57 UTC 
(In reply to comment #6)
> @Christopher M. Penalver
> No. The problem appeared much before 3.5.0 in LibO-DEV 3.5.0 – for details see
> Comment 1.

No. LO 3.4.5 opens xlxs with comments correctly.
Comment 8 Martin 2012-06-10 07:17:33 UTC 
I confirm that the bug still exists in 3.5.4.2. In my case it rendered several documents basically unreadable: it is impossible to manually close hundreds of comments, and those comments in turn obscure the bulk of the spreadsheet. The mess is even worse than in Dirk Huizenga's example, alas confidential info so can't post it here.
Comment 9 Martin 2012-06-29 03:20:22 UTC 
This bug reports the same problem:

Bug 45874 - Function "show comments" is always enabled.
Comment 10 Robinson Tryon (qubit) 2012-07-03 22:09:54 UTC 
Regression does appear in oldest version of bibisect-3.5.tar.lzma and must be older.
Comment 11 zangdook 2012-08-08 20:08:55 UTC 
Still there in 3.6.0, same thing described here https://www.libreoffice.org/bugzilla/show_bug.cgi?id=47753
Comment 12 Noel Power 2012-08-09 14:39:03 UTC 

*** This bug has been marked as a duplicate of bug 45874 ***