Dots in values of string destroy whole table and randomly move data

[Nikita Kvasnin]

Dot in rows data destroy whole table and move data from rows part to values part for no reason. I attached dataSource in file(JSON format) to test it, here is FieldList:

screen 1, screen 2

How it looks like with normal dot:

screen 3

How it looks like when I replace all dots by another one:

screen 4

Code I used for replace normal dots:

[key, value.replace(/\./g, ".")]

screenshots - https://imgur.com/a/yRsABvt

Attachment: dataSource_ea76c59d.txt

[Nikita Kvasnin]

I tried to simulate some demo version of this bug, but Tabular mode works bad even here.

https://stackblitz.com/edit/react-rqrrx23d?file=index.js 

In this case I can't expand any row, it show infinity spinner.

I got issue I described not only with dots in data, but here is clear dataSet, mostly with numbers type in rows. It's same dataSet I saved in demo. You can see how everything was moved in wrong place. Mostly it happens when I got data from server and use Apply in FieldList, if I'll save this state it and reload page it works better. Also I use CustomAdaptor. 

[Sridhar Karunakaran]

Hi Nikita,

Thank you for sharing the code example and images. Please see the response below.

Query	Comments
Dot in rows data destroy whole table and move data from rows part to values part for no reason. I attached dataSource in file(JSON format) to test it, here is FieldList: screen 1, screen 2 How it looks like with normal dot: screen 3 How it looks like when I replace all dots by another one: screen 4 Code I used for replace normal dots: [key, value.replace(/\./g, ".")]	We understand that you're encountering an issue where value cells in the Pivot Table shift unexpectedly when using a data source that contains dot (.) characters in the field values.   After investigating the reported behavior, we would like to inform you that this problem arises because we use a dot (.) as the default separator to identify header levels in our pivot table. As a result, the row header that contains a dot (.) character (for example, 02. Náklady) is separated into different header texts (02 and Náklady) based on the dot (.) characters in the header text. Due to the new header cell, the remaining value cells in the pivot table shift from their previous positions.   To overcome this scenario, we suggest specifying a different delimiter (for example, ##) for header levels by setting the headerDelimiter property within the valueSortSettings. Please refer the below code example.   Code example:  let dataSourceSettings = {     valueSortSettings: { headerDelimiter: '##' },    }; Output screenshot: Meanwhile, we have provided a sample for your reference. You can find the sample at the following link. Sample: https://stackblitz.com/edit/react-arsykwpn-m5znb2yj?file=index.js   For more information on how to replace the dot (.) character with a different header delimiter, please refer to the Knowledge Base article below KB: https://support.syncfusion.com/kb/article/14444/how-to-expand-a-header-that-contains-a-dot-character
I tried to simulate some demo version of this bug, but Tabular mode works bad even here.   https://stackblitz.com/edit/react-rqrrx23d?file=index.js    In this case I can't expand any row, it show infinity spinner.   I got issue I described not only with dots in data, but here is clear dataSet, mostly with numbers type in rows. It's same dataSet I saved in demo. You can see how everything was moved in wrong place. Mostly it happens when I got data from server and use Apply in FieldList, if I'll save this state it and reload page it works better. Also I use CustomAdaptor.	We understand that you're currently experiencing the following issues: Pivot Table cells shifting to incorrect positions, even when dot (.) characters are not present in the data source. Inability to expand rows when using the Classic layout Pivot Table with a static field list.   If these are the issues you're encountering, we are actively validating both scenarios on our end. We will provide you with a detailed update within two business days, by June 27, 2025.

We appreciate your patience until then.

Regards,

Sridhar Karunakaran

[Narmatha Saminathan]

Hi Nikita,

Thanks for the patience. Please see the response below.

Query	Comments
1). Pivot Table cells shifting to incorrect positions, even when dot (.) characters are not present in the data source.	We understand that you’re encountering an issue where the Pivot Table cells shifting to incorrect positions, even when dot (.) characters are not present in the data source. W have confirmed this as a bug, titled "Pivot Table Cells Misalignment When Parent and Child Fields Have Identical Text” and the fix will be included in our upcoming July second weekly release which is expected to be roll out on July 8, 2025..   You can track the status of the issue using the feedback link provided below.   Feedback: https://www.syncfusion.com/feedback/68548/pivot-table-cells-misalignment-when-parent-and-child-fields-have-identical-text
2). Inability to expand rows when using the Classic layout Pivot Table with a static field list.	We understand that you're experiencing a problem where Inability to expand rows when using the Classic layout Pivot Table with a static field list. To investigate this, we tested the scenario on our end using a similar setup. However, we were unable to reproduce the issue and the Pivot Table functions as expected during expand/collapse operations with a static Field List and Classic layout.   For your reference, we’ve provided a working sample below. In this sample, we’ve ensured that the Field List and dataSourceSettings are properly synchronized using the load event, which prevents the issue from occurring. Please refer to the below code example for implementation.   Code Example:   function onLoad() {     setTimeout(() => {       pivotObj2 = document.getElementById('PivotView').ej2_instances[0];       fieldListObj2 = document.getElementById('PivotFieldList').ej2_instances[0];       fieldListObj2.pivotGridModule = pivotObj2;       //Assigning report to pivot table component.       pivotObj2.dataSourceSettings = fieldListObj2.dataSourceSettings;       pivotObj2.refreshData();     }, 200);   }   return (          <PivotFieldListComponent load={onLoad} > </PivotFieldListComponent>   );   Output GIF:   Meanwhile we have prepared a sample for your reference. Please find it from the below link.   Sample: https://stackblitz.com/edit/react-uhfr34nc-wzfuqm3w?file=index.js,pivot-data%2FPivot_Data.json

We appreciate your patience until then.

Regards,

Narmatha Saminathan.

[AngelinFaithSheeba PaulvannanRajadurai]

Hi Nikita,

Thank you for your patience. We are glad to announce that our weekly release v30.1.39 has been rolled out. This release includes the fix for the reported issue titled "Pivot Table Cells Misalignment When Parent and Child Fields Have Identical Text”. Additionally, we have prepared a sample using the latest version. You can find the sample at the link below.

Sample: https://stackblitz.com/edit/react-uhfr34nc-2le73dm4?file=package.json

Output GIF:

Issue root cause:

The reported issue occurred because the row header span in the Pivot Table was applied based on the formatted text. This has now been resolved by applying the span using the level name instead in the pivot table.

We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance.

Regards,
Angelin Faith Sheeba