[ooo-build] Invalid sheet reference

[Lutfi]

My Hardy and Jaunty both using OpenOffice.org 3.1rc2 from "openoffice-pkgs". Using OpenOffice.org Calc can not set "row to repeat". Always got error:

Invalid sheet reference

[Lutfi (lutfiarab)]

Still happen on OpenOffice.org 3.1
Row to repeat or column to repeat still get this error

[Chris Cheney (ccheney)]

Do you still have this problem with the new version of OOo in the ppa at https://launchpad.net/~openoffice-pkgs/+archive ?

If you still can reproduce it with the current version can you please give detailed steps of how to reproduce the error? I am not sure where you are setting "row to repeat".

Thanks,

Chris Cheney

[Lutfi (lutfiarab)]

I still got this error. Both on my Hardy and Jaunty.

Here how i got the error:
1. Open OOCalc
2. Format menu -> Print Range -> Edit
3. Row to repeat, put $1 and OK
And error " Invalid sheet reference" still appear

On Fri, May 29, 2009 at 7:05 PM, Chris Cheney <email address hidden> wrote:
> Do you still have this problem with the new version of OOo in the ppa at
> https://launchpad.net/~openoffice-pkgs/+archive ?
>
> If you still can reproduce it with the current version can you please
> give detailed steps of how to reproduce the error? I am not sure where
> you are setting "row to repeat".
>
> Thanks,
>
> Chris Cheney
>
> ** Changed in: openoffice-pkgs
>       Status: New => Incomplete
>
> --
> Invalid sheet reference
> https://bugs.launchpad.net/bugs/374708
> You received this bug notification because you are a direct subscriber
> of the bug.
>

[hfwilke (hfwilke)]

I am getting this error as well. Running Jaunty 32 bit with open office installed from:

http://ppa.launchpad.net/openoffice-pkgs/ppa/ubuntu

[Jason Maas (maasj)]

+1 on this error. Running version 1:3.1.0-3ubuntu2~intrepid1 from the unofficial PPA on AMD64 Intrepid. @Lufti's steps reproduce the problem for me. This problem is a major pain for the users I support and I'll be glad to provide any additional information that would be helpful!

[Jason Maas (maasj)]

See also:

http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=527535

https://bugzilla.novell.com/show_bug.cgi?id=502641

[zanonmark (info-marcozanon)]

+1 on this for me too. running 8.04 and OOo 3.1 from PPA.

thanks,

MZ

[gdi2k (gdi2k)]

+1 for me running 64-bit Jaunty, using OpenOffice 3.1 from the PPA listed above by hfwilke.

[Adam Stovicek (arstovicek)]

I can confirm this bug exists with the currently available version of OpenOffice.org 3.1 from the Scribblers PPA.

Steps to reproduce:
1. Run OpenOffice.org Calc
2. Goto Format > Print Ranges > Edit
3. Enter a row ($1) in "Rows to repeat" field and/or a column ($A) in "Columns to repeat" field.
4. Press OK.
5. Error box appears. "Invalid sheet reference."

adam@obsidian:~$ apt-cache policy openoffice.org
openoffice.org:
  Installed: 1:3.1.0-5ubuntu1~jaunty1
  Candidate: 1:3.1.0-5ubuntu1~jaunty1
  Version table:
 *** 1:3.1.0-5ubuntu1~jaunty1 0
        500 http://ppa.launchpad.net jaunty/main Packages
        100 /var/lib/dpkg/status
     1:3.0.1-9ubuntu3 0
        500 http://aegis jaunty/main Packages

[zanonmark (info-marcozanon)]

still there in Alpha4

[Lutfi (lutfiarab)]

OO 3.1.1 still have this bug. And very annoying ...

On Sat, Sep 19, 2009 at 12:34 AM, zanonmark <email address hidden> wrote:
> still there in Alpha4
>
> --
> Invalid sheet reference
> https://bugs.launchpad.net/bugs/374708
> You received this bug notification because you are a direct subscriber
> of the bug.
>

[mfn (mfn)]

Is it so hard to remove the bug from a package that uses sources from Sun that doesn't contain this bug?

[mfn (mfn)]

Is it possible to include this workaround https://bugzilla.novell.com/show_bug.cgi?id=502641#c12 in the package?

--- snip ---
The problem is that the syntax check in areasdlg.cxx fails if there is no
formula grammar specified in the user configuration. In that case
lcl_CheckRepeatOne() just returns "false" instead of trying with the default
grammar. As a workaround try the following:

1. Select Tools/Options... from the menu
2. In the left tree navigate to OpenOffice.org Calc/Formula
3. Click on the Arrow right to "Calc A1" to see the list of possible grammars
and select "Calc A1" explicitely from the dropdown list (even if it was already
selected)
4. Press "OK" to save

[Gabriel Mazetto (brodock)]

Ubuntu Karmic Koala shipped and the bug still active.

[Algot Runeman (algot-runeman)]

The fix listed from mfn above worked for me, too, but it also turned off the freeze (Window menu - freeze) I had put on the top three lines of the sheet so they would remain visible during data entry once the sheet got large. Putting the freeze back removed the print range selection of those same three lines that the fix dealt with.

Using the (Window - split) to accomplish the same scroll benefit did not turn off the print range.
The "incompatibility" of freezing the top three rows with selecting them to be printed may be where the source of the problem is, and though the work-around is successful, it isn't, apparently, a fix.

[Adam J Richardson (fatman-crackmonkey)]

I'm experiencing this on Karmic as well.

I can't add much to Algot Runeman's report, except to say that after restoring the window freeze I found Calc had removed the print range selection as well as the repeated rows selection.

[Torsten Spindler (tspindler)]

The problem seems to be fixed in upstream oo.org 3.1.1.

[Валерий Булаш (valery-bulash)]

Bug still exists in oo 3.1.1 build 9420 shipped with Ubuntu 9.10 Karmic Koala

[JP Vossen (jp-jpsdomain)]

Confirm bug on Karmic 64-bit using STOCK (not PPA or whatever) packages, and this is a show stopper for printing any kind of long and non trivial data. However, mfn's workaround in #13 worked for me and did not affect window freeze. (THANK YOU mfn!)

$ cat /etc/lsb-release
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=9.10
DISTRIB_CODENAME=karmic
DISTRIB_DESCRIPTION="Ubuntu 9.10"

$ uname -a
Linux ringo 2.6.31-17-generic #54-Ubuntu SMP Thu Dec 10 17:01:44 UTC 2009 x86_64 GNU/Linux

$ apt-cache policy openoffice.org
openoffice.org:
  Installed: (none)
  Candidate: 1:3.1.1-5ubuntu1
  Version table:
     1:3.1.1-5ubuntu1 0
        500 http://us.archive.ubuntu.com karmic/main Packages

[Rashkae (rashkae)]

I know it's not really considered helpful here to 'bump', but might I point out this fairly serious bug (which exits only in Ubuntu/Debian packages, not Sun version of OO) has been around for over a year, 3 releases and is still Undecided/Unasigned??

[Kevin Funk (kfunk)]

Still happening, version: 1:3.2.0-4ubuntu2

[zanonmark (info-marcozanon)]

I confirm this is still happening with 3.2.0 packages for Hardy...

Thanks, MZ

[Mossroy (mossroy)]

Same problem on lucid (final release, version 1:3.2.0-7ubuntu4 of openoffice)

[Nexus (hozzan)]

I confirm this bug:

$ apt-cache policy openoffice.org
openoffice.org:
  Nainštalovaná verzia: (žiadna)
  Kandidát: 1:3.2.0-7ubuntu4
  Tabuľka verzií:
     1:3.2.0-7ubuntu4 0
        500 http://sk.archive.ubuntu.com/ubuntu/ lucid/universe Packages

[Gary Riddell (gary128)]

Ubuntu 9.10 desktop and Open Office 3.2.0
From the help, about: OOO320m12 (Build:9483)
.
.
ooo-build 3.2.0.10 , Debian 1:3.2.0-7Ubuntu4.1, Thu Jun 3 02:15:29 UTC 20....

Same bug.
Specify $1 or $1:$1 in "Rows to repeat" or $A or $A:$A in "Columns to repeat" produces "Invalid sheet reference".

[Gary Riddell (gary128)]

I found this:

1. From the menu, go to Tools->Options->OpenOffice Calc->Formula
2. Click on the Formula syntax dropdown and select "Excel A1". Click it again and change it back to "Calc A1"
3 Click OK button.

Here:

http://www.mentby.com/Group/ubuntu-users/openoffice-31-calc-how-to-correct-or-get-rid-of-the-invalid-sheet-reference.html

and it fixed the problem for me. Maybe this will help with finding and fixing this bug?

[MaWi (mwiessler)]

Hi there,

I've the same problem with
ooo-build 3.2.0.10, debian 1:3.2.0-7ubuntu4.1 (english) on Ubuntu 10.04 LTS - Lucid Lynx (german)

The work around worked for me... thx to Gary and Tony Pursell (who answered my question)

[jorma.olavi (jorma-veijanen)]

Thank you Gary,
it fixed the problem for me also.
Using now version 10.04.
regards, jorma veijanen

ma, 2010-07-05 kello 12:53 +0000, Gary Riddell kirjoitti:
> I found this:
>
> 1. From the menu, go to Tools->Options->OpenOffice Calc->Formula
> 2. Click on the Formula syntax dropdown and select "Excel A1". Click it again and change it back to "Calc A1"
> 3 Click OK button.
>
> Here:
>
> http://www.mentby.com/Group/ubuntu-users/openoffice-31-calc-how-to-
> correct-or-get-rid-of-the-invalid-sheet-reference.html
>
> and it fixed the problem for me. Maybe this will help with finding and
> fixing this bug?
>

[WGrimm (werner-grimm)]

Thank you Gary,
now its ok.

Mit freundlichen Grüßen
Werner Grimm

Petersgasse 11, Germany 64347 Griesheim
mailto:<email address hidden>

Am 05.07.2010 14:53, schrieb Gary Riddell:
> I found this:
>
> 1. From the menu, go to Tools->Options->OpenOffice Calc->Formula
> 2. Click on the Formula syntax dropdown and select "Excel A1". Click it again and change it back to "Calc A1"
> 3 Click OK button.
>
> Here:
>
> http://www.mentby.com/Group/ubuntu-users/openoffice-31-calc-how-to-
> correct-or-get-rid-of-the-invalid-sheet-reference.html
>
> and it fixed the problem for me. Maybe this will help with finding and
> fixing this bug?
>

[Cesare Mastroianni (cece)]

Hi there, thanks You all in advance.

I'm using OpenOffice 3.2 (release 3.2.0 - OOO320m12 - build:9483 - debian 3.2.0.10 - 1:3.2.0-7ubuntu4.1 ) on Lucid Lynx.

The problem described happened to me as well. The "bug fix" it is a peculiar operation: when I accessed the option panel about the "Calc A1" configuration, it really was ALREADY set to "Calc A1". To "fix" the problem I selected it again.

I had the problem since many months ago (I may be wrong, but I remember that this happened on Karmic Koala and Hardy Heron too) and the bug has not been fixed yet. IMHO this should be notified to mainstream developers because OO could suffer a lot on wide areas users: the first time I met the problem I spent too much time to understand what to do and find a solution on the web.

Thanks again.
Ciao
CM

[philippe stievenart (xco)]

Many thanks Gary !
It's fixed the problem for me
regards
Phil

[Christopher Plunkett (asmet)]

This bug has affected myself it is still in the latest issues of OpenOffice 3.2 under Ubuntu 10.04. Unfortunately (?) it does not occur in the Windows version of OpenOffice 3.2 thereby potentially alienating new users of Ubuntu from Windows. This may not be an issue for Open Office authors but as they are essentially in opposition to Microsoft there perhaps should be some sympathy for it. I used the solution offered by Gary Riddell and it worked for me. Thanks Gary Riddell

[BlueLight (bluelight-auroville)]

This bug continues in OpenOffice.org 3.2.1
OOO320m19 (Build:9505) on Maverick
ooo-build 3.2.1.4, Ubuntu package 1:3.2.1-7ubuntu1

In my case it affect 80 users and I get regularly service calls in because of this. I consider this a serious bug as repeated headers are essential.

[philippe stievenart (xco)]

To BlueLight :
Have you tried the Gary's stuff (see post #26).
It's simple and that's fix the problem for me (
OOo 3.2.0 - Ubuntu 10.04 - (OOO320m12 - Build9483)
Regards, Phil

[Cesare Mastroianni (cece)]

Phil thanks for Your comment. Unfortunately, the action described at #26 is the "classical" workaround that could be found in many places on the web. However, for Ubuntu/OpenOffice newbies it could be hard to find out that there is a bug. They could think U/OO is not a good solution for them, and they could go back to windows/MSOffice ... A real bug fix is needed, according to my opinion.

Ciao
CM

[jorma.olavi (jorma-veijanen)]

Yes I have tried and it works, BUT how can I remember all special
workarounds of the world. I agree with Cesare that the bug should be
fixed as soon as possible. How old the bug is ? years already ?
Best Regards Jorma Veijanen.

pe, 2010-11-26 kello 20:31 +0000, philippe stievenart kirjoitti:
> To BlueLight :
> Have you tried the Gary's stuff (see post #26).
> It's simple and that's fix the problem for me (
> OOo 3.2.0 - Ubuntu 10.04 - (OOO320m12 - Build9483)
> Regards, Phil
>

[neilbt (neilbt478)]

Workaround worked for me - OOo 3.1.1 Ubuntu 9.10 - and without affecting "freeze"
Previously had to open in OOo in windows vista, change & save! Delighted with the workaround!

[Pietro (pietro)]

Not only is this bug still here in the current version of OOo Calc as of 1/26, but the workaround described in #13 and reiterated in #26 only solved the problem once. I came back to the same file, the next day, and rows do not repeat, and the print range dialog box cannot be directly edited yet again because the "Invalid Sheet Reference" bug-window pops up.

Are we posting in the wrong place? Where do we post so that Ubuntu-staffers actually react, after 2.5 years?

[Tony Pursell (ajpursell)]

@Pietro

Apparently there is a fix for this. See

http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=527535

I cannot, personally, confirm that this fix will be in the next release of Ubuntu (due April 2011), but it is unlikely to be available before then.

[JP Vossen (jp-jpsdomain)]

I've had it with the lack of response on this and am looking at switching to LibreOffice. I've installed it on a test machine from PPA and it looks really good. Then I tested against this bug. Not only is the bug still present, I could not get the work-around to work!

However, someone in the Debian bug cited above says that the fix was actually backported from libreoffice/1:3.3.0~beta3-1, yet I am using libreoffice-1:3.3.0-1lucid1 from the PPA. Have to keep an eye on this. Maybe some competition will be a good thing.