Could not read all formulas from xlsx file ...

[Razmaniak]

Hi! I am novice in Python. I have found your great tool to parse various XLSX files and compare them with template files. Comparison aim is that in both files there should not be changes between formulas. After finishing implementation, on testing phase we have found an issue that the package do not read all formulas from one of the files, however in both files on the same cell we have the identical formulas. Could you please help me to find solution for this issue? If you will need more information, please contact me and I will provide full info for you.

Thank you in advance.
Regards,
David Razmadze

[staale]

Sorry for a late reply to this,

I would first take a look at the xml inside the xlsx file. You can unpack it with any zip program, and examine the contents. Are you able to produce a minimal file where one formula can be read, and the other cannot?

I would like to have a test file and unit test for this, then see if I can fix it. Also, if you have been able to fix this yourself, then please provide a patch so that I can add it to the library.

[Razmaniak]

Thank you for your reply! Sure I can provide you some test files. Please
see attached files. The content of shared formulas will not return nothing.

Thank you in advance! Looking forward for your solution!
Regards,

David

On Mon, Mar 10, 2014 at 3:13 PM, Ståle Undheim [email protected]:

Sorry for a late reply to this,

I would first take a look at the xml inside the xlsx file. You can unpack
it with any zip program, and examine the contents. Are you able to produce
a minimal file where one formula can be read, and the other cannot?

I would like to have a test file and unit test for this, then see if I can
fix it. Also, if you have been able to fix this yourself, then please
provide a patch so that I can add it to the library.

Reply to this email directly or view it on GitHubhttps://github.com//issues/19#issuecomment-37172001
.

[staale]

Sorry, I don't see any attachements. Possibly you replied via mail to the github mail address, in which case, the files where lost when the comment appeared here on github.

Perhaps try and fork this project, and create a commit with the file attached, and then create a pull request. That way we can add the file to the git repository, where it can reside for tests in the future.

[Razmaniak]

Hi again! I am really screwed up with forking the project to add some attachments there. I've decided to put the example files to my google share drive please follow to links:
https://drive.google.com/file/d/0BxmHDJV5vHy9NmN5LVZvZDNlVzJKUFRRbGhQcjY0Z3RqOVBj/edit?usp=sharing
https://drive.google.com/file/d/0BxmHDJV5vHy9TW1lM01tMFlXWFlYX29wNUdvT2tzbWJrSU5R/edit?usp=sharing

Thank you for understanding,
David