[Solved] Comment size changes

Discuss the spreadsheet application
Locked
THEBookMan
Posts: 116
Joined: Wed Sep 30, 2015 10:03 pm
Location: Houston, TX area

[Solved] Comment size changes

Post 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]
Last edited by MrProgrammer on Wed May 07, 2025 9:40 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved] Saved comment in Writer document
Open Office 4.1.3 Win 10
User avatar
Zizi64
Volunteer
Posts: 11477
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Comment size changes

Post by Zizi64 »

Please upload an ODF type sample file here.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
RoryOF
Moderator
Posts: 35059
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Comment size changes

Post 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. 
Apache OpenOffice 4.1.15 on Xubuntu 22.04.5 LTS
THEBookMan
Posts: 116
Joined: Wed Sep 30, 2015 10:03 pm
Location: Houston, TX area

Re: Comment size changes

Post by THEBookMan »

Do you want the whole file (almost 120,000 rows)?

Can't U/L a screen shot.
Open Office 4.1.3 Win 10
User avatar
Zizi64
Volunteer
Posts: 11477
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Comment size changes

Post 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.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
THEBookMan
Posts: 116
Joined: Wed Sep 30, 2015 10:03 pm
Location: Houston, TX area

Re: Comment size changes

Post by THEBookMan »

Thanks anyway,
I have saved comment to Writer file.

⌡im [THE BookMan]
Open Office 4.1.3 Win 10
Locked