[upstream] openoffice calc sumproduct, lookup, vlookup, Hlookup problems

[Gummi Bj]

Binary package hint: openoffice.org

I have a sheet with many sumproducts (100+) and 13 tabs. 3.0.1 handles them correctly but 3.1.1 mishandles them.

I am collating data in many rows from external .xls sheets that my accountant sends me. e.g. one row contains x data for each department, next row y data etc. In 3.0.1 it collects the right data but 3.1.1 will in many cases copy the data from the row before. It never consist of arbitrary data but mostly copies the data from the wrong tab (e.g. .xls sheet contains tab A, B, C etc.).

Further more, if I start using lookup or vlookup more bizare things come up. If I only use lookup or vlookup the same problem happens but if I alternate the fomulas it works ok.

The sumproduct problem only seems to happen if I am collecting data from tabs that have only one possible reference. Not if it has to compare 2 or more references.

The steps I have taken so far are:
- purged config files (Home and system wide) and reinstalled
- gone back and forth from 3.0.1 to 3.1.1 cleaning the home config's first
- latest was to upgrade from 3.0.1. Opening up the file first to make sure the data was correct and not save the file. Then upgrade and deleting ~/.openoffice and opening it up with 3.1.1 (results same, just by opening up the file it displayed the wrong data. And then saving the file, opening it up again and still the same problem.

In all cases the results were the same.

I would send the file with this but I am afraid that it is strictly confidential.

ProblemType: Bug
Architecture: i386
DistroRelease: Ubuntu 9.04
Package: openoffice.org-core 1:3.1.1-1ubuntu1~jaunty1
ProcEnviron:
 LANGUAGE=
 PATH=(custom, no user)
 LANG=en_GB.UTF-8
 SHELL=/bin/bash
SourcePackage: openoffice.org
Uname: Linux 2.6.28-15-generic i686
UnreportableReason: This is not a genuine Ubuntu package

[Chris Cheney (ccheney)]

Can you please file this upstream bug at http://qa.openoffice.org/issue_handling/pre_submission.html and add the bug number back to this report?

[Gummi Bj (gummi-shopping)]

On Thursday 22 Oct 2009 16:14:18 Chris Cheney wrote:
> Can you please file this upstream bug at
> http://qa.openoffice.org/issue_handling/pre_submission.html and add the
> bug number back to this report?
>
> ** Changed in: openoffice.org (Ubuntu)
> Status: New => Incomplete
>

Issue 106230 posted to Openoffice.org

[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.