Cellfie cannot process Excel Spreadsheets that have calculated values
matthewhorridge opened this issue · 6 comments
The error message for this isn't helpful either....
"Error opening file example.xls"
The POI library used by Mapping Master handles calculated value. Do you have an example spreadsheet?
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 |
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.
I'll try to look at this in the next few weeks. Have some other pressing tasks at the moment.
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.