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
Created attachment 176706 [details] Test case
I just modified libwps see https://sourceforge.net/p/libwps/code/ci/19c8aafb188ab33ecd3a74b16c330ec2b0f5457c/ and https://sourceforge.net/p/libwps/code/ci/674ed9e955773b32cd8fa02fed6b6355c5dd6a78/ to get the sheet names (but I kept the default names as Sheet1, ...) and I also checked that the sheet number is not higher than 255 (it happens in the given file, I don't know why).