Felix Zumstein

icon indicating a website link https://www.xlwings.org icon indicating an email [email protected]

icon company xlwings icon location Lucerne icon location xlwings creator | O'Reilly author | LinkedIn instructor | htmx fan

Results 83 issues of Felix Zumstein

xlwings Reports: None is treated differently in placeholders that are in cells vs in shapes

* placeholder in cells disappears * placeholder in shapes shows `None`

bug
PRO

Log which py files have been embedded during `xlwings release` command

PRO

Add malwarebytes instructions to troubleshooting docs

1 comment

1) 2)

docs

Make it easier to switch back and forth between a "release" version and a "development" version

i.e. introduce the opposite of `xlwings release` command.

Raise a proper error when it can't find the Python interpreter with UDFs

I think this is currently only handled for RunPython call and could end up in a `Run-time error '5': Invalid procedure call or argument` when importing UDFs.

enhancement

reports: Excel tables without Header Row and outside of a Frame don't apply the cell format downwards

* works inside a Frame * e.g., format a column with only 1 decimal * expanded rows will have 2 decimals

bug
PRO

Support more PageSetup properties

3 comment

* paper size * margins * center on page * Orientation * Scaling

enhancement

Refactor Config handling

2 comment

* consistent keys (uppercase with underscore), but accept lowercase with spaces, too, for legacy compatibility * central handling in Python * allow non-ASCII characters * cross-platform compatibility (currently, config files...

Refactoring

reports: raise an error if the reports template uses a placeholder that's not provided

PRO

Add support for table_rows and table_columns properties

see #1597: the tables API currently doesn't support proper slicing of columns/rows and selecting them by name instead of just by position.

enhancement