[Libreoffice-bugs] [Bug 128447] New: XLSX: comment is displayed by default even without the <x:Visible/> tag

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=128447

            Bug ID: 128447
           Summary: XLSX: comment is displayed by default even without the
                    <x:Visible/> tag
           Product: LibreOffice
           Version: 6.2.7.1 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jm.lopez at dialogaconsultores.com

Description:
I have been trying to create a XLSX file with PHPSpreadsheet with attached
comments to the cells. Everything is fine except for the fact that the comments
always appear, regardless of their stated visibility.

I have been inspecting the generated VML files and they correctly omit the
<x:Visible/> tag. Furthermore, Excel opens the file just fine.

I'm attaching a simple test case which works in Excel (comment starts out
hidden) but not in LibreOffice (comment starts shown). 

Note that if I hide the comment in LO, save back to XLSX and reopen it, it does
start out hidden, but I am not familiar enough with the XLSX format internals
to pinpoint the exact modification that allows it to work.

Using LO 6.2.7.1 in Ubuntu 19.04. Can be reproduced in safe mode.

Steps to Reproduce:
1. Open the attached XLS file in LibreOffice

Actual Results:
The comment starts visible

Expected Results:
The comment starts hidden (as it should)



Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Versión: 6.2.7.1
Id. de compilación: 1:6.2.7-0ubuntu0.19.04.1
Subprocs. CPU: 4; SO: Linux 5.0; Repres. IU: predet.; VCL: gtk3; 
Configuración regional: es-ES (es_ES.UTF-8); Idioma de IU: es-ES
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191029/618d784f/attachment-0001.html>