Apache OpenOffice Community Forum

@MrProgrammer
Regarding your tutorial Calc formula terms: one typo and one question.

1.

If the sheet name is preceeded by a $ it denotes a specific sheet intead of a relative sheet

"intead"
⠀
2.
According to the Tutorial, OpenOffice Calc formulas can contain i.a.

• A defined name (created with Insert → Names → Define)

Would it make sense to also mention a database range name (created via Data → Define Range)?

cwolan wrote: ↑Thu Jun 20, 2024 6:37 pm If the sheet name is preceeded by a $ it denotes a specific sheet intead of a relative sheet

I fixed both preceeded and intead.

cwolan wrote: ↑Thu Jun 20, 2024 6:37 pm Would it make sense to also mention a database range name (created via Data → Define Range)?

Yes. I forgot about that case. I've only used a defined range name as a formula term a few times, attempting to make formulas independent of the number of rows in the database range in case that changes during a refresh. I discovered that one can use the same name in both Insert → Names → Define and Data → Define Range, but when that happens the former is used for the name's value. I'd be surprised if there is any documentation about this.