CODEWITHSUNDEEP
pythonexcelpython-2.7xlsxwriter
user8154530
user8154530

Reputation:

How to Ignore "Inconsistent Formula" warning showing in generated .xlsx file using the python xlsxwriter?

In my file there are MAX and MIN formulas in a row. Sample

CELLS - | A | B | C | D | E | F | G | H |

ROW: | MAX | MIN | MIN | MAX | MIN | MIN | MAX | MIN |MIN

If the excel sheet is opened a green triangle is displaying with a warning message "Inconsistent Formula".

Upvotes: 0

Views: 884

Answers (2)

sbp2024
sbp2024

Reputation: 1

Stumbled across this answer while looking for a way to do it in Python using the openpyxl package. However, up until now, I've always handled this with VBA. Here's an example:

Range("G18").Errors(4).Ignore = True

*where an index of 4 corresponds to an inconsistent formula

Upvotes: 0

jmcnamara
jmcnamara

Reputation: 41524

This is a standard Excel warning to alert users to the fact that repeated and adjacent formulas are different since that may be an error.

It isn't possible to turn off this warning in XlsxWriter.

Upvotes: 1

Related Questions