Bug 106609 - Inserting a note or a comment, after sharing an .ODS file, greyed out...
Summary: Inserting a note or a comment, after sharing an .ODS file, greyed out...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Keywords: needsDevAdvice
Depends on:
Blocks: Calc-Comments
  Show dependency treegraph
Reported: 2017-03-17 23:46 UTC by João Paulo Martins
Modified: 2024-02-29 14:11 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description João Paulo Martins 2017-03-17 23:46:09 UTC

This is my first bug report. I sure hope this is a real bug rather than a feature I can't really understand.

Ok, I'm used to be able to comment or taking notes on shared Excel worksheets (or even on Google Docs), but on LibreOffice the only way I can take notes or comment anything is when an .ODS or .ODT files aren't shared. Once I share them, The field "Insert comment" becomes greyed out. How can I overcome this? I want to be able to do the same as I used do do, at least, in Google Docs.

Thank you for your time and effort,
João Paulo Martins
Comment 1 Buovjaga 2017-03-23 12:32:07 UTC Comment hidden (obsolete)
Comment 2 João Paulo Martins 2017-03-23 22:48:46 UTC
How do you share a document in LibreOffice in any OS? By selecting share document of course :D and then saving it. But I'm using Windows 10 Pro on my workstations and Windows Server 2012 R2 on my server. It happens with Linux Mint 18 also.
Comment 3 Buovjaga 2017-03-24 07:19:36 UTC
(In reply to João Paulo Martins from comment #2)
> How do you share a document in LibreOffice in any OS? By selecting share
> document of course :D and then saving it.

Where do I do this selection? Please include exact steps so we don't have to guess.
Comment 4 João Paulo Martins 2017-03-24 12:32:20 UTC
You guys make a software from scratch and don't know their features?? :D
"Tools", "Share Worksheet", select "Share this document" and once it is shared you can't comment it again unless you unshare it. That doesn't make any sense.
Comment 5 Aron Budea 2017-03-24 22:32:39 UTC
(In reply to João Paulo Martins from comment #4)
> You guys make a software from scratch and don't know their features?? :D

Most of the team are volunteers with various amount of experience with LibreOffice, you can't expect people to know all the details with such a complex software. And no, we don't make the software from scratch, not only because QA doesn't write software, but also because the history of this software started more than 30 years ago.
Comment 6 Buovjaga 2017-03-26 16:57:55 UTC
Ok, I noticed Raal had reported this to OOo in 2010.
Comment 7 João Paulo Martins 2017-03-28 09:58:27 UTC Comment hidden (no-value)
Comment 8 Buovjaga 2017-03-28 11:17:42 UTC Comment hidden (obsolete)
Comment 9 João Paulo Martins 2017-03-28 22:29:45 UTC Comment hidden (obsolete)
Comment 10 Aron Budea 2017-03-28 22:54:10 UTC Comment hidden (obsolete)
Comment 11 Buovjaga 2017-03-29 07:45:00 UTC
(In reply to João Paulo Martins from comment #9)
> "Nice" answer. Basically what you're saying is that there are some bugs that
> are left behind/unattended, on purpose?? When I mean "now", I mean in the
> next release. Not like, right now!

No, that's an outrageous conspiratorial claim you are imagining.

Right now or next release are nearly identical wishes, when the reality is we have 9-10 thousand bugs.

Your options for getting a bug fix or a feature implemented are:

1. Do it yourself
2. If you can't do it, pay for it
3. If you don't have money, ask a friend to do it
4. If you don't have a C++-savvy friend, learn C++ first and then do it yourself
5. If you are disgusted about the idea of learning C++, contribute to LibreOffice in some other ways, make new friends in the process and hope you can some day convince them to fix your pet bug, probably in exchange of some work or beers
Comment 12 QA Administrators 2018-03-30 02:33:40 UTC Comment hidden (obsolete)
Comment 13 funnyjokes 2018-05-17 04:17:24 UTC Comment hidden (spam)
Comment 14 Stellamaxwell 2018-08-25 04:58:22 UTC Comment hidden (spam)
Comment 15 Clara Byrne 2019-12-31 05:37:13 UTC Comment hidden (spam)
Comment 16 Ruth True 2020-08-13 07:02:56 UTC Comment hidden (spam)
Comment 17 Ruth True 2020-08-13 07:03:25 UTC Comment hidden (spam)
Comment 18 Max Julia Anderson 2020-11-06 16:58:20 UTC Comment hidden (spam)
Comment 19 Max Julia Anderson 2020-11-06 16:59:43 UTC Comment hidden (spam)
Comment 20 Amelia Symond 2021-01-27 05:56:57 UTC Comment hidden (spam)
Comment 21 Johns Mak 2021-02-14 15:08:09 UTC Comment hidden (spam)
Comment 22 emmajohan 2021-10-14 12:38:02 UTC Comment hidden (spam)
Comment 23 coreanderson 2021-11-10 11:40:24 UTC Comment hidden (spam)
Comment 24 livecoupons 2021-11-26 07:16:13 UTC Comment hidden (spam)
Comment 25 Ilsayston 2022-10-18 08:16:15 UTC Comment hidden (spam)
Comment 26 avajames 2023-02-21 13:20:43 UTC Comment hidden (spam)
Comment 27 Arun Ganta 2023-07-20 04:39:14 UTC Comment hidden (spam)
Comment 28 chitrasingh122 2023-07-21 12:38:15 UTC Comment hidden (spam)
Comment 29 Jessica Jones 2023-07-24 11:09:56 UTC Comment hidden (spam)
Comment 30 Jessica Jones 2023-07-24 11:12:10 UTC Comment hidden (spam)
Comment 31 Stéphane Guillou (stragu) 2023-07-24 11:51:38 UTC
It looks like currently, the sharing feature is only available for Calc: https://help.libreoffice.org/7.5/en-US/text/shared/guide/collab.html
... so I'm removing "ODT" from the summary.

Many commands are unavailable when sharing a spreadsheet, and there is a message in the dialog that spells this out (although it does not list Comments as an unavailable feature). Is it realistic to have a report open for each one of those? I don't know what the technical limitation is that means some features are available and others not.

I'm wondering if this should be either:

a. closed as a duplicate of the proper offline collaboration feature requested in 133984; or
b. made more general and ask to have all features available when sharing a spreadsheet; or
c. turned into a documentation / UI issue to clarify that comments can't be added in a shared file.

(c) is obviously way easier to resolve than the two others.
Comment 32 Reddysaab209 2023-08-08 17:10:54 UTC Comment hidden (spam)
Comment 33 kellyjames7957 2023-09-19 12:52:27 UTC Comment hidden (spam)
Comment 34 Rachel lara 2023-10-09 11:38:16 UTC Comment hidden (spam)
Comment 35 Maja James 2023-11-23 22:22:07 UTC Comment hidden (spam)
Comment 36 patiopavings 2024-01-13 07:30:08 UTC Comment hidden (spam)
Comment 37 Sofia Smith 2024-02-19 21:04:35 UTC Comment hidden (spam)
Comment 38 Rosaliarose 2024-02-29 14:11:50 UTC Comment hidden (spam)