[ooo-build] OOo calc 3.2 when saving the spreadsheet as a Microsoft Excel 97/2000/XP format cell height is incorrect

[John Higby]

Binary package hint: firefox

When using Open Office 3.2 Spreadsheet, save the spreadsheet as a Microsoft Excel 97/2000/XP (XLT) format. and then reopen that file, all the entries are crowded against the top of the cells. When I save the file in any of the older (XLS) formats the file looks OK when opened.

I notice that when I open a file in the saved in the (ODS) or older (XLS) formats, I see notice at the bottom of the page with a status bar that says "Adapt Row Height". I do not see this message or status bar when I open a file saved in the Microsoft Excel 97/2000/XP (XLT) format. It would appear the the "Adapt Row Height" function is missing when saving in this format.

I am running a clean install of Lucid 10.04 using a CD that was mailed to me by Ubuntu. All updates are installed as of today. Open Office Version 3.2.0 000320m12 Build:(9483).

ProblemType: Bug
DistroRelease: Ubuntu 10.04
Package: firefox 3.6.3+nobinonly-0ubuntu4
ProcVersionSignature: Ubuntu 2.6.32-22.33-generic 2.6.32.11+drm33.2
Uname: Linux 2.6.32-22-generic i686
Architecture: i386
Date: Mon May 24 14:50:15 2010
FirefoxPackages:
 firefox 3.6.3+nobinonly-0ubuntu4
 firefox-gnome-support 3.6.3+nobinonly-0ubuntu4
 firefox-branding 3.6.3+nobinonly-0ubuntu4
 abroswer N/A
 abrowser-branding N/A
InstallationMedia: Ubuntu 10.04 LTS "Lucid Lynx" - Release i386 (20100429)
ProcEnviron:
 LANG=en_US.UTF-8
 SHELL=/bin/bash
SourcePackage: firefox

[Micah Gersten (micahg)]

Moving to openoffice.org for triage.

[Chris Cheney (ccheney)]

I am not sure what you mean. It is adjusting the row height for some XLS and ODS files but not all? If so perhaps those files do not need adjustment? Can you attach an example of each type of file as you mentioned in the bug report?

Thanks,

Chris

[John Higby (jhhigby)]

Hi,
Please see the attached screen shoots. Notice that the file saved in the
Excel 97/2000/XP format shows the entries pushed up against the top of
the cell while the entries when saved in the Excel 95 or ODS format are
centered in the cell. You can zoom in to get a close look at this. Also
attached are this file saved in all three formats. Hope this helps...

Thanks,
John

On 05/25/2010 12:59 AM, Chris Cheney wrote:
> I am not sure what you mean. It is adjusting the row height for some XLS
> and ODS files but not all? If so perhaps those files do not need
> adjustment? Can you attach an example of each type of file as you
> mentioned in the bug report?
>
> Thanks,
>
> Chris
>
> ** Changed in: openoffice.org (Ubuntu)
> Status: New => Incomplete
>
>

[Souris (dleger)]

I think this bug is a duplicate of this one : 561703
...or vice versa...

[Souris (dleger)]

I think this bug is a duplicate of this one : bug 561703
...or vice versa...

[Jack Leigh (leighman)]

I reported the bug upstream, please add additional information there if you feel it is necessary

[Galaxor (gnebulon)]

This is confirmed in the ubuntu build of libreoffice? I'm currently using
the libreoffice from their ppa, and it does not exhibit the bug.

On Fri, 11 Feb 2011, Bug Watch Updater wrote:

> ** Changed in: df-libreoffice
> Status: Unknown => Confirmed
>
> ** Changed in: df-libreoffice
> Importance: Unknown => Medium
>
> --
> You received this bug notification because you are a direct subscriber
> of a duplicate bug (561703).
> https://bugs.launchpad.net/bugs/585130
>
> Title:
> [ooo-build] OOo calc 3.2 when saving the spreadsheet as a Microsoft
> Excel 97/2000/XP format cell height is incorrect
>
> Status in LibreOffice Productivity Suite:
> Confirmed
> Status in The OpenOffice.org Suite:
> New
> Status in “libreoffice” package in Ubuntu:
> Triaged
> Status in “openoffice.org” package in Ubuntu:
> Triaged
>
> Bug description:
> Binary package hint: firefox
>
> When using Open Office 3.2 Spreadsheet, save the spreadsheet as a
> Microsoft Excel 97/2000/XP (XLT) format. and then reopen that file,
> all the entries are crowded against the top of the cells. When I save
> the file in any of the older (XLS) formats the file looks OK when
> opened.
>
> I notice that when I open a file in the saved in the (ODS) or older
> (XLS) formats, I see notice at the bottom of the page with a status
> bar that says "Adapt Row Height". I do not see this message or status
> bar when I open a file saved in the Microsoft Excel 97/2000/XP (XLT)
> format. It would appear the the "Adapt Row Height" function is missing
> when saving in this format.
>
> I am running a clean install of Lucid 10.04 using a CD that was mailed
> to me by Ubuntu. All updates are installed as of today. Open Office
> Version 3.2.0 000320m12 Build:(9483).
>
> ProblemType: Bug
> DistroRelease: Ubuntu 10.04
> Package: firefox 3.6.3+nobinonly-0ubuntu4
> ProcVersionSignature: Ubuntu 2.6.32-22.33-generic 2.6.32.11+drm33.2
> Uname: Linux 2.6.32-22-generic i686
> Architecture: i386
> Date: Mon May 24 14:50:15 2010
> FirefoxPackages:
>  firefox 3.6.3+nobinonly-0ubuntu4
>  firefox-gnome-support 3.6.3+nobinonly-0ubuntu4
>  firefox-branding 3.6.3+nobinonly-0ubuntu4
>  abroswer N/A
>  abrowser-branding N/A
> InstallationMedia: Ubuntu 10.04 LTS "Lucid Lynx" - Release i386 (20100429)
> ProcEnviron:
>  LANG=en_US.UTF-8
>  SHELL=/bin/bash
> SourcePackage: firefox
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/df-libreoffice/+bug/585130/+subscribe
>

[John Higby (jhhigby)]

I originated this Bug and it now seems to be fixed in OpenOffice. Do not
know if the bug is still in LibreOffice....

On 02/11/2011 11:27 AM, Galaxor wrote:
> This is confirmed in the ubuntu build of libreoffice? I'm currently using
> the libreoffice from their ppa, and it does not exhibit the bug.
>
> On Fri, 11 Feb 2011, Bug Watch Updater wrote:
>
>> ** Changed in: df-libreoffice
>> Status: Unknown => Confirmed
>>
>> ** Changed in: df-libreoffice
>> Importance: Unknown => Medium
>>
>> --
>> You received this bug notification because you are a direct subscriber
>> of a duplicate bug (561703).
>> https://bugs.launchpad.net/bugs/585130
>>
>> Title:
>> [ooo-build] OOo calc 3.2 when saving the spreadsheet as a Microsoft
>> Excel 97/2000/XP format cell height is incorrect
>>
>> Status in LibreOffice Productivity Suite:
>> Confirmed
>> Status in The OpenOffice.org Suite:
>> New
>> Status in “libreoffice” package in Ubuntu:
>> Triaged
>> Status in “openoffice.org” package in Ubuntu:
>> Triaged
>>
>> Bug description:
>> Binary package hint: firefox
>>
>> When using Open Office 3.2 Spreadsheet, save the spreadsheet as a
>> Microsoft Excel 97/2000/XP (XLT) format. and then reopen that file,
>> all the entries are crowded against the top of the cells. When I save
>> the file in any of the older (XLS) formats the file looks OK when
>> opened.
>>
>> I notice that when I open a file in the saved in the (ODS) or older
>> (XLS) formats, I see notice at the bottom of the page with a status
>> bar that says "Adapt Row Height". I do not see this message or status
>> bar when I open a file saved in the Microsoft Excel 97/2000/XP (XLT)
>> format. It would appear the the "Adapt Row Height" function is missing
>> when saving in this format.
>>
>> I am running a clean install of Lucid 10.04 using a CD that was mailed
>> to me by Ubuntu. All updates are installed as of today. Open Office
>> Version 3.2.0 000320m12 Build:(9483).
>>
>> ProblemType: Bug
>> DistroRelease: Ubuntu 10.04
>> Package: firefox 3.6.3+nobinonly-0ubuntu4
>> ProcVersionSignature: Ubuntu 2.6.32-22.33-generic 2.6.32.11+drm33.2
>> Uname: Linux 2.6.32-22-generic i686
>> Architecture: i386
>> Date: Mon May 24 14:50:15 2010
>> FirefoxPackages:
>> firefox 3.6.3+nobinonly-0ubuntu4
>> firefox-gnome-support 3.6.3+nobinonly-0ubuntu4
>> firefox-branding 3.6.3+nobinonly-0ubuntu4
>> abroswer N/A
>> abrowser-branding N/A
>> InstallationMedia: Ubuntu 10.04 LTS "Lucid Lynx" - Release i386 (20100429)
>> ProcEnviron:
>> LANG=en_US.UTF-8
>> SHELL=/bin/bash
>> SourcePackage: firefox
>>
>> To unsubscribe from this bug, go to:
>> https://bugs.launchpad.net/df-libreoffice/+bug/585130/+subscribe
>>

[Jack Leigh (leighman)]

Hmm.
The attached document still shows the error, but I guess the error was with the save since I now can't reproduce the problem in a fresh file.