AppFlowy-IO / AppFlowy-IO/AppFlowy

[Bug] Number formatting (Currency) corrupts values and forces column format rollback upon losing focus

Abierto
#8,807 0 comentarios 0 reacciones 1 asignado Reclamado por @appflowy Ver en GitHub
Lenguaje dominante
Dart
Estrellas
76.6k
Forks
6k
Métricas de merge de PR
Sin PR fusionados en 30 d

Descripción

### Bug Description

There is an issue in the database Number property when using Currency formatting (like Euros or Czech Koruna). When a user enters a large integer (e.g., 3000000) into a column formatted as Currency, the application formats it correctly at first. However, as soon as the user navigates to another section and returns, the value is permanently truncated to decimals (e.g., 3.00). Furthermore, trying to fix this by changing the column format back to a plain number fails, as the application forces a rollback to the Currency format upon switching views.

### How to Reproduce

Create a database column with the property type set to Number.

Change the number format to Currency (Euro €).

Type a large round number into a cell (e.g., 3000000 for 3 million) without any spaces or symbols, and hit Enter. The UI initially displays it correctly.

Navigate away from the current view (e.g., switch to another sidebar document or database tab) and then return back to the original view.

Issue 1: The value in the cell is now permanently changed to 3.00. The original input of 3 million is lost.

Change the column format back to "No formatting" (None) or plain Number. The cell instantly displays the correct original value (3000000).

Navigate away from the view once again and return back.

Issue 2: The column has automatically switched itself back to Currency (Euro €) on its own, and the value is corrupted back to 3.00. The setting change was not preserved.

### Expected Behavior

The database should preserve the original numeric value entered by the user. Furthermore, when a user changes the column format (e.g., from Currency to plain Number), this setting must be permanently saved and must not automatically roll back to the previous format when changing views.

### Operating System

Windows 11

### AppFlowy Version(s)

0.12.2. (Official build)

### Screenshots

_No response_

### Additional Context

_No response_

Guía de contribución

No hay ninguna guía de contribución indexada para este repositorio

Evaluación

Este issue todavía no se ha evaluado.

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.