openpyxl some times does not ignore formula
Created originally on Bitbucket by Jānis Eisaks
Hi!
I observed such strange issue:
by default openpyxl ignores calculated fields, but in my case some times it is not happening so and openpyxl, searching for value, accepts the calculated one.
As a side effect of this is corruption of some graphs on different page of excel (again - at the time such glitch is observed)
Python 3.8.3/Win32/Linux64, latest openpyxl.
Janis
Attachments: example.pyexample.xlsxexample2.py