qrilka/xlsx

Implement support for shared formulas

Shimuuar opened this issue · 3 comments

I'm speaking about feature like:

    <row r="2" spans="1:3" x14ac:dyDescent="0.25">
      <c r="C2" t="str">
        <f>IF(ISTEXT(A2), "string", IF(ISNUMBER(A2), "Number", IF(ISLOGICAL(A2), "bool", "-")))</f>
        <v>-</v>
      </c>
    </row>
    <row r="3" spans="1:3" x14ac:dyDescent="0.25">
      <c r="C3" t="str">
        <f t="shared" ref="C3:C8" si="0">IF(ISTEXT(A3), "string", IF(ISNUMBER(A3), "Number", IF(ISLOGICAL(A3), "bool", "-")))</f>
        <v>-</v>
      </c>
    </row>
    <row r="4" spans="1:3" x14ac:dyDescent="0.25">
      <c r="C4" t="str">
        <f t="shared" si="0"/>
        <v>-</v>
      </c>

Looks like it's known problem as haddock have

TODO: array. dataTable and shared formula types support

@Shimuuar probably you have some real life example file from Excel?

Here it is: expr-import.xlsx

It's stripped down example

Resolved by d40bfb2