Bug 155127 - FILEOPEN: Notes created in Office 2003 are not visible in XLS
Summary: FILEOPEN: Notes created in Office 2003 are not visible in XLS
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xls
Depends on:
Blocks: Calc-Comments
  Show dependency treegraph
 
Reported: 2023-05-02 11:55 UTC by ebsoft
Modified: 2024-02-28 13:56 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Planilla present error (38.00 KB, application/vnd.ms-excel)
2023-05-02 11:58 UTC, ebsoft
Details

Note You need to log in before you can comment on or make changes to this bug.
Description ebsoft 2023-05-02 11:55:55 UTC
Description:
Los comentarios en las celdas creadas con Office 2003 que contienen macros no se transmiten a las versiones de LibreOffice.-

Steps to Reproduce:
1. Create new file calc in office 2003
2. Comentary any celd and put one formule
3. Save and open with LibreOfficeCalc

Actual Results:
The comentary not appears

Expected Results:
The celd comentary view


Reproducible: Always


User Profile Reset: No

Additional Info:
[Information automatically included from LibreOffice]
Locale: es
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Comment 1 ebsoft 2023-05-02 11:58:49 UTC
Created attachment 187060 [details]
Planilla present error

If open with libreoffice calc, the comment cells not view
Comment 2 m_a_riosv 2023-05-02 14:01:55 UTC
Testing with excel, it allows notes, what are saved an open fine with LibreOffice.

With
Microsoft® Excel® para Microsoft 365 MSO (versión 2304 compilación 16.0.16327.20200) de 64 bits, there are two options, one to add comments and one to add notes.
But now allowed saving the comments in xls format.
Comment 3 Stéphane Guillou (stragu) 2023-05-04 15:40:16 UTC
Already missing in OOo 3.3.

Also reproduced in recent master build:

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 83b1f6b58a30bdb589e9ce73deef39f021aebde1
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

OnlyOffice does show them, using:

ONLYOFFICE Desktop Editors version 7.3.3.50 (flatpak)

If saved to XLSX from OnlyOffice, comments can then be seen in LO.

ebsoft, how exactly did you add the comments/notes in Excel?