Cellfie cannot process Excel Spreadsheets that have calculated values

[matthewhorridge]

The error message for this isn't helpful either....

"Error opening file example.xls"

[csnyulas]

Related to #57

[martinjoconnor]

The POI library used by Mapping Master handles calculated value. Do you have an example spreadsheet?

[matthewhorridge]

The POI library used by Mapping Master handles calculated value. Do you have an example spreadsheet?

	A	B
1	Arm	= "Skin of " & A1
2	Foot	= "Skin of " & A2

[vipeReu]

The way I worked around it (even tho its not very pretty) is to copy all the values and paste them into a new file, but when pasting instead of using CTRL+V, I right-click on the cell A1, go to the paste options in the popped up window and click on values. Thats how I managed to make it work.

[martinjoconnor]

I'll try to look at this in the next few weeks. Have some other pressing tasks at the moment.

[malekjaber]

I receive a similar error message in protege cellfie when importing data from an excel file with has formulas in the data fields.

For reference, I attached a sample spreadsheet which has formulas in column D.

The current workaround that I am doing is to copy Column D and paste as values into a new column and then remove column D. It would be great if the protege cellfie would handle this by default.

2021-Oct-25 - Cambridge Cleaned-formatted-date.xlsx