Calc - Populate blank cells on F9 (refresh)

classic Classic list List threaded Threaded
1 message Options
Steve T Steve T
Reply | Threaded
Open this post in threaded view
|

Calc - Populate blank cells on F9 (refresh)

LibreOffice 6.2.8.2 - Fedora 30

Good afternoon,
I have a simple spreadsheet with 3 sheets.
The first sheet contains a simple list of three columns or so.
The 2nd sheet has a cell that uses a random number for the row list on
the first sheet, and then a couple of other columns that show the
sheet1 data related to the randomised row.

That works fine.

What I'd now like to do is to create a third sheet that keeps track of
which rows have been selected by having something like:
=IF($A1="",$Sheet2.$A$1,"")

...ie if that cell is blank, populate it with the random row number -
if it isn't blank, then leave it as it is. I was then going to copy
that formula down the column - my expectation being that each time I
pressed F9, the $Sheet3.$A... cell would be populated with the last
generated random number. The problem is that what I thought was simple
code creates a 523 error.

The error appears to be some form of iterative issue, but I'm not
certain I see what the problem is or how to fix it.

Any guidance welcome.

Steve T


--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy