Default Border option

[N2ITN]

Is there a way to have the default Excel borders around cells?
Setting Styler(border_type=None) will eliminate borders around cells, but I want the default background grid.

[DeepSpace2]

This is an unfortunate side-effect of Styler defaulting to a white background ("Fill" in Excel terminology).
The workaround is to set fill_pattern_type=None when using a borderless style with the default fill/background color:

Styler(border_type=None, fill_pattern_type=None)

The permament solution could be to have Styler automatically set fill_pattern_type to None whenever it detects that border_type is None and bg_color is white, but then we may get someone who actually wants this behavior openning an issue 😉

[N2ITN]

Thank you!

[DeepSpace2]

In a future version (hopefully 2.0) this will be the default behavior as it makes more sense.

[DeepSpace2]

In version 3 there will be a shortcut to achieve this. Styler(border_type=utils.borders.default_grid) will be the equivallent for Styler(border_type=None, fill_pattern_type=None).