Bug 107728 - FILESAVE: xlsx files always exported with comments shown
Summary: FILESAVE: xlsx files always exported with comments shown
Status: CLOSED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.8.2 release
Hardware: Other Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: regression
Depends on: 76406
Blocks:
  Show dependency treegraph
 
Reported: 2017-05-09 14:58 UTC by Magnus Jacobsson
Modified: 2020-04-06 07:45 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


Attachments
Sample document (5.80 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-05-18 13:42 UTC, Magnus Jacobsson
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Magnus Jacobsson 2017-05-09 14:58:23 UTC
+++ This bug was initially created as a clone of Bug #76406 +++

The problem is back in: Version: 4.2.8.2, Build ID: 420m0(Build:2), Ubuntu 14.04.5 LTS

Problem description: xlsx documents with comments always have comments showing. This is identical to bug 46278; however this bug is marked solved.

Steps to reproduce:
1. Save document with comments as xlsx in Libreoffice or Excel
2. Open document in Libreoffice.

Current behavior: All comment will be shown.

Expected behavior: Comments should be only show when you roll the mouse over the cell with the comment. Since there is no easy way to hide all comments, this makes certain spreadsheets very difficult to read.

              
Operating System: Windows 7
Version: 4.2.0.4 release
Comment 1 Buovjaga 2017-05-12 17:29:11 UTC
Is the problem in version 5.3.3?
Comment 2 Bartosz 2017-05-17 22:14:22 UTC
Could you please attach some sample document?
Comment 3 Magnus Jacobsson 2017-05-18 13:42:24 UTC
Created attachment 133388 [details]
Sample document
Comment 4 Buovjaga 2017-05-18 15:11:14 UTC
(In reply to Magnus Jacobsson from comment #3)
> Created attachment 133388 [details]
> Sample document

If I hide the comment, save and reload, it stays hidden. Closing.

Arch Linux 64-bit, KDE Plasma 5
Version: 5.3.2.2
Build ID: 5.3.2-3
CPU Threads: 8; OS Version: Linux 4.10; UI Render: default; VCL: kde4; Layout Engine: new; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Comment 5 Magnus Jacobsson 2017-05-18 15:17:56 UTC
If I hide the comment, save and reload, it does not stay hidden. Reopening.

Libreoffice Version: 4.2.8.2 Build ID: 420m0(Build:2)
 
> lsb_release -a
No LSB modules are available.
Distributor ID:	Ubuntu
Description:	Ubuntu 14.04.5 LTS
Release:	14.04
Codename:	trusty
Comment 6 Buovjaga 2017-05-18 15:24:20 UTC
Focus on the version: 4.2 is beyond obsolete. Test with 5.3. Closing.
Comment 7 Magnus Jacobsson 2017-05-18 15:30:49 UTC
(In reply to Buovjaga from comment #6)
> Focus on the version: 4.2 is beyond obsolete. Test with 5.3. Closing.

It's not available on Ubuntu 14.04.5 LTS:

> sudo apt-get install libreoffice
Reading package lists... Done
Building dependency tree       
Reading state information... Done
libreoffice is already the newest version.
The following packages were automatically installed and are no longer required:
  ant ant-optional gcc-4.8-base:i386 gyp libandroid-json-org-java
  libargs4j-java libatinject-jsr330-api-java libc-ares-dev libc-ares2
  libclang-common-3.8-dev libclang1-3.8 libclosure-compiler-java libguava-java
  libjs-node-uuid libjsr305-java libllvm3.8v4 libv8-3.14-dev libv8-3.14.5
  libxerces2-java libxml-commons-external-java libxml-commons-resolver1.1-java
  linux-headers-3.13.0-39 linux-headers-3.13.0-39-generic
  linux-image-3.13.0-39-generic linux-image-extra-3.13.0-39-generic llvm
  llvm-3.8 llvm-3.8-dev llvm-3.8-runtime llvm-runtime
Use 'apt-get autoremove' to remove them.
0 upgraded, 0 newly installed, 0 to remove and 275 not upgraded.
> libreoffice --version
LibreOffice 4.2.8.2 420m0(Build:2)
Comment 8 Buovjaga 2017-05-18 15:46:36 UTC
(In reply to Magnus Jacobsson from comment #7)
> (In reply to Buovjaga from comment #6)
> > Focus on the version: 4.2 is beyond obsolete. Test with 5.3. Closing.
> 
> It's not available on Ubuntu 14.04.5 LTS:

I know. Either switch to newer Ubuntu or use this ppa https://launchpad.net/~libreoffice/+archive/ubuntu/ppa
Comment 9 Thanos 2018-06-26 05:53:29 UTC Comment hidden (spam)
Comment 10 Jose 2019-04-22 12:23:42 UTC Comment hidden (spam)
Comment 11 warisali 2019-12-29 12:20:09 UTC Comment hidden (spam)
Comment 12 PinoySwertres 2020-01-27 05:31:52 UTC Comment hidden (spam)
Comment 13 stephenkrick 2020-04-05 22:55:23 UTC Comment hidden (spam)