Bug 159814 - FILESAVE/FILEOPEN .xlsx:Comment Shadow Always displayed
Summary: FILESAVE/FILEOPEN .xlsx:Comment Shadow Always displayed
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xls, filter:xlsx
Depends on:
Blocks: XLSX-Comments
  Show dependency treegraph
 
Reported: 2024-02-21 07:29 UTC by Saburo
Modified: 2024-02-22 03:24 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
xlsx Comment no shadow (8.82 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-02-22 03:22 UTC, Saburo
Details
xls Comment no shadow (26.00 KB, application/vnd.ms-excel)
2024-02-22 03:22 UTC, Saburo
Details
Screenshot excel (1.57 KB, image/png)
2024-02-22 03:24 UTC, Saburo
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Saburo 2024-02-21 07:29:46 UTC
Description:
Even though the shadow of the comment is set not to be displayed, the shadow is displayed when opening the file.

Japanese ask
https://ask.libreoffice.org/t/excel-calc/102387

Steps to Reproduce:
1.Calc Open
2.Insert Comment "AAA"
3.Show Comment and Aria Dialog open
4.Shadow tab - Uncheck Use shadow
5.File Save .xlsx
6.File Open this one.

Actual Results:
Comment shadow displayed
Checked Use shadow

Expected Results:
I want to save the settings and display them accurately.


Reproducible: Always


User Profile Reset: No

Additional Info:
I created a file in Excel and compared it.
vmlDrawing1.vml
Comment Shadow On
<v:shadow on="t" obscured="t" color="black"/>
Comment Shadow Off
<v:shadow obscured="t" color="black"/>

Version: 7.6.4.1 (x86) / LibreOffice Community
Build ID: e19e193f88cd6c0525a17fb7a176ed8e6a3e2aa1
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: CL threaded

Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: bbb0663813d0476b9a654207b7006315cb417c2e
CPU threads: 4; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: ja-JP (ja_JP.UTF-8); UI: ja-JP
Calc: threaded
Comment 1 Rafael Lima 2024-02-21 12:23:30 UTC
I can confirm the issue. The shadow settings are not exported to XLSX.

It works fine when the file is saved as ODS though.

Tested with:

Version: 7.6.4.1 (X86_64) / LibreOffice Community
Build ID: 60(Build:1)
CPU threads: 16; OS: Linux 6.5; UI render: default; VCL: kf5 (cairo+xcb)
Locale: pt-BR (pt_BR.UTF-8); UI: en-US
Ubuntu package version: 4:7.6.4-0ubuntu0.23.10.1
Calc: threaded
Comment 2 ady 2024-02-21 16:48:01 UTC
Also not saving/exporting the shadow setting of the comment in XLS file format.

I admit I don't recall whether such setting is supported in XLS format to begin with.
Comment 3 Saburo 2024-02-22 03:22:23 UTC
Created attachment 192704 [details]
xlsx Comment no shadow

Excel 2010
Comment 4 Saburo 2024-02-22 03:22:50 UTC
Created attachment 192705 [details]
xls Comment no shadow
Comment 5 Saburo 2024-02-22 03:24:16 UTC
Created attachment 192706 [details]
Screenshot excel