Preserve Formatting on Overwrite - List of Excel features that are preserved?

Question

Is there a list of Excel formatting features that are preserved somewhere?

2020.2 release-notes do not mention specifics.

I noticed that it keeps some really good things like column widths, freeze panes, auto-filter and even the auto-filter selections 🙂

But changes I made to the fill and font color are not...

Text-wrapping is also not preserved.

I haven't tested Conditional formatting yet, but read some posts that imply it is preserved.

KerryW · Answer

Setting Row Height, then having the text wrap seems to corrupt the file as well

atcodedog05 · Answer

Hi @MJ

If you specify the sheet range font color and background color seem to work. And seems like wrap text doesn't work at all.

Hope this helps : )

MJ · Answer

Bueller?

I've only really tested these and if some other users can add more in the comments we can crowdsource this :)

PRESERVED:

* Column widths
* Freeze panes
* Auto-filter and the auto-filter selections

NOT Preserved:

* Fill and Font Color
* Text-Wrapping