https://bugs.documentfoundation.org/show_bug.cgi?id=146055
Bug ID: 146055
Summary: [FILEOPEN] Quattro Pro sheet name issues
Product: LibreOffice
Version: 7.0.2.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
A) The DOS file format WQ2 stores worksheet name in the 0xDE record (as a
length-prefixed string). For example, the following record denotes the
worksheet name is "SheetJS":
```
DE 00 # TYPE = 0xDE
08 00 # RECORD LENGTH = 8
07 # LENGTH = 7
53 68 65 65 74 4A 53 # 7 characters = "SheetJS"
```
LibreOffice currently ignores any worksheet names present in the files, using
Sheet1, Sheet2, Sheet3, ...
B) For all QP formats that support sheet names (WQ2, WB1, WB2, WB3, QPW), in
the absence of a sheet name record, LibreOffice uses the default names
"Sheet1", "Sheet2", "Sheet3". For consistency with the original software, the
default worksheet names should be the Quattro Pro defaults (A, B, C, ...).
Steps to Reproduce:
Open Attached File
Actual Results:
Worksheet names are "Sheet1", "Sheet2", "Sheet3" and Formula in Sheet3 is
=#REF!.A1&#REF!.A1
Expected Results:
Worksheet names are "A", "JS", "SheetJS" and Formula in sheet "SheetJS" is
=$A.A1&$JS.A1
Reproducible: Always
User Profile Reset: Yes
Additional Info:
WQ1 only supports one worksheet, so the missing worksheet name issue applies to
WQ2
--
You are receiving this mail because:
You are the assignee for the bug.
