Skip to content

Excel Style Filters cannot enter negative decimal values like for numeric column #15808

@georgianastasov

Description

@georgianastasov

Description

When using Excel Style Filtering in igx-grid, filtering a numeric column (e.g., Price or Unit Price) with a "Greater Than" condition prevents users from entering certain negative decimal values such as -0.01.

The issue occurs because the input automatically removes the negative sign when typing values like -0, breaking the natural typing flow. This only affects numeric columns and does not occur in Quick Filtering or Advanced Filtering, where such values are accepted correctly.

This affects user experience, especially in cases involving fine-grained financial or statistical data.

  • igniteui-angular version: 19.0, 19.2
  • browser: All modern browsers — Chrome, Firefox, Edge

Steps to reproduce

  1. Open the Excel Style Filtering sample here:
    https://www.infragistics.com/products/ignite-ui-angular/angular/components/grid/excel-style-filtering#angular-grid-excel-style-filtering-example
  2. Open filtering dropdown for a numeric column (e.g., Price or Unit Price).
  3. Select the "Greater Than" operator.
  4. Attempt to enter -0.01 directly into the input box.
  5. Notice that typing -0 auto-corrects by removing the minus sign, making it impossible to complete -0.01 normally.

Result

The minus sign is stripped from the input as soon as the user types -0, preventing proper entry of -0.01.

Expected result

Users should be able to enter negative decimal values like -0.01 naturally, without having to workaround input restrictions. The input should preserve the minus sign during entry, similar to behavior in Quick Filtering and Advanced Filtering.

Attachments

See the official sample from the docs:
https://www.infragistics.com/products/ignite-ui-angular/angular/components/grid/excel-style-filtering#angular-grid-excel-style-filtering-example

Metadata

Metadata

Labels

🐛 bugAny issue that describes a bug✅ status: resolvedApplies to issues that have pending PRs resolving them, or PRs that have already merged.gridgrid: excel-style-filtering

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions