pageSetup causes issues

[JanMarvin]

To reproduce. Seeing the issue with Windows 10 and Excel 16. Not sure when or why it happens

wb_workbook()$add_worksheet("cars")$add_data("cars", cars)$open()

[JanMarvin]

Or better, I know why it happens. rid 2 is vmldrawing and not pageSetup, though unsure why it isn't reporting on Mac ms365. And what precisely pageSetup expects. Maybe the printer setup binary file I removed. Can pageSetup be removed entirely? So many questions

[JanMarvin]

looks like removing rId fixes the issue. in default worksheet _rels and in pageSetup. I'll add a pull request

[JanMarvin]

openxlsx2/R/class-workbook.R

Line 3542 in bba1ec3

'<pageSetup paperSize="%s" orientation="%s" scale = "%s" fitToWidth="%s" fitToHeight="%s" horizontalDpi="%s" verticalDpi="%s" r:id="rId2"/>',

openxlsx2/R/class-worksheet.R

Line 212 in 587b96e

self$pageSetup <- sprintf('<pageSetup paperSize="%s" orientation="%s" horizontalDpi="%s" verticalDpi="%s" r:id="rId2"/>', paperSize, orientation, hdpi, vdpi) ## will always be 2

openxlsx2/tests/testthat/test-helper_functions.R

Line 62 in f9959be

exp <- "<pageSetup paperSize=\"9\" orientation=\"landscape\" scale = \"50\" fitToWidth=\"0\" fitToHeight=\"0\" horizontalDpi=\"300\" verticalDpi=\"300\" r:id=\"rId2\"/>"