Wrong row of data problem

[Jimmy]

Hello, I found spreadsheet plug-in in adjusting the width of the column will appear after the cell data display the wrong row problem, double-click the cell after the display of the value and not double-click inconsistent, but not all cells are like this, I did not find the law, I hope you can solve this problem.

[Sangeetha Priya Murugan]

Hi Jimmy, 

 

Thank you for contacting Syncfusion support. 

 

We have checked your reported issue and we suspect that you have used some customization in your end. So, before we proceed further, please share the below details. 

 

1.How you load the dataSource in spreadsheet, please share the sample data 

2.Please share the spreadsheet sample customization codes 

3.Your Essential studio product version. 

4.If possible, please share the issue replicable sample 

5. Detailed description with video demonstration of this issue. 

 

Could you please check the above details and get back to us with the above requested information, based on that we will check and provide you a better solution quickly. 

 

Regards, 

Sangeetha M 

[Jimmy]

Hi, spread-sheet I did use a lot of custom configurations, as follows.

In fact, I found that e-column can only configure the width, the rest are cells rendered with e-range.

<ejs-spreadsheet

ref="spreadsheet"

:height="tableHeight"

width="100%"

:allow-filtering="false"

:sort-complete="sortComplete"

:allow-cell-formatting="true"

:allow-sorting="true"

:allow-resizing="true"

:selection-settings="selectionSettings"

:data-source-changed="dataSourceChanged"

:before-cell-save="beforeCellSave"

:allow-conditional-format="allowConditionalFormat"

:allow-data-validation="allowDataValidation"

:allow-delete="deleteAble"

:allow-editing="editAble"

:allow-hyperlink="false"

:allow-image="allowImage"

:allow-insert="false"

:allow-merge="false"

:allow-open="false"

:allow-save="false"

:allow-scrolling="true"

:allow-sort="true"

:allow-undo-redo="true"

:enable-keyboard-navigation="true"

:enable-keyboard-shortcut="true"

:show-ribbon="riddon"

:show-sheet-tabs="false"

:show-formula-bar="false"

:enable-clipboard="true"

:locale="$i18n.locale"

:cell-style="cellStyle"

:scroll-settings="scrollSettings"

:allow-wrap="false"

:allow-chart="false"

:allow-number-formatting="false"

:allow-auto-fill="false"

>

<e-sheets>

<!-- 默认识别json数据作为表头以及cell的填充 -->

<e-sheet

:is-protected="isProtected"

:protect-settings="{ selectCells: true }"

:created="spreadsheetCellFormat"

:frozen-rows="1"

>

<e-ranges>

<e-range :data-source="priceData" />

</e-ranges>

<e-columns>

<e-column v-for="(item,index) in columnData" :key="index" :width="item.width" />

</e-columns>

<e-rows>

<e-row>

<e-cells>

<e-cell v-for="(item,index) in columnData" :key="index" :value="item.prop" />

</e-cells>

</e-row>

</e-rows>

</e-sheet>

</e-sheets>

</ejs-spreadsheet>

Attachment: priceData.json_b63a2bfe.zip

[Sangeetha Priya Murugan]

Hi Jimmy, 

We need to validate more on your reported issue, so we will update you the further details on January 7^th, 2022. 

Regards, 

Sangeetha M 

[Jimmy]

Okay, thanks

[Sangeetha Priya Murugan]

Hi Jimmy, 

 

We have validated your reported issue based on your provided code snippets and data, but we are not able to render your application. Because you have done customization in some events like dataSourceChanged, beforeCellSave etc.  

 

We have created the sample based on your provided code by removing the event level customization script codes. Please find the sample Link below. 

 

Sample Link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/quickstart68829078  

 

Could you please check the above sample and replicate your issue with event related customization and send back to us with video demonstration? Based on that we will check and provide you a better solution quickly. 

 

Regards, 

Sangeetha M