Wrong Cell Coordinates when reading .obs file which has merged columns. #3142

Closed
opened 2024-07-04 10:56:18 +00:00 by s-ashwin · 0 comments

Consider the below (ods_failure.ods) file,
I have the columns A1:C1 merged and D1:E1 merged. Row data is present in Cells A1 and D1.

However, when i try reading this file, I get the data in Cells A1 and C1 also the !merges indicates the range A1:C1 and C1:D1. which is wrong

Tried uploading the file in https://oss.sheetjs.com/, i get data in columns A1 and C1 instead of A1 and D1

Consider the below (ods_failure.ods) file, I have the columns A1:C1 merged and D1:E1 merged. Row data is present in Cells A1 and D1. However, when i try reading this file, I get the data in Cells A1 and C1 also the !merges indicates the range A1:C1 and C1:D1. which is wrong Tried uploading the file in https://oss.sheetjs.com/, i get data in columns A1 and C1 instead of A1 and D1
Sign in to join this conversation.
No Milestone
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: sheetjs/sheetjs#3142
No description provided.