Excel has both cell "Notes" and cell "Comments". Libre Calc only has "Comments" which in and of itself is an issue. As soon as I open an Excel sheet containing Excel cell Notes, Libre reformats the Note's text in both the font type and font size to that of the Libre Calc Comment presets. Please add cell Notes to Calc and prevent Calc from automatically changing formatting of cell Notes or Comments. Thanks!!
What we have as "Comments" in Calc is the same that Excel had as "Comments" in the past as well. Apparently, Excel renamed its former "comments" to "notes", and added a new threaded comment feature. See: https://support.microsoft.com/en-us/office/the-difference-between-threaded-comments-and-notes-75a51eec-4092-42ab-abf8-7669077b7be3 So apparently Calc's "Comments" == Excel's "Notes", so this is not an actual bug. Maybe the underlying issue is the lack of threaded comments in Calc.
(In reply to Rafael Lima from comment #1) > Maybe the underlying issue is the lack of threaded comments in Calc. The naming change in Excel from "Comments" to "Notes" started in Excel 365 (or "for the web"). Instead of having classic comments and new threaded comments, MS renamed the old Comments to Notes and the new threaded comments to simply Comments. There is also the Track Changes features, which in some context are mixed up with Comments/Notes, for example, in discussions about Author and Date information, and/or when trying to unify behaviors between Calc and Writer. This mix up has been a source of confusion and multiple problems for users, so I am mentioning it here for clarity. Indeed, ATM Calc does not really support threaded comments (AKA as "Comments" in newer versions of Excel). Probably this should be an enhancement request rather than a bug report.
I appreciate your observations and added background info. My take on this is that it a combination bug and enhancement issue. The bug aspect is that, with Excel having threaded comments AND Notes, the Libre comments need to affect Excel comments, not their Notes. The enhancement aspect is that we need both Comments and Notes in Libre Calc to allow for both reading and editing their Excel counterparts. Whether one can be addressed without the other would seem doubtful.
Which versions of LO and Excel have you been using to test this, Kevin?
Dear Kevin, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Dear Kevin, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp