This project has moved. For the latest updates, please go here.

Problem reading cell values of cells with formula MTRANS.

Aug 14, 2013 at 2:08 PM
Hello,

I got problems with reading cell values from an existing excel file.

Within my Excel sheet the cell "C2" contains the formula "=MTRANS('Technical Data'!D6:IV6)" and the visible value is "Volkswagen". When accessing this cell the property HasFormula is true and I receive the visible value using ValueCached instead of Value which is null for this cell.
The cell "C3" in the next row also contains the formula "=MTRANS('Technical Data'!D6:IV6)" and the visible value is "Volkswagen". When accessing this cell the property HasFormula is now false, ValueCached is null and Value ist empty.

I already read that some formulas are not supported yet. Is there any documention on this topic with information about supported and unsupported topics?
Will the formula MTRANS be supported by ClosedXML soon?

Regards,
Christian
Coordinator
Aug 15, 2013 at 2:42 AM
TRANSPOSE is not supported and probably won't be until someone submits a patch for it. It's a nasty formula because it has many meanings depending on where it's used and it can be a regular or an array formula.

I updated https://closedxml.codeplex.com/wikipage?title=Evaluating%20Formulas with the list of functions supported.
Aug 16, 2013 at 6:59 AM
Hello MDeLeon,

thank you very much for your fast replay!

Regards,
Christian