Calc default zoom on file is 20% instead of expected 100%

[Martin Palenik]

1) lsb_release -rd
Description: Ubuntu quantal (development branch)
Release: 12.10

2) apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.6.1~rc2-1ubuntu5
  Candidate: 1:3.6.1~rc2-1ubuntu5
  Version table:
 *** 1:3.6.1~rc2-1ubuntu5 0
        500 http://archive.ubuntu.com/ubuntu/ quantal/main i386 Packages

3) What is expected to happen in Calc via a terminal:
cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1030250/+attachment/3239603/+files/fd.xls && localc --nologo fd.xls

is the default zoom is 100%.

4) What happens instead is it is 20% as per screenshot https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1030250/+attachment/3239599/+files/Screenshot%20from%202012-07-28%2011%3A05%3A43.png .

Note this problem does not exist in Microsoft Office Professional Plus 2010 Excel Version 14.0.6023.1000 (32-bit) or Calligra Sheets.

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

WORKAROUND: Change zoom to 100%.

Description: Ubuntu 12.04 LTS
Release: 12.04
The version of Libreoffice is "LibreOffice 3.6.0 RC2 (2012-07-20)" but the same problem is with the default Ubuntu versions from reposiory
1:3.5.4-0ubuntu1 0
500 http://sk.archive.ubuntu.com/ubuntu/ precise-updates/main amd64 Packages
1:3.5.2-2ubuntu1 0
500 http://sk.archive.ubuntu.com/ubuntu/ precise/main amd64 Packages

Note I am running 64bit version.

[Martin Palenik (slovenskyweb)]

Obviously, I forgot to add the file that causes problem. I have attached it now.

[Dave Gilbert (ubuntu-treblig)]

Confirmed for me on libreoffice 3.6.0~rc2-0ubuntu3 on Quantal.
There seem to be multiple problems; all the rows/columns are 0 size, but even if you drag these open it doesn't render.

The file does render OK in calligra.

[penalvch (penalvch)]

Martin Palenik, thank you for reporting this and helping make Ubuntu better. All that was required was to change the zoom from the default 20%, which produces the attached screenshot, to 100%, and it looks as it does in Excel 2010.

Does this work for you?

lsb_release -rd
Description: Ubuntu quantal (development branch)
Release: 12.10

apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.6.1~rc2-1ubuntu5
  Candidate: 1:3.6.1~rc2-1ubuntu5
  Version table:
 *** 1:3.6.1~rc2-1ubuntu5 0
        500 http://archive.ubuntu.com/ubuntu/ quantal/main i386 Packages

[Dave Gilbert (ubuntu-treblig)]

Hi Christopher,
  (Triager/Not the original reporter)
  I agree that setting the zoom does fix it - good spot, so it does seem to be a choice of default zoom that seems to be the problem.
However, calligra seems to make a more sane guess at the default zoom, and it's visible on opening, so I think it's still a valid bug.

[penalvch (penalvch)]

Martin Palenik, thank you for taking the time to report this bug and helping to make Ubuntu better. The issue you are reporting is an upstream one and it would be nice if somebody having it could send the bug to the developers of the software by following the instructions verbatim at http://wiki.documentfoundation.org/BugReport . If you have done so, please tell us the number of the upstream bug (or the link), so we can add a bugwatch that will inform us about the status. Thanks in advance.

Helpful Bug Reporting Link:
https://help.ubuntu.com/community/ReportingBugs#Bug_Reporting_Etiquette

[Marcus Tomlinson (marcustomlinson)]

This release of Ubuntu is no longer receiving maintenance updates. If this is still an issue on a maintained version of Ubuntu please let us know.

[Launchpad Janitor (janitor)]

[Expired for libreoffice (Ubuntu) because there has been no activity for 60 days.]