Public bug reported:
libspreadsheet-read-perl (perl package Spreadsheet::Read) needs
Spreadsheet::ParseXLSX to work correctly. However, by default Ubuntu
includes Spreadsheet::XLSX (libspreadsheet-xlsx-perl) instead, which
munges date cells, and text cells that contain HTML escapable
characters.
The correct perl package Spreadsheet::ParseXLSX (which would be called
libspreadsheet-parsexlsx-perl package) is not even available in the apt
repositories, and currently needs to be installed manually using CPAN.
Please include this package, and make libspreadsheet-read-perl depend on
it, rather than on the broken libspreadsheet-xlsx-perl
$ lsb_release -rd
Description: Ubuntu 18.04.2 LTS
Release: 18.04
$ apt-cache policy libspreadsheet-read-perl
libspreadsheet-read-perl:
Installed: 0.78-1
Candidate: 0.78-1
Version table:
*** 0.78-1 500
500 http://be.archive.ubuntu.com/ubuntu bionic/universe amd64 Packages
500 http://be.archive.ubuntu.com/ubuntu bionic/universe i386 Packages
100 /var/lib/dpkg/status
$ apt-cache policy libspreadsheet-xlsx-perl
libspreadsheet-xlsx-perl:
Installed: 0.15-1
Candidate: 0.15-1
Version table:
*** 0.15-1 500
500 http://be.archive.ubuntu.com/ubuntu bionic/universe amd64 Packages
500 http://be.archive.ubuntu.com/ubuntu bionic/universe i386 Packages
100 /var/lib/dpkg/status
$ apt-cache policy libspreadsheet-parsexlsx-perl
N: Unable to locate package libspreadsheet-parsexlsx-perl
What I expect to happen:
When using Spreadsheet::Read, cells containing dates should be formatted as
text (2019-06-21) rather than as integer (number of days since January 1900).
Cells containing text, containing special characters such as "&" should render
this as is
What happened instead
Date cells are formatted as days since January 1900 (example: 43636) and & are
escapes as &
** Affects: rtl8812au (Ubuntu)
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1833679
Title:
Missing libspreadsheet-parsexlsx-perl package
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/rtl8812au/+bug/1833679/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
