Skip to content

ODS read filter faulty behaviour on a cell with number-columns-repeated attribute #3148

Closed
@JokubasR

Description

@JokubasR

This is:

- [x] a bug report
- [ ] a feature request
- [ ] **not** a usage question (ask them on https://stackoverflow.com/questions/tagged/phpspreadsheet or https://gitter.im/PHPOffice/PhpSpreadsheet)

What is the expected behavior?

Read filter should correctly ignore cells with number-columns-repeated attribute.
Given we have a table and a read filter to include only A and D columns. Worksheet should contain values for columns A and D and null values for columns B-C.

A B C D
TestA TestD

What is the current behavior?

Current behaviour will only return the first column with value TestA. Column D will be ignored.

What are the steps to reproduce?

ODS file should contain at least two empty values in two neighbouring cells and read filter should be used to filter values in a cells before and after these empty cells.

Pull request with test case will be provided.

What features do you think are causing the issue

  • Reader
  • Writer
  • Styles
  • Data Validations
  • Formula Calculations
  • Charts
  • AutoFilter
  • Form Elements

Does an issue affect all spreadsheet file formats? If not, which formats are affected?

ODS

Which versions of PhpSpreadsheet and PHP are affected?

Probabaly since the commit 30a5e4b in 1.0.0-beta release.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions