hi!
I'm writing xlsx with some python modules (eg xlsxwriter), and I find, when
opening the result with gnumeric that I have to hit recalculate to see the
calculated values
for example, with this script:
##########
import xlsxwriter
workbook = xlsxwriter.Workbook('demo.xlsx')
worksheet = workbook.add_worksheet()
worksheet.write('A1', 1)
worksheet.write('B1', 2)
worksheet.write('C1', '=A1+B1')
workbook.close()
#############
when I open demo.xlsx with gnumeric, I see:
[image: image.png]
and after I hit F9 the value of C1 appears:
[image: image.png]
do you know why this is happening? I tried openpyxl and it does the same
thing
just in case it was some bug in the libraries, I tried libreoffice and wps
and they do show the calculated value on open
I'm using gnumeric 1.12.41
tia,
René
_______________________________________________
gnumeric-list mailing list
[email protected]
https://mail.gnome.org/mailman/listinfo/gnumeric-list