Closed DutchPete closed 4 months ago
Of course, you can. The rules are as follows:
Thanks for your help. Yes, that works ... partly. I cannot get the bit behind the pipe (D8:G14 etc. in your example) to work. So, what I get is this:
I tried it with this: A1:E4 but nothing changes. I tried 1-A:4-E, but no change either. Also, I don't know what "sheet height" means — you use 1000 in your example, is that 1000 rows or what units?
The format might be incorrect. After selecting the area you want to reference, there is a button in the top right corner that can quickly generate the link.
Height refers to the window height displayed in the note. Try it out to understand better.
The embed button works fine, it is much easier to use that than to try to the syntax.
As for the window height, I don't see any effect: I went from 300 to 10,000 (no comma) in steps but nothing changes.
After making changes, you need to reopen the file to see the effects.
Brilliant, works fine, many thanks. Last question: is there a way to not show the column letters, row numbers, and the grey strip at the bottom? Should I make a separate feature request for it?
You can submit a feature request.
OK, done #22 .
There is a rule for sheet height: is there one for sheet width too? See white area to the right of column C
If so, what is it? If not, I shall submit a feature request.
Would be possible to embed a sheet in a note, just like one can embed a note or PDF in another note?