Column ranges not converted from A1 to RC when exporting in xlml format #1707
Labels
No Label
DBF
Dates
Defined Names
Features
Formula
HTML
Images
Infrastructure
Integration
International
ODS
Operations
Performance
PivotTables
Pro
Protection
Read Bug
SSF
SYLK
Style
Write Bug
good first issue
No Milestone
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: sheetjs/sheetjs#1707
Loading…
Reference in New Issue
No description provided.
Delete Branch "%!s(<nil>)"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
When exporting to the .xlml format, formulas have their cell references in A1 format converted into RC format (i.e. $A$1 becomes R1C1) using the a1_to_rc function.
7ef3f3e531/bits/61_fcommon.js (L26-L37)
The function correctly turns references with a letter followed by a number into RC format but does not convert column ranges. As a result the exported sheet either does not have these formulas or they are corrupted.
For example,
SUM($A:$A)
should becomeSUM(C1)
andSUM($A:$C)
should becomeSUM(C1:C3)
.Similarly,
SUM($1:$3)
should becomeSUM(R1:R3)
in the exported .xlml format.Also noticing now that it will change A1 references in strings into RC format so
="$A$1"
gets changed to="R1C1"
which shouldn't happen.Bumping this issue as I'm also seeing the behavior with column ranges.
a1_to_rc("SUM($A:$A)", {r:R, c:C})
yields"SUM($A:$A)"
, so it looks like this may be a case that's simply not handled yet.