Saving problem

Dec 23, 2013 at 8:23 AM
Edited Dec 23, 2013 at 11:28 AM
I successfully create an xlsx file. However, when I open the files and then try to close them I am prompted with the question asking if I want to save the document (Even if I dont make any changes).

Without explicitly opening the file and saving it, reading the xlsx file returns some values as null. What can be the problem, any ideas ? I exactly follow the instructions in documentations.

Further examination shows that the cell values which are null, are the ones that contain a formula. Only after saving the sheet manually I can read these values. This is also mentioned here:
Mar 7, 2014 at 5:57 PM
I'm experiencing the same problem. If I do not open and save the spreadsheet certain cells are read as null by the program even though there is text in the cell.