- #Win32com freeze multiple panes in excel 2016 pro#
- #Win32com freeze multiple panes in excel 2016 code#
#Win32com freeze multiple panes in excel 2016 pro#
locale ( GH1866).īug Fix PRO Fixes the truncating of ranges with the remote interpreter in case the range was partly outside the used range ( GH1822).īug Fix PRO Fixes an issue with the remote interpreter that occurred on 64-bit versions of Excel.įeature PRO This release adds support for the remote interpreter to the Excel Desktop apps on both Windows and macOS. Like exclude, include accepts a comma-delimited string, e.g., “Sheet1,Sheet2” ( GH1882).Įnhancement PRO On Google Sheets, the xlwings JS module now automatically asks for the proper permission to allow authentication based on OAuth Token ( GH1876).īug Fix PRO Fixes an issue with Date formatting on Google Sheets in case you’re not using the U.S.
It’s the counterpart to exclude and allows you to submit the names of the sheets that you want to send to the server. This can be helpful if you experience issues with OneDrive/SharePoint: uncheck this box and provide the path where your source file is manually via the PYTHONPATH setting ( GH1873).Įnhancement PRO Added support for myrange.add_hyperlink() with the remote interpreter ( GH1882).Įnhancement PRO Added a new optional parameter include in connection with runPython (JS) and RunRemotePython (VBA), respectively.
The respective config is called ADD_WORKBOOK_TO_PYTHONPATH. You can change this (and all other options that Matplotlib’s savefig() and Plotly’s write_image() offer via (image=myfigure, export_options=) ( GH665, GH519).īug Fix macOS: Python modules on OneDrive Personal are now found again in the default setup even if they have been migrated to the new location ( GH1891).Įnhancement PRO The remote interpreter now shows nicely formatted error messages across all platforms ( GH1889).Įnhancement PRO Remote interpreter: added support for setting the number format of a range via myrange.number_format = "." ( GH1887).īug Fix PRO Remote interpreter: Google Sheets/Excel on the web were formatting strings like "1" as date ( GH1885).Įnhancement Further SharePoint enhancements on Windows, increasing the chance that mybook.fullname returns the proper local filepath (by taking into account the info in the registry) ( GH1829).Įnhancement The ribbon, i.e., the config, now allows you to uncheck the box Add workbook to PYTHONPATH to not automatically add the directory of your workbook to the PYTHONPATH. Also note that Google Sheets allows a maximum of 1 million pixels as calculated by (width in inches * dpi) * (height in inches * dpi), see also Matplotlib & Plotly Charts ( GH1906).īreaking Change Matplotlib plots are now written to Excel/Google Sheets with a default of 200 dpi instead of 300 dpi. Matplotlib/Plotly (note that Excel on the web and Desktop Excel via remote interpreter are not yet supported).
#Win32com freeze multiple panes in excel 2016 code#
Toggle table of contents sidebar What’s New # v0.27.11 (Jul 6, 2022) #Įnhancement Added support for pandas pd.NA ( GH1939).īug Fix Empty cells in UDFs are now properly returned as None / NaN instead of an empty string ( GH1947).īug Fix Resolved an issue with OneDrive/SharePoint files that are unsynced locally ( GH1946).īug Fix PRO This release fixes a FileNotFound error that could sometimes happen with embedded code ( GH1931).īug Fix Fixes a bug on Windows that caused an Excel Zombie process with pywin32 > v301 ( GH1929).Įnhancement Smarter shrinking of Excel tables when using mytable.update(df) as it doesn’t delete rows below the table anymore ( GH1908).īug Fix Fixed a regression when RunPyhon was used with Use UDF Server = True (introduced in v0.26.2) ( GH1912).īug Fix PRO The xlwings release command would sometimes incorrectly show a version mismatch error ( GH1918).īug Fix PRO xlwings Reports now raises an explicit error when Jinja2 is missing ( GH1637).įeature PRO Google Sheets now support pictures via () incl.
0 kommentar(er)
