Description: We are using a recursive formula to turn the data from a column into a line separated by ; It fails, and it miscalculates the result. In the intermediate steps it reset the calculations, and it never gives all the data. Steps to Reproduce: A is the column where we have the data B is the column we use to iterate A and the last line has the result B1 is A1 B2 is =B1&";"&A2 B2 is =B2&";"&A3 etc Actual Results: The Bn is reseted to ;An . I don't understand the patron that n follows in this error. At the end, only part of data from A is on the last B Expected Results: we expect the last Bn contains all the items from A separated by ; Reproducible: Always User Profile Reset: No Additional Info: It also happens on 6.3.0.4 version on Windows.
Created attachment 158307 [details] File with error sample
There are hidden rows in your sample file, for example row 14. And the B column for the hidden row is empty, therefore breaking up your recursive formula. Adding formulas to the hidden rows gives the correct result for me, even if they are hidden again after adding the formulas. User mistake, setting to NOTABUG. Feel free to change it back to UNCONFIRMED if you disagree, with a brief explanation.
I didn't notice that. Thank you, Ming Hua, for you quick response.