Hi Ngoc Hoang,
We have reviewed
your reported query based on the shared sample and file. We would like to
inform you that the `openComplete`
event gets triggered once the Workbook model is received from the server. If a
cell in the opened file contains a formula, only the formula will be available
in the model initially. The value of the formula will only be available after
the sheet is rendered into the DOM. Since the `openComplete` event is
triggered before the sheets are rendered, the formula of the cell is not
calculated and so the cell value is undefined at that moment, leading to the
issue you reported.
And if you want to get
the cell value in the `openComplete` event, you can utilize the setTimeout
function
like in the below code snippet
to get the value of the cells and also attached the sample for your reference,
|
const openComplete = () => {
const spreadsheet = spreadsheetRef.current;
isOpenComplete = true;
if (spreadsheet) {
setTimeout(()
=> {
spreadsheet
.getData('SheetA!A1:W25')
.then((cells) => {
const cell = cells.get('A1');
console.log('cell', cell);
console.log('Value', cell.value);// => this value is undefined
})
.catch((e) => console.log(e));
})
}
};
|
Sample link:
https://stackblitz.com/edit/react-yu8m9t-lhrrvx?file=index.js
Or else, you can
use the `dataBound`
event, which will be triggered once the sheet renders. In that event, you can
get the cell value using the getData method like in the below code snippet and
also attached the sample for your reference,
|
const dataBound = (args) => {
const spreadsheet = spreadsheetRef.current;
if (spreadsheet) {
spreadsheet
.getData('SheetA!A1:W25')
.then((cells) => {
const cell =
cells.get('A1');
console.log('cell',
cell);
console.log('Value',
cell.value);
})
.catch((e) => console.log(e));
}
}
|
Sample link:
https://stackblitz.com/edit/react-yu8m9t-ebmcos?file=index.js
Kindly, check the
above details and get back to us for further clarifications.
