This project has moved and is read-only. For the latest updates, please go here.

Referenced value

Feb 24, 2011 at 12:10 PM

This is probably somewhat related to: http://closedxml.codeplex.com/discussions/242566

Is it possible to get the value of a referenced cell within the same workbook? For instance having Cell("A1").Value (well, probably some other function) return the referenced value in the workbook instead of the formula "='Test sheet'!A2"?

Feb 24, 2011 at 3:54 PM

Getting the value of a referenced cell is a lot simpler than dealing with formulas. I'll work on it.

Feb 24, 2011 at 3:55 PM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.
Mar 23, 2011 at 10:58 AM

This seems to work just fine now after the new release - thanks!

 

However, I was thinking if it could somehow be possible to get the value of a referenced cell in a different sheet? As far as I can see it is currently only possible to get values of cells within the same sheet.

Mar 23, 2011 at 5:49 PM

Fixed, it will appear on the next release.

Thanks for the feedback (and patience)

Mar 24, 2011 at 7:26 AM

Fixed on v0.48.0

Mar 24, 2011 at 9:17 AM

Thank you very much! I really appreciate the great work you are doing here.