ycphs / openxlsx

openxlsx - a fast way to read and write complex xslx files
https://ycphs.github.io/openxlsx/
Other
224 stars 75 forks source link

Preserve window size and position, also get and set (Clean Version) #487

Closed michael-dewar closed 3 months ago

michael-dewar commented 3 months ago

This PR will preserve the size and position of the window when you open the xlsx in Excel. There are also functions to set and get directly.

This PR replaces earlier PRs #466 and #383. Those got out of date and I was unsuccessful at properly rebasing them.

This code is lean in that it only touches the bare minimum of the original code. It also adds one file with two new functions, a file with tests for those functions, and related documentation.

The outputted xlsx files open cleanly on popular spreadsheet software on Mac and Windows, and web versions of spreadsheet software.

JanMarvin commented 3 months ago

Thanks, looks good!