https://bugs.documentfoundation.org/show_bug.cgi?id=166864
Bug ID: 166864
Summary: Duplicating a sheet in LibreOffice Calc increases the
number of rows
Product: LibreOffice
Version: 25.2.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When I right click a sheet and pick 'Duplicate Sheet', a dummyrow is added at
A1:C1048576. This in turn affects third party software (like NPOI Reader used
in Pancake Spreadsheet to link .xlsx files into McNeel's Grasshopper), because
the number of rows exceeds what the software is able to handle.
Steps to Reproduce:
1.Add some info to cells in the default sheet
2.Duplicate the sheet
3.Inspect the file and compare the original sheet with the duplicated sheet
using an XML based editor? See link in other information.
Actual Results:
Inspecting the file shows there to be a dummyrow at A1:C1048576. But this row
is not present when navigating the file using the navigator by searching for
row 1048576.
Expected Results:
I expected to be able to read the .xlsx file data using Pancake Spreadsheets,
but it did not recognise the sheets that were duplicated. The data in the file
should remain readable, in my case, a file with just two columns with less than
10 rows and 4 sheets became unreadable, whereas the sheets are actually really
really simple.
Reproducible: Always
User Profile Reset: No
Additional Info:
Also see the bugreport I made for Pancake Spreadsheet:
https://discourse.mcneel.com/t/pancakespreadsheet-read-write-xls-x-files-without-excel/145611/34
--
You are receiving this mail because:
You are the assignee for the bug.
