Hi John, john silver schrieb am 23.05.2022 um 14:09:
I'm trying to fill a matrix based on the coordinates of each cell. In the formula cell I got"=CONCATENATE("RS-";TEXT(COLUMN();"##");TEXT(ROW()+;"##"))"
That looks wrong. The formula cell must not use anything from the final two-dimensional result area, but is the result cell of a separate template calculation.
Please look at the examples in https://wiki.documentfoundation.org/Documentation/Calc_Functions/MULTIPLE.OPERATIONS
Kind regards, Regina --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org