Features to document

[JanMarvin]

For release 1.2

• various pivot tables (but PT need documenting in manual and vignette/book)

  • show_data_as [pivot tables] add show_data_as and compact/outline #833
  • compact/outline [pivot tables] add show_data_as and compact/outline #833
  • case names [pivot tables] use standardize_case_names() and as_xml_attr() #836
  • choosing variables [pt] add choose param #840 / [pt] cleanup choose #858 (latter has example with picture)
  • item selection [pt] Improve item selection and fix slicers names with whitespace #842

• cloning column/row formatting [clone] column and row styles #839

• improvements to copy cells [copy_cells] copy hyperlinks and fix handling of transposed cells. fixes #846 #850/[copy cells] fill empty cells #851/[copy_cells] pass ... to wb_add_data(). close #852 #855 (needs documenting in manual, vignette and book)

• fixes

  • named region index [named region] fix local_sheet counting. fixes #829 #830
  • formula escaping
  • fixed wasm builds `openxlsx2` in webr #849
  • restore min/max width options

Feel free to pick any or none @olivroy. Sorry, took me a moment. We probably might expand this issue for the future and it probably is no release stopper. Please let me know what you think.

[JanMarvin]

I've extended the pivot table segment in the book, since it requires a few images to explain what is supposed to happen. It's still a draft, but at least a little more documented.

[JanMarvin]

Round two of documenting pivot tables is done: https://janmarvin.github.io/ox2-book/chapters/openxlsx2_pivot_tables.html

[JanMarvin]

And there is some documentation regarding copying and cloning of cells and worksheets: https://janmarvin.github.io/ox2-book/chapters/openxlsx2_clone_and_copy.html