PhpSpreadsheet icon indicating copy to clipboard operation
PhpSpreadsheet copied to clipboard

Table Xlsx Reader and Autofilter

Open aswinkumar863 opened this issue 2 years ago • 2 comments

This is:

- [ ] a bugfix
- [x] a new feature
- [x] refactoring
- [x] additional unit tests

Checklist:

  • [x] Changes are covered by unit tests
    • [x] Changes are covered by existing unit tests
    • [x] New unit tests have been added
  • [x] Code style is respected
  • [x] Commit message explains why the change is made (see https://github.com/erlang/otp/wiki/Writing-good-commit-messages)
  • [ ] CHANGELOG.md contains a short summary of the change
  • [ ] Documentation is updated as necessary

Why this change is needed?

Implement Table when an XLSX spreadsheet is loaded

In this Commit:

  • Added Table Xlsx reader.
  • Covered with unit tests.
  • [new] Autofilter inside Tables

To be done:

  • ~Take action on failed AutoFilter's Filter expressions test (testLoadOffice365AutoFilter).~
  • ~Plan Table Filter expressions.~

aswinkumar863 avatar May 15 '22 08:05 aswinkumar863

@MarkBaker

I have just added a reference to the worksheet autofilter inside the table. That enables a complete autofilter support to tables. Please share your thought on this.

aswinkumar863 avatar May 29 '22 14:05 aswinkumar863

@MarkBaker

Any update on this

aswinkumar863 avatar Jun 10 '22 13:06 aswinkumar863

Sorry that it's taken me so long to get round to assessing this PR, but providing that support for pivot tables is an incredibly useful feature. Thank you for working on this

MarkBaker avatar Oct 11 '22 10:10 MarkBaker