Skip to content

Bug: "Begins with" filter does not work on numeric columns #3712

@Cikaros

Description

@Cikaros

This issue is unique.

  • I have used the search tool and did not find an issue describing my bug.

Operating System of DocumentServer

Docker

Version information

9.4.0

Expected Behavior

Rows with values starting with 123 should be displayed:

  • 12345
  • 12399

Actual Behavior

All rows are hidden and the filtered result is empty.

Reproduction Steps

  1. Open a spreadsheet in OnlyOffice Spreadsheet Editor.
  2. Create a column containing numeric values, for example:
ID -- 12345 12399 45678
  1. Enable Auto Filter.
  2. Open the filter menu for the numeric column.
  3. Choose Custom FilterBegins with.
  4. Enter 123.
  5. Apply the filter.

Additional information

The same filter works correctly on text columns.
If the numeric values are converted to text, the filter behaves as expected.
This suggests that the "Begins with" operator may not correctly handle numeric cell types or may be applying string matching only to text-formatted cells.

Metadata

Metadata

Labels

No labels
No labels

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions