Column width-related bugs

[Jimmy]

Hello, my table initialization has set the width of the column, and I will set the table to allow-resizing. i drag and drop to adjust the width, then I reset the data source found that the cell selection and column width is not consistent with the ui on the problem, I did not find the corresponding solution in the document, I hope you can provide some help, thank you.

[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 datasource. So, before we proceed further, please share the below details. 

 

1.How you reset 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_6468d07e.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