[Upstream] Rotated text is invisible unless Vertical Alignment=BOTTOM

[jimav]

Binary package hint: openoffice.org-calc
Binary package hint: libreoffice

1)
Natty:
lsb_release -rd
Description: Ubuntu natty (development branch)
Release: 11.04

Maverick:
lsb_release -rd
Description: Ubuntu 10.10
Release: 10.10

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

Maverick:
apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.3.1-1ubuntu3~maverick1
  Candidate: 1:3.3.1-1ubuntu3~maverick1
  Version table:
 *** 1:3.3.1-1ubuntu3~maverick1 0
        500 http://ppa.launchpad.net/libreoffice/ppa/ubuntu/ maverick/main i386 Packages
        100 /var/lib/dpkg/status

3) What is expected is when one performs at the Terminal:

cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/668079/+attachment/1714992/+files/OObug_RotatedText.ods && localc -nologo OObug_RotatedText.ods

and the cells with "shrink to fit", rotated 90 degrees, are visible as they are in Microsoft Office Excel Viewer.

4) What happened instead is the cells show no content unless Vertical Alignment is set to 'Bottom".

WORKAROUND: Use Gnumeric.

lsb_release -rd
Description: Ubuntu 10.10
Release: 10.10

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

ProblemType: Bug
DistroRelease: Ubuntu 10.10
Package: openoffice.org-calc 1:3.2.1-7ubuntu1
ProcVersionSignature: Ubuntu 2.6.35-22.35-generic 2.6.35.4
Uname: Linux 2.6.35-22-generic x86_64
Architecture: amd64
Date: Thu Oct 28 15:32:32 2010
InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Release Candidate amd64 (20100928)
ProcEnviron:
 PATH=(custom, user)
 LANG=en_US.utf8
 SHELL=/bin/bash
SourcePackage: openoffice.org

[penalvch (penalvch)]

Same issue occurs in Ubuntu 11.04, LibreOffice Calc, not in Excel Viewer.

cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/668079/+attachment/1714992/+files/OObug_RotatedText.ods && localc -nologo OObug_RotatedText.ods

clicked File -> Save As -> File type: triangle -> Microsoft Excel 97/2000/XP (.xls) -> Save button -> opened Firefox & downloaded Excel Viewer via:

http://www.microsoft.com/downloads/info.aspx?na=41&SrcFamilyId=1CD6ACF9-CE06-4E1C-8DCF-F33F669DBC3A&SrcDisplayLang=en&u=http%3a%2f%2fdownload.microsoft.com%2fdownload%2fe%2fa%2f9%2fea913c8b-51a7-41b7-8697-9f0d0a7274aa%2fExcelViewer.exe

wine ExcelViewer.exe

cd ~/.wine/drive_c/Program\ Files/Microsoft\ Office/Office12 && wine XLVIEW.exe

lsb_release -rd
Description: Ubuntu natty (development branch)
Release: 11.04

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

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

Microsoft Office Excel Viewer (12.0.6219.1000) MSO (12.0.6514.5000)

[Robert Roth (evfool)]

A strange thing: tested with OpenOffice 3.3 and LibreOffice 3.3 on windows, and LibreOffice has this issue, OpenOffice 3.3 doesn't have this. I thought all the changes from oo.org 3.3 were included in Libo 3.3

[penalvch (penalvch)]

jimav, since this bug has enough information provided for a developer to begin work, I'm going to mark it as Triaged and let them handle it from here. Thanks for taking the time to make Ubuntu better!

[penalvch (penalvch)]

jimav, I am closing the bug task for LibreOffice because it has been fixed in the latest development version of Ubuntu - Oneiric Ocelot.

This is a significant bug in Ubuntu. If you need a fix for the bug in previous versions of Ubuntu, please do steps 1 and 2 of the SRU Procedure [1] to bring the need to a developer's attention.

[1]: https://wiki.ubuntu.com/StableReleaseUpdates#Procedure

lsb_release -rd
 Description: Ubuntu oneiric (development branch)
 Release: 11.10

 apt-cache policy libreoffice-writer
 libreoffice-writer:
 Installed: 1:3.4.2-2ubuntu2
 Candidate: 1:3.4.2-2ubuntu2
 Version table:
 *** 1:3.4.2-2ubuntu2 0
 500 http://us.archive.ubuntu.com/ubuntu/ oneiric/main i386 Packages
 100 /var/lib/dpkg/status

[Björn Michaelsen (bjoern-michaelsen)]

[This is an automated message.]
There are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix

If the problem persists, please mark this bug as "also affects project Libreoffice" or "also affects distribution Libreoffice (Ubuntu)" if that has not happened already.

Please leave references to upstream OpenOffice.org bugs in place to allow cross pollination.

[bitinerant (bitinerant)]

For text rotated 270 degrees, text is invisible unless Vertical Alignment=TOP.