AppFlowy-IO/AppFlowy

Fork 0

mirror of https://github.com/AppFlowy-IO/AppFlowy.git synced 2026-03-24 12:56:59 +00:00

[GH-ISSUE #3096] [Bug] Handling of the currency Euro #1359

New issue

Closed

opened 2026-03-23 20:48:16 +00:00 by mirror · 5 comments

mirror commented

2026-03-23 20:48:16 +00:00

Owner

Originally created by @improve-code on GitHub (Aug 1, 2023).
Original GitHub issue: https://github.com/AppFlowy-IO/AppFlowy/issues/3096

Originally assigned to: @Xazin on GitHub.

Bug Description

I have a grid with a column formated as Euro (€):

If I enter ,,100" then ,,€100" is shown. (correct)
If I enter ,,1000" then ,,€1,00" is shown. (wrong)
If I enter ,,1000000" then ,,€1,00" is shown. (wrong)

If I enter ,,5,00" then ,,€500" is shown. (wrong, using "," as decimal seperator)

If I enter ,,5.00" then ,,€500" is shown. (also unexpected).

Additional Problem:
If I sort by the column Text ,,€1,00" is handeld as beeing of value €100 in the sorting. To get shown ,,€1,00" I entered ,,1000" or ,,1000000" (see above).

Additional Info:
1 euro (€) = 100 euro cent
Common notation: 1 euro (€) = 1,00 euro (€) = 100 euro cent

How to Reproduce

Create a new grid.
Click ,,+ New property"
Select ,,Numbers"
Select Euro as number format
Enter the mentioned values

Expected Behavior

For the right conversion see above.

Operating System

Linux

AppFlowy Version(s)

0.2.7

Screenshots

No response

Additional Context

No response

Originally created by @improve-code on GitHub (Aug 1, 2023). Original GitHub issue: https://github.com/AppFlowy-IO/AppFlowy/issues/3096 Originally assigned to: @Xazin on GitHub. ### Bug Description I have a grid with a column formated as Euro (€): > If I enter ,,100" then ,,€100" is shown. (correct) > If I enter ,,1000" then ,,€1,00" is shown. (wrong) > If I enter ,,1000000" then ,,€1,00" is shown. (wrong) > If I enter ,,5,00" then ,,€500" is shown. (wrong, using "," as decimal seperator) > > If I enter ,,5.00" then ,,€500" is shown. (also unexpected). Additional Problem: If I sort by the column Text ,,€1,00" is handeld as beeing of value €100 in the sorting. To get shown ,,€1,00" I entered ,,1000" or ,,1000000" (see above). Additional Info: 1 euro (€) = 100 euro cent Common notation: 1 euro (€) = 1,00 euro (€) = 100 euro cent ### How to Reproduce 1) Create a new grid. 2) Click ,,+ New property" 3) Select ,,Numbers" 4) Select Euro as number format 5) Enter the mentioned values ### Expected Behavior For the right conversion see above. ### Operating System Linux ### AppFlowy Version(s) 0.2.7 ### Screenshots _No response_ ### Additional Context _No response_

mirror

2026-03-23 20:48:16 +00:00

closed this issue
added the
Q3 24

grid

bug

2024
labels

mirror commented

2026-03-23 20:48:17 +00:00

Author

Owner

@annieappflowy commented on GitHub (Aug 12, 2023):

5,00 should be 5.00

v0.2.9 still reads 5,00 as 500, can't read 10.000 correctly

@annieappflowy commented on GitHub (Aug 12, 2023): 5,00 should be 5.00 v0.2.9 still reads 5,00 as 500, can't read 10.000 correctly

mirror commented

2026-03-23 20:48:17 +00:00

Author

Owner

@annieappflowy commented on GitHub (Aug 12, 2023):

Not sure I understand the Euro currency format fully though

@annieappflowy commented on GitHub (Aug 12, 2023): Not sure I understand the Euro currency format fully though

mirror commented

2026-03-23 20:48:17 +00:00

Author

Owner

@Xazin commented on GitHub (Jan 21, 2024):

The common in Europe is comma for decimals and dots for thousand separators.

So 5,00 is correct, and not 5.00, because that would have to be either 500 or 5.000,00 as in five-thousand.

I'll take a look and resolve it, but just to say before I do, that the above will be the result, let me know if there is any disagreement 😂

@Xazin commented on GitHub (Jan 21, 2024): The common in Europe is comma for decimals and dots for thousand separators. So `5,00` is correct, and not `5.00`, because that would have to be either `500` or `5.000,00` as in five-thousand. I'll take a look and resolve it, but just to say before I do, that the above will be the result, let me know if there is any disagreement :joy:

mirror commented

2026-03-23 20:48:17 +00:00

Author

Owner

@improve-code commented on GitHub (Jan 22, 2024):

To clarify:

I would use a dot (.) only, if there are exactly three numbers behind the dot
(three numbers following the dot, not separated by a comma).

e.g. 1.000 € (one thousand), 1.500 € (one thousand five hundred)

The dot (.) can be combined with a comma (,).

e.g. 1.200,50 € (one thousand two hundred euros and fifty (euro-)cents)

There can be multiple dots (.), each before three numbers following.

e.g. 1.000.000 € (one million)

Instead of dots you can also use a space ( ), in my opinion.

e.g. ,,1 000 000 €" = ,,1.000.000 €" (one million)

In my opinion dots aren't necessary to give a correct number.

If there exist other conventions, I don't know them.

@improve-code commented on GitHub (Jan 22, 2024): To clarify: 1. I would use a dot (.) only, if there are exactly three numbers behind the dot (three numbers following the dot, not separated by a comma). > e.g. 1.000 € (one thousand), 1.500 € (one thousand five hundred) 2. The dot (.) can be combined with a comma (,). > e.g. 1.200,50 € (one thousand two hundred euros and fifty (euro-)cents) 3. There can be multiple dots (.), each before three numbers following. > e.g. 1.000.000 € (one million) 4. Instead of dots you can also use a space ( ), in my opinion. > e.g. ,,1 000 000 €" = ,,1.000.000 €" (one million) 5. In my opinion dots aren't necessary to give a correct number. If there exist other conventions, I don't know them.

mirror commented

2026-03-23 20:48:18 +00:00

Author

Owner

@annieappflowy commented on GitHub (Jun 22, 2024):

Ok, so except for €500, everything else follows @improve-code 's suggestions. I consider this issue was resolved. Please open a new issue if there's anything we could improve regarding the Euro formats.

@annieappflowy commented on GitHub (Jun 22, 2024): <img width="145" alt="image" src="https://github.com/AppFlowy-IO/AppFlowy/assets/12026239/3eb3692b-3893-4bca-a024-5979eaf0b13f"> Ok, so except for €500, everything else follows @improve-code 's suggestions. I consider this issue was resolved. Please open a new issue if there's anything we could improve regarding the Euro formats.

mirror referenced this issue

2026-03-23 22:15:21 +00:00

[PR #1359] [CLOSED] Create PULLREQUEST_TEMPLATE.md #4682