xlsx icon indicating copy to clipboard operation
xlsx copied to clipboard

Published 20 hours ago • verified publisher icon qrilka

external references in formula

Open tonyday567 opened this issue 5 years ago • 1 comments

Hi,

Reading formula, I get instances of something like [1]Sheet1!A1 and I would guess that this is a shared reference to an external workbook.

How and where would I find what this reference is? I saw the Relationship type, but wasn't sure how to extract a relationship from an Xlsx.

tonyday567 avatar May 22 '19 03:05 tonyday567

Hi @tonyday567 Currently xlsx doesn't do any formula parsing so Formula is just a newtype wrapper around Text. According to ECMA spec (section "18.17.2.3 Cell References") it looks like you're right but probably xlsx need some extra tweaks to allow you to deal with such external references (they should exist in externalReferences of a workbook). If you could share an example I could add support for those externalReferences though I'm not sure how soon I could get to it. And PRs are welcomed of course.

qrilka avatar May 22 '19 08:05 qrilka