Error when using saveAsJson after cloning spreadsheet

Filter.getFilterRangeHandler error occurs when clicking the save button after duplicating the spreadsheet.

The error capture and source are attached.





<App.vue>


<template>
<div id="app">
<div class="control-section">
<button
@click="update"
>{{ 'save' }}button>
<div class="default-section">
<ejs-spreadsheet
id="spreadsheet"
ref="spreadsheet"
:openUrl="openUrl"
:saveUrl="saveUrl"
:allowSave="true"
locale="en"
height="600px">ejs-spreadsheet>
div>
div>
div>
template>
<script>
import '@syncfusion/ej2-vue-spreadsheet/styles/material.css'
import '@syncfusion/ej2-base/styles/material.css'
import '@syncfusion/ej2-buttons/styles/material.css'
import '@syncfusion/ej2-calendars/styles/material.css'
import '@syncfusion/ej2-dropdowns/styles/material.css'
import '@syncfusion/ej2-inputs/styles/material.css'
import '@syncfusion/ej2-navigations/styles/material.css'
import '@syncfusion/ej2-lists/styles/material.css'
import '@syncfusion/ej2-popups/styles/material.css'
import '@syncfusion/ej2-splitbuttons/styles/material.css'
import '@syncfusion/ej2-grids/styles/material.css'
export default {
name: 'App',
data: function () {
return {
openUrl: 'https://ej2services.syncfusion.com/production/web-services/api/spreadsheet/open',
saveUrl: 'https://ej2services.syncfusion.com/production/web-services/api/spreadsheet/save'
}
},
methods: {
update () {
const spreadsheet = this.$refs.spreadsheet
spreadsheet.endEdit()
spreadsheet.saveAsJson().then(Json => {
console.log('get data from json', Json)
})
}
}
}
script>
<style>
#app {
font-family: 'Avenir', Helvetica, Arial, sans-serif;
-webkit-font-smoothing: antialiased;
-moz-osx-font-smoothing: grayscale;
text-align: center;
color: #2c3e50;
margin-top: 60px;
}
style>

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

<main.js>


import Vue from 'vue'
import App from './App'
import router from './router'

import { SpreadsheetPlugin } from '@syncfusion/ej2-vue-spreadsheet'
import { registerLicense } from '@syncfusion/ej2-base'
registerLicense('ORg4AjUWIQA/Gnt2VVhhQlFaxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx=')

Vue.config.productionTip = false

Vue.use(SpreadsheetPlugin)

/* eslint-disable no-new */
new Vue({
el: '#app',
router,
components: { App },
template: ''
})


3 Replies

SP Sangeetha Priya Murugan Syncfusion Team May 13, 2022 10:00 AM UTC

Hi Kyung,


We have created the sample based on your provided codes and the reported issue doesn’t occurs in our end.  Please find the sample Link below.


Sample Link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/quickstart-1639244454


So, before we proceed further, please share the below details.


1.Please share the detailed issue description

2. Share proper issue replication video

3. If possible, please replicate your issue in the above sample and send back to us.

4. Share the data that you have loaded in spreadsheet.

5.Please share your Essential studio product version.


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


Regards,

Sangeetha M





KR Kyung-hyun Roh May 17, 2022 08:05 AM UTC

On save, it succeeds.

However, when I click the save button after duplicating the sheet as in the attached video, an error occurs.


version : "@syncfusion/ej2-vue-spreadsheet": "^20.1.52"



Please check the attached video.


Attachment: bandicam_20220517_165845284_d4582be7.zip


SP Sangeetha Priya Murugan Syncfusion Team May 17, 2022 01:31 PM UTC

Hi Kyung,


Your reported issue is already resolved in our latest version (20.1.55). So, we would suggest you to use the latest package to resolve this issue in your end. For your convenience, we have prepared the sample with our latest version based on your provided codes. Please find the link below.


Sample Link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/quickstart-231300247


Could you please check this issue with the latest version and get back to us with the issue replicable sample, if you still getting the same issue or need any further assistance on this.


Regards,

Sangeetha M



Loader.
Up arrow icon