qrilka/xlsx

external references in formula

Opened this issue · 1 comments

tonyday567 commented

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.

qrilka commented

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.