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]
[Solved] Comment size changes
-
- Posts: 116
- Joined: Wed Sep 30, 2015 10:03 pm
- Location: Houston, TX area
[Solved] Comment size changes
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
Reason: Tagged ✓ [Solved] Saved comment in Writer document
Open Office 4.1.3 Win 10
Re: Comment size changes
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.
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.
Re: Comment size changes
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
-
- Posts: 116
- Joined: Wed Sep 30, 2015 10:03 pm
- Location: Houston, TX area
Re: Comment size changes
Do you want the whole file (almost 120,000 rows)?
Can't U/L a screen shot.
Can't U/L a screen shot.
Open Office 4.1.3 Win 10
Re: Comment size changes
Prepare a small sample file (without sensitive data).Do you want the whole file (almost 120,000 rows)?
The file size limit is 128 KiB in this forum.Can't U/L a screen shot.
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.
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.
-
- Posts: 116
- Joined: Wed Sep 30, 2015 10:03 pm
- Location: Houston, TX area
Re: Comment size changes
Thanks anyway,
I have saved comment to Writer file.
⌡im [THE BookMan]
I have saved comment to Writer file.
⌡im [THE BookMan]
Open Office 4.1.3 Win 10