I have an excel file where I want to use a variable to generate a sequence of a certain length, cocatenate the full sequence in a string and give the output back to the user.
Unfortunately the sequence function does not work properly with Aspose.cells as soon as a variable is used to indicate its length.
=SEQUENCE(5) work fine.
but if you try =SEQUENCE(B2) (where B2 is the cell with a user specified value), the result is only the first entry of the sequence, regardless of the value for length.
I attached a sample excel file to demonstrate the problem.
Can you have a look at this issue?
sequencetest.zip (10.8 KB)