← Back to team overview

desktop-packages team mailing list archive

[Bug 480130] Re: [upstream] Calc truncates data from HTML based .xls

 

It's already been marked as "also effects". I just retested with and it
still stops all data at about row 6700.

1) lsb_release -rd
Description:	Ubuntu 11.04
Release:	11.04

2) apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.3.3-1ubuntu2
  Candidate: 1:3.3.3-1ubuntu2
  Version table:
 *** 1:3.3.3-1ubuntu2 0
        500 http://us.archive.ubuntu.com/ubuntu/ natty-updates/main i386 Packages
        100 /var/lib/dpkg/status
     1:3.3.2-1ubuntu4 0
        500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages

I have some free time this weekend and just realized LibreOffice has
some easy documentation on getting started hacking at this issue. Let's
see if I can fix it myself.

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/480130

Title:
  [upstream] Calc truncates data from HTML based .xls

Status in LibreOffice Productivity Suite:
  Confirmed
Status in The OpenOffice.org Suite:
  Confirmed
Status in “libreoffice” package in Ubuntu:
  Triaged
Status in “openoffice.org” package in Ubuntu:
  Won't Fix

Bug description:
  Binary package hint: openoffice.org

  1) lsb_release -rd
  Description:	Ubuntu 11.04
  Release:	11.04

  2) apt-cache policy libreoffice-calc
  libreoffice-calc:
    Installed: 1:3.3.2-1ubuntu5
    Candidate: 1:3.3.2-1ubuntu5
    Version table:
   *** 1:3.3.2-1ubuntu5 0
          500 http://us.archive.ubuntu.com/ubuntu/ natty-updates/main i386 Packages
          100 /var/lib/dpkg/status
       1:3.3.2-1ubuntu4 0
          500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages

  3) What is expected to happen in LibreOffice Calc via the Terminal:

  cd ~/Desktop && wget
  https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/480130/+attachment/1019499/+files/OE_Enrollment_Audit_20091110114007-C55555.2.xls
  && localc -nologo OE_Enrollment_Audit_20091110114007-C55555.2.xls

  is the file displays all 12384 rows.

  4) What happens instead is it only displays data for the first 6700
  rows. It shows border formatting for rows 6701 to 12384, but no data.

  WORKAROUND: Use Gnumeric.

  apt-cache policy gnumeric
  gnumeric:
    Installed: 1.10.13-1ubuntu1
    Candidate: 1.10.13-1ubuntu1
    Version table:
   *** 1.10.13-1ubuntu1 0
          500 http://us.archive.ubuntu.com/ubuntu/ natty/universe i386 Packages
          100 /var/lib/dpkg/status

  WORKAROUND: Excel 2003 via WINE.

  Microsoft Office Excel 2003 (11.5612.6505)

  apt-cache policy wine1.3
  wine1.3:
    Installed: 1.3.19-0ubuntu1~maverick1~ppa1
    Candidate: 1.3.19-0ubuntu1~maverick1~ppa1
    Version table:
   *** 1.3.19-0ubuntu1~maverick1~ppa1 0
          100 /var/lib/dpkg/status
       1.3.15-0ubuntu5 0
          500 http://us.archive.ubuntu.com/ubuntu/ natty/universe i386 Packages

  Original Report Comments: I have a Web App that generates HTML based
  spreadsheets with very simple tables, amount displayed varies with
  length of cell contents.

  ProblemType: Bug
  Architecture: i386
  Date: Tue Nov 10 11:42:07 2009
  DistroRelease: Ubuntu 9.10
  InstallationMedia: Ubuntu 9.10 "Karmic Koala" - Release i386 (20091028.5)
  Package: openoffice.org-core 1:3.1.1-5ubuntu1
  ProcEnviron:
   PATH=(custom, no user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  ProcVersionSignature: Ubuntu 2.6.31-14.48-generic
  SourcePackage: openoffice.org
  Uname: Linux 2.6.31-14-generic i686

To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/480130/+subscriptions