We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Hi.
I use spreadsheet, but if I enter data using Korean, the height of header cell and input cell does not match and it is selected strangely even when selected. Please refer to the red box in the attached photo.
I think it will be solved if you tell me how to set the cell height default value.
I would appreciate it if you could give me a solution as soon as possible.
Thank you for your answer.
But it didn't work out perfectly.
The first time you read a saved file, the height is good, but the same thing happens when you enter additional data later.
As you can see, up to the 7th row is data that has already been read from the stored state, and the 8th to 13th row entered after that is still experiencing problems.
So I added the same code to the cellSave event and tested it, but it was not solved.
Below is my code.
@{
ViewData["Title"] = "Working note";
}
<div class="row">
<div class="col-xl-12">
<ejs-spreadsheet id="spreadsheet" openUrl="Open" saveUrl="Save" height="840px" created="spreadsheetOpen" fileMenuBeforeOpen="fileMenuBeforeOpen" fileMenuItemSelect="fileMenuItemSelect" beforeCellRender="beforeCellRender" cellSave="cellSave"></ejs-spreadsheet>
</div>
</div>
<script>
function spreadsheetOpen() {
var spreadsheet = document.getElementById('spreadsheet').ej2_instances[0];
spreadsheet.addFileMenuItems([{ text: 'Save', iconCss: 'e-save e-icons' }], 'Open');
fetch('/WorkingNote/LoadExcel', {
method: 'POST',
headers: {
'Content-Type': 'application/json'
},
body: JSON.stringify({ FileName: "WorkingNote", sJobNo: sessionStorage.getItem('JobKey') })
})
.then((response) => response.json())
.then((data) => {
spreadsheet.openFromJson({ file: data });
})
}
function fileMenuBeforeOpen() {
var spreadsheet = document.getElementById('spreadsheet').ej2_instances[0];
spreadsheet.hideFileMenuItems(['Save As', "New", "Open"]);
}
//File - Save Click 시 file server에 저장
function fileMenuItemSelect(args) {
if (args.item.text == "Save") {
var spreadsheet = ej.base.getComponent(document.getElementById('spreadsheet'), 'spreadsheet');
var pdfSettings = { FitSheetOnOnePage: false };
spreadsheet.saveAsJson().then((Json) =>
fetch("/WorkingNote/SaveExcel?sJobNo=" + sessionStorage.getItem('JobKey'), {
method: 'POST',
headers: {
'Content-Type': 'application/json',
},
body: JSON.stringify({
FileName: "WorkingNote",
JSONData: JSON.stringify(Json.jsonObject.Workbook),
ContentType: "Xlsx",
VersionType: "Xlsx",
SaveType: "Xlsx",
PDFLayoutSettings: JSON.stringify(pdfSettings)
})
})
.then((response) => response.json())
.then((data) => {
console.log(data);
})
);
}
}
function beforeCellRender(args) {
args.needHeightCheck = true;
}
function cellSave(args) {
args.needHeightCheck = true;
}
</script>
