Skip to content
This repository has been archived by the owner on Mar 31, 2022. It is now read-only.

Decimal separator is shown incorrect in PivotTable #631

Closed
konyashkina opened this issue Aug 19, 2021 · 2 comments
Closed

Decimal separator is shown incorrect in PivotTable #631

konyashkina opened this issue Aug 19, 2021 · 2 comments
Assignees
Labels
type: bug Something isn't working
Milestone

Comments

@konyashkina
Copy link

konyashkina commented Aug 19, 2021

Tested on:
Jmix version: 1.1.0-SNAPSHOT
Jmix Studio plugin version: 1.1.SNAPSHOT3437-211
IntelliJ version: IntelliJ IDEA 2021.1.3 (Community Edition)
OS. Windows 10 Pro

There are some numeric values like 125,912.36 and 236,999.08

Azooka-test-application-simple-table19082021-small

AR: These values are shown in PivotTable like '125' and 236':

Azooka-test-app-nonedit-pivot-table19082021

ER: Numeric values are shown properly in PivotTable.

I've tested it with different aggregation mode, looks like it doesn't matter.

Azooka-test-app-edit-pivot-table-sum19082021-small2

For QA

As an additional cases:

  1. Setup PivotTableExtension for the PivotTable and set totalBill property as a row:
    image
    And try to export this PivotTable. The value under Total Bill (19096.66) should be recognized as a number.
  2. Do the same but with Russian locale.
@konyashkina konyashkina added the type: bug Something isn't working label Aug 19, 2021
@glebfox glebfox added this to the 1.1.0 milestone Aug 24, 2021
@glebfox glebfox assigned Flaurite and unassigned glebfox Aug 24, 2021
@Flaurite
Copy link
Contributor

Caused by: #479

@konyashkina
Copy link
Author

Tested on:
Jmix version: 1.1.0-SNAPSHOT
Jmix Studio plugin version: 1.1.SNAPSHOT3454-211
IntelliJ version: IntelliJ IDEA 2021.1.3 (Community Edition)

Verified.
Decimal separator is shown correct in ui and in xlsx.
The additional cases tested (with LibreOffice to open xlsx): the value under Total Bill is recognized as a number.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
type: bug Something isn't working
Projects
None yet
Development

No branches or pull requests

4 participants