cellfie-plugin icon indicating copy to clipboard operation
cellfie-plugin copied to clipboard

It would be nice if Cellfie could import values from cells that contain formulas

Open csnyulas opened this issue 9 years ago • 1 comments

Spreadsheet content often needs to be processed in a way that is either not supported or it is much more difficult to do with MappingMaster directives and functions. However, in some of such cases the content of the spreadsheet cells could be easily pre-processed within Excel with formulas that use available Excel functions. However Cellfie, at the moment, can't interpret cell values that contain formulas. It would be really nice if Cellfie could import values of cells that contain formulas, especially if this is functionality could be provided by the underlying Excel library used to read spreadsheet content.

csnyulas avatar May 12 '16 19:05 csnyulas

POI does support Excel formula evaluation:

http://www.codejava.net/coding/working-with-formula-cells-in-excel-using-apache-poi

I don't know if the evaluation hooks are currently active but it probably would not be a huge deal to enable them.

martinjoconnor avatar May 16 '16 17:05 martinjoconnor