Ask Your Question
0

In LO Calc can apply a reference formula to a text box on another sheet?

asked 2021-02-24 23:41:20 +0200

RWBguy gravatar image

I'm organizing text boxes on sheet of Calc and want to populate the text boxes with data from cells of another sheet within the same file (book). Is this possible? If so how can it be done.

I have a document that I use from Excel that I now want to work in Calc.

Thanks for your help!

edit retag flag offensive close merge delete

Comments

In LO Calc can apply a reference formula to a text box on another sheet?

No, you can't (neglecting user code).

Opaque gravatar imageOpaque ( 2021-02-25 10:44:10 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2021-02-25 15:20:28 +0200

erAck gravatar image

Sort of. Not with a text box, but if you use a form control list box (without connecting to a database) then in its context menu Control Properties tab Data you can enter a cell range (one column) reference in Source cell range, of which the contents or formula results are displayed. See also https://help.libreoffice.org/latest/e...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2021-02-24 23:41:20 +0200

Seen: 21 times

Last updated: Feb 25