Bug 125765 - FILEOPEN VIEWING XLSX applies first sheet gridlines settings for every sheet
Summary: FILEOPEN VIEWING XLSX applies first sheet gridlines settings for every sheet
Status: RESOLVED DUPLICATE of bug 126541
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: XLSX-Sheet
  Show dependency tree / graph
 
Reported: 2019-06-07 00:27 UTC by SheetJS
Modified: 2021-05-05 09:18 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Example with broken gridlines (15.51 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-06-07 00:28 UTC, SheetJS 		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 SheetJS 2019-06-07 00:27:59 UTC 
Description:
Excel supports gridlines on a per-sheet level, so you can hide the first sheet's gridlines without disrupting other worksheets.

LibreOffice applies the first worksheet's setting to every other sheet, so if the first worksheet gridlines are hidden then all worksheets appear to be hidden

Steps to Reproduce:
Open attached file and look at second and third worksheets

Actual Results:
Gridlines are hidden in all three worksheets

Expected Results:
First worksheet should have hidden gridlines but second/third should have visible gridlines


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Comment 1 SheetJS 2019-06-07 00:28:29 UTC 
Created attachment 152000 [details]
Example with broken gridlines
Comment 2 Xisco Faulí 2019-10-21 12:36:20 UTC 
Reproduced in

Version: 6.4.0.0.alpha1+
Build ID: de4839e66d3d195315729b95cc144cdab96b6e74
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US
Calc: threaded

@Ilhan Yesil, I thought you might be interested in this issue...
Comment 3 Xisco Faulí 2019-10-21 12:36:52 UTC 
Also reproduced in

LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 4 NISZ LibreOffice Team 2021-05-05 09:18:14 UTC 
This file shows the same symptom as described in https://bugs.documentfoundation.org/show_bug.cgi?id=126541#c6

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