Losing formulas and some styling when updating .xlsx

[thherman]

Hi,

I am trying to update a template file containing some formulas and simple cell styling. When i do so, I notice that:

• Excel warns me about some potential problems
• The styling is lost in most cells where content is empty
• The formulas don't work anymore

All I did was write a single cell (the date value) just to test the library. Can someone help me with this problem ?

I am using version 2.0.0-null-safety-3

Warnings:

Template:

Result:

[justkawal]

PR are welcome

[RogerBrusamarello]

Any updates here?

[MalikSamiAwan]

@thherman any solution ran into same problem

[al4nnw]

This is very important. Working with templates is way easier than recreating the basefile with code. I tried openpyxl and it correctly opens the file without loosing any information.

[salcam]

any news on this problem? I've the same error. Maybe the temp solution can be to use python in dart with openpyxl library.

[bmsrangel]

I'm having the same issue as well

[al4nnw]

I ended up setting a firebase function with a python + openpyxl to manipulate the file correctly.

[bmsrangel]

I ended up setting a firebase function with a python + openpyxl to manipulate the file correctly.

Thanks for the tip! I'll check it out!