Implement support for shared formulas
Shimuuar opened this issue · 3 comments
Shimuuar commented
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 commented
Here it is: expr-import.xlsx
It's stripped down example