What is this syntax C1:=B1

On this LibreOffice Help page, the first formula shows, C1:=B1. What does the C1: mean?

Is there anyway to search in just a specific LibreOffice module, like Calc, in the LibreOffice online help. Any search I do seems to include all modules (writer, calc, impress,…).

That is not a “formula”, it is a sub-optimal wording, meaning "in C1, the formula is =B1". It would of course be nice to improve, to avoid confusion like this. Pinging @ohallot, in case he has an idea how to improve it (any ideas are welcome). One possibility is to move the “C1” into the heading of the table column, to become “Formula in C1”, instead of current “Formula”. But it seems, that the formulas there are not only what is in C1, but also in different places - e.g., =C1=0 should appear elsewhere…

1 Like