Problem description: xlsx documents with comments always have comments showing. This is identical to bug 46278; however this bug is marked solved.
Steps to reproduce:
1. Save document with comments as xlsx in Libreoffice or Excel
2. Open document in Libreoffice.
Current behavior: All comment will be shown.
Expected behavior: Comments should be only show when you roll the mouse over the cell with the comment. Since there is no easy way to hide all comments, this makes certain spreadsheets very difficult to read.
Operating System: Windows 7
Version: 22.214.171.124 release
I confirm the export bug, i.e. when a document is saved from LibreOffice in xlsx format, all comments will be shown on reopen. However, I cannot confirm it with an xlsx saved from Excel 2010.
(In reply to comment #1)
> I confirm the export bug, i.e. when a document is saved from LibreOffice in
> xlsx format, all comments will be shown on reopen. However, I cannot confirm
> it with an xlsx saved from Excel 2010.
My mistake. This appears to only be an export bug. Files saved in Excel 2010 open correctly.
*** Bug 81080 has been marked as a duplicate of this bug. ***
I saw it's fixed in 126.96.36.199 - Ubuntu 12.04 x86 if reproduce from scratch.
But bug is still there in 188.8.131.52, don't know whether fix will be backported to 4.2.x ?
(In reply to comment #0)
> Problem description: xlsx documents with comments always have comments
> showing. This is identical to bug 46278; however this bug is marked solved.
yes the issue was fixed in LibO 3.6.3 and was working fine till 4.1.5
I start reproducing again the bug in 184.108.40.206 and following releases hence this is a regression.
interestingly those .xlsx saved in LibO will open with all comments shown in LibO but will load correctly (hidden status) in Excel Viewer
yes, it is FIXED again in 220.127.116.11 under Win7x64.
I set status to RESOLVED WORKSFORME
I add Noel Power (who fixed it in 3.6.3) to CC list.
probably he knows the code and maybe he can help to backport the fix that actually affects the whole 4.2.x codeline
Opening the affected spreadsheet in Kingsoft Office also works as it should, saving to xlsx and opening it in Calc also works properly until you save it again in Calc and reopen it - comments will stick around again.
Current Ubuntu 14.04 LTS will have LO 4.2 in official repos through the whole cycle. To get 4.3 in Ubuntu 14.04 LTS one has to either install LO from downloaded executable or via PPA. Since official repos are allways prefered it would be better to backport the fix to 4.2 imho.
I still see the bug in 18.104.22.168 on Win7x64.
(In reply to comment #4)
> I saw it's fixed in 22.214.171.124 - Ubuntu 12.04 x86 if reproduce from scratch.
> But bug is still there in 126.96.36.199, don't know whether fix will be backported
> to 4.2.x ?