Missing libspreadsheet-parsexlsx-perl package

Bug #1833679 reported by AlainKnaff
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
rtl8812au (Ubuntu)
New
Undecided
Unassigned

Bug Description

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 &

Tags: bionic
tags: added: bionic
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.