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,…).
For the following examples, A1 contains a number, B1 is empty, C1 contains the reference to B1:
I normally use the community PDF documents because I was having problems finding items that pertain specifically to a module, like Calc or Writer. I’ll have to pay more attention in the future.
One thing I noticed, it would be helpful if the left menu positioned on the selected search result.
If I select Module > Calc. The menu on the left positions into Calc Help. If I then search for char in the top text box and select char in the drop-down list, the menu on the left reverts back to the default main menu. I thought the left menu might position on char in the Calc Help. This way a user could see documentation before and after char or what section char falls under in the Calc Help,
Ah…that is where the 25.8 doc has been hiding 
Thank you!
The bookshelf url that I found is https://books.libreoffice.org, which is different than the meeting minutes but matches the git source.
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…
Maybe cell contents (or cell references) must get a distinct style. That implies a lot of work to adapt the help pages.
Ahhh, thought I was look’n at some pascal assignment statement there for a moment
Handling of Empty Cells is an important topic.
I found the page when looking for options to the question, “what does it mean when a cell looks like it contains nothing?” If I know a cell should have a value, I explicitly check for the value. It was the empty cell that was causing issues, in particular if the cell’s value was based on a formula in the cell. I’m looking at len(trim()) rather than isblank().
Regarding the online help table, I got different results for istext() and isblank().
I’m assuming B1 is empty and C1 is a reference to B1.
=ISTEXT(B1) FALSE # same
=ISTEXT(C1) TRUE # I get FALSE
=ISBLANK(B1) TRUE # same
=ISBLANK(C1) TRUE # I get FALSEEnvironment:
Version: 25.8.3.2 (X86_64) / LibreOffice Community
Build ID: 580(Build:2)
CPU threads: 2; OS: Linux 6.6; UI render: default; VCL: gtk3
Locale: en-US (en_US.utf8); UI: en-US
25.8.3-3
Calc: threaded