Page 1 of 1

[Solved] Comment size changes

Posted: Tue Apr 22, 2025 9:55 pm
by THEBookMan
I have a comment that is causing me a head ache.
The comment is about a full page of text.
Saved as a comment on the first cell of my CALC spreadsheet.
Initially is saved just as it should.
BUT ....
When I re-open the spreadsheet, the comment is now about 12-12 characters wide and 100 cells long!

Is there a way to preserve the initial length and width ?

Thanks for all you do,

⌡im [THE BookMan]

Re: Comment size changes

Posted: Wed Apr 23, 2025 7:04 am
by Zizi64
Please upload an ODF type sample file here.

Re: Comment size changes

Posted: Wed Apr 23, 2025 9:35 am
by RoryOF
I can't answer for Calc comments, as I don't use them, but in case it is useful for others searching, I note that in Writer Comments (Annotations) have an inbuilt limit of about 16,000 characters - surprisingly, not 16,384 [programmers will realise why that is surprising], but a comment of such size becomes effectively unmanageable and unviewable.
.
 Edit:  That approx 16,000 char limit was found by experiment. 

Re: Comment size changes

Posted: Wed Apr 23, 2025 5:54 pm
by THEBookMan
Do you want the whole file (almost 120,000 rows)?

Can't U/L a screen shot.

Re: Comment size changes

Posted: Wed Apr 23, 2025 7:31 pm
by Zizi64
Do you want the whole file (almost 120,000 rows)?
Prepare a small sample file (without sensitive data).
Can't U/L a screen shot.
The file size limit is 128 KiB in this forum.

Re: Comment size changes

Posted: Wed Apr 23, 2025 10:28 pm
by THEBookMan
Thanks anyway,
I have saved comment to Writer file.

⌡im [THE BookMan]