* Mark as worktable (#149)
* mark table data as Worksheet Table
* fix Excel overwriting error
* fix column names being overwritten by
* tag header row, keep column names from dataframe
* validate columns for no empty strings or duplicates
* restore missing col name in iris.py, remove table cell formatting, and auto fit column widths
Co-authored-by: ryooj <jaehee.ryoo@ons.gov.uk>
* Change font size (#148)
* Change font size for theme
Update theme font size to meet best practice guidence and update the .pickle
* Add example for personalised theme
* Update test_theme unit test
* Replace blank and empty string type cells with missing value marker, with example (#151)
* Add font colour as automatic to theme (#150)
* Add font colour as automatic to theme
Add font colour as automatic to both gptheme and iris_test_theme
update .pickle for gptheme
update test_theme.py to pass for font_color
* Fix column heading format (#152)
* Hardcode column heading format
* Use column heading format from yaml
Co-authored-by: Rowan Hemsi <70013144+rowanhemsi@users.noreply.github.com>
* Change default auto-wrap setting to True (#153)
WIth the option set to false, it is likely that the resulting spreadsheets will have hidden text. Setting to True ensures that all text within the table is fully visible
* Fix `class` column header in iris python examples (#154)
* Wrap table cells by default
* Set column width to line length
Previously, auto-width ignored line breaks, meaning it wrapped to the full length of the string. This meant that columns with multi-line strings (e.g. containing the unit at the bottom) were wider than they should be. The updated function calculates the length of the longest line within each string rather than just the full length of the string
* Update theme settings (#158)
* Update gptheme
changes the font size and remove italics from gpthemes
* Remove italics from iris example
* Update test_theme.py
* Append units to column headings
* update documentation
* Update code examples
* Add name property to marked up tables (#159)
* Add meaningful name to tables
* Update example table names
* Fix test fixture generate_gptable
* Update tests
* Change missing value replacement to error raising (#161)
* Wrap table cells by default
* Set column width to line length
Previously, auto-width ignored line breaks, meaning it wrapped to the full length of the string. This meant that columns with multi-line strings (e.g. containing the unit at the bottom) were wider than they should be. The updated function calculates the length of the longest line within each string rather than just the full length of the string
* Append units to column headings
* update documentation
* Update code examples
* Update tests
* Change missing value replacement to error raising
* Raise error for cells containing only symbols
* Resolve merge conflict
* Raise error for cells containing only symbols
* Remove asyncio/windows_events import
Co-authored-by: Dan Shiloh <daniel.shiloh@ons.gov.uk>
* Notes accessibility (#163)
* Move table description above table
* Fix tests
* Fix cover
* Add class
* Fix notesheet class
* Refactor notesheet
* WIP: Add contentsheet class
* Fix contentsheet
* Fix tests
* Sort notes table by reference order
* Relocate notesheet
* Reformat note references
* Add note link functionality
* Add note link text formatting
* Refactor table of contents
* Add contents_options dictionary
* Refactor set_annotations
* Add annotations attribute and update_annotations and make_notesheet methods to GPWorkbook
* Write gptables using wb.annotations
* Delete notesheet class
* WIP: parse urls
* Add write_url option
* Set annotations attributes/methods to internal and autoupdate
* Update documentation and tests
* Fix _smart_write logic flow
* WIP custom formatting
* Address minor comments
* WIP: Add FormatList class
* Custom formatting in title
* Custom formatting for string attributes
* Fix set_source
* Fix tests
* Update TODO list
* Add custom formatting for legend
* Fix test_valid_text_in_list_attr
* Add table of contents internal links
* Refactor _smart_write
* warn blank cells (instead of error) use write_blank
* Minor changes following review
Co-authored-by: Ryoo <jaehee.ryoo@ons.gov.uk>
* Fix example titanic.py
* Remove quick_and_dirty method (#167)
* Bugfix autowidth (#169)
* Fix autowidth to work for text with links and lists of text
* Change regex to get rid of DeprecationWarning
* Move note references to end of text elements (#166)
* Move column heading note references to newline (#165)
* Move column heading note references to newline
* Fix theme test setup
* R example (#164)
* R example fixed
* Add R dependency managment script for reticulate example
* Add note about running R example
* Add package function to iris.R
* remove redundant code
* Remove redundant code
* Fix group_by declaration
Co-authored-by: Rowan Hemsi <rowan.hemsi@ons.gov.uk>
* Fix and update python examples (#162)
* Fix additional features example to remove future warning
* Remove legacy code from iris_additional_formatting.py
* Fix example iris_personal_theme, remove os import from cor
* Clean iris.py example
* Clean iris_personal_theme.py and .yaml
* Clean iris_personal_theme.py and .yaml
* Edit default gptheme.yaml and add pickle
* Update titanic.py example with notes from csv
* Fix selecting of cols when applying additional formatting
* Change col name and units to correct cols
* Rename 'variable' col
* Fix cover URLs and example
* Clean col names
* Add unique sheet titles for CoR example
* Fix unit and additional formatting interaction
* Fix test theme
Co-authored-by: Ryoo <jaehee.ryoo@ons.gov.uk>
Co-authored-by: Rowan Hemsi <rowan.hemsi@ons.gov.uk>
* Update R example for new release (#171)
* Update R example for new release
* Fix table_notes and typo in R example
Co-authored-by: Rowan Hemsi <rowan.hemsi@ons.gov.uk>
* Update user docs (#170)
* Update user docs
* Fix elements list for annotations
* Fix autowidth for rich text formatting
* Update TODO comments
* More user docs updates
* Replace references to GSS and BPI with AF equivalents
* Update doc strings that appear in user docs
* Update usage docs page
* Fix mailto link description
* Update changelog (#168)
* Fix version in changelog
* Add changes to `Unreleased` section of changelog
* Bugfix legend (#172)
* Update elements lists for annotations and links
* Fix url formatting
* Resolve merge conflict
* Update version number
Co-authored-by: ryooj <jaehee.ryoo@ons.gov.uk>
Co-authored-by: Jacob Cole <77634686+Jacobb164@users.noreply.github.com>
Co-authored-by: shilohd <57630783+shilohd@users.noreply.github.com>
Co-authored-by: Dan Shiloh <daniel.shiloh@ons.gov.uk>
