Inserting values into existing cells

[gizwhu]

Hi Jason,

I have an Excel document containing forms. I am required to populate the first worksheet with data and the other worksheets would have values taking reference from the first worksheet.

I am taking reference from the following sample code:

https://github.com/plutext/docx4j/blob/master/src/samples/xlsx4j/org/xlsx4j/samples/VariableReplace.java

and

http://www.docx4java.org/forums/xlsx-java-f15/replace-variables-in-xlsx-t2080.html

I managed to write the value to the first worksheet. However these values are not reflected in the other worksheets. It is only updated if i click the cell.

Any advice is greatly appreciated.