CODEWITHSUNDEEP
openpyxllibreoffice-calc
mlg
mlg

Reputation: 151

When using openpyxl on linux with LibreOfficeCalc ... boolean cell values get saved as formulas

Using openpyxl, when I save a Boolean value to a cell, the resulting (libreoffice-calc) spreadsheet shows the value as a formula instead of as a Boolean.

cell.value = True

After setting the value, the cell.data_type is 'b', and the cell.value is True.

When I save and then open the spreadsheet with openpyxl and read the cell, the data_type is 'f' with the value being '=True()'

When I open the spreadsheet with libreoffice-calc, the value is the formula =True()

Is this a bug, a feature, or operator error on my part?

Upvotes: 0

Views: 39

Answers (0)

Related Questions