Windward Core is now Fluent by Apryse. Click here to experience the new and improved platform!
< Back to Features

Excel References are Adjusted as Expected in the Generated Worksheet

All Products
.NET Engine
RESTful Engine
Java Engine

Any references (A1:D6) are adjusted in the generated XLSX output to now be the new range based on the inserted data. This includes the case of a range inside a forEach loop, where the range will be adjusted for each set in each iteration of the forEach.

What does this mean? Say you have =SUM(C4:C4) in a cell. And when you generate the template the row 4 has become the rows 4 ... 15 when the data is inserted. Then that cell will now have =SUM(C4:C15). This is important because if you then change the value in cell C7, the SUM() will adjust to match this change. In short, this give you live worksheets.

Apryse Software Corp. © 2024 All Rights Reserved.