Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support for shared formula types #227

Closed
benburleson opened this issue May 25, 2018 · 1 comment
Closed

Support for shared formula types #227

benburleson opened this issue May 25, 2018 · 1 comment
Labels
enhancement New feature or request

Comments

@benburleson
Copy link

I noticed one of my formulas was not getting returned through this package, so looked into it and found that GetCellFormula() (https://github.com/360EntSecGroup-Skylar/excelize/blob/master/cell.go#L228) only works for simple formulas, not shared like the example below:

<row r="46" spans="1:4">
   <c r="A46" s="4" t="s">
      <v>13</v>
   </c>
   <c r="B46" t="str">
      <v>1</v>
   </c>
   <c r="C46">
      <f t="shared" si="0" />
      <v>2</v>
   </c>
   <c r="D46" />
</row>

In my example,C46's formula is simply =B46, so it's not really clear to me what si="0" even means.

Are there any plans to support shared formula types?

@xuri xuri added the enhancement New feature or request label May 26, 2018
xuri added a commit that referenced this issue May 26, 2018
@xuri
Copy link
Member

xuri commented May 26, 2018

Thanks for your issue. I have initialized shared formula types support. Note that: currently, this function not validate ref tag to check the cell if or not in allow area, and always return origin shared formula.

@xuri xuri closed this as completed Jan 26, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants