OOo Calc has func. problem, %MACRO

[oaxacamatt1]

Binary package hint: openoffice.org

Hi All,

I came across this issue while use OOo 3.1.1, OOO310M19 (Build 9420). So far, the issue occurs when I use the function for the chi-square distribution (=chisqdist). When I save the spreadsheet then open it up later the cell calling for that func now has the string '%MACRO' in it. Sometimes I can only clear the issue by deleting the cell and starting over other times I can clear the error by deleting the the equal sign and retyping it.

I went to OOo and put this issue into their bug reporting system and got a message back saying that my OOo (build 9420) is fine 'it must be your Ubuntu' causing the problem. So here I am.

I am attaching the email I got from OOo.
HTH
Matt

************************
Hi Matt,

you have written to my personal email address. Please add your comment
to the issue.

Your problem is likely a bug in the Ubuntu version. Please report the
problem to Ubuntu. I have not heard from others using ODF1.2, that there
are problems with this function.

kind regards
Regina
*********************
Matt Curcio schrieb:
> Greetings,
> I checked the ODF format version that I am using, It is 1.2. I am using
> the OOo that came with my Ubuntu linux distribution.
> HTH
> Matt
>
> Sincerely,
>
> Matt Curcio
> <email address hidden>
> 401-316-5358

[papukaija (papukaija)]

What is your Ubuntu version?

[oaxacamatt1 (oaxacamatt1)]

Sorry Here is some more info

Ubuntu 9.10 on a Toshiba Satellite L305 laptop.

************************************************
Here is some info from OOo.

To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=111017

User regina changed the following:
                What |Old value |New value
================================================================================
                      CC|'' |'regina'
--------------------------------------------------------------------------------
                Keywords| |needmoreinfo, oooqa
--------------------------------------------------------------------------------

------- Additional comments from <email address hidden> Tue Apr 20 14:16:34 +0000 2010 -------
Handling of CHIDIST has changed from ODF 1.1 to ODF 1.2. Which format do you
use? You find the setting in Tools > Options > Load/Save > General.

Or do you use CHISQDIST? This left tail version is not available in ODF1.1.

Do you use an original OOo version or do you use a version from your Linux provider?

---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

[Chris Cheney (ccheney)]

[This is an automatic notification.]

Thank you for taking the time to report this bug and helping to make Ubuntu better. Please execute the following command, as it will automatically gather debugging information, in a terminal:

apport-collect 567882

This will help us to find and resolve the problem. Bear in mind that you may need to install the python-launchpadlib package from the universe repository. Additionally, when prompted to give apport-collect permissions for Launchpad you will need to give it at least the ability to "Change Non-Private" data as it will be adding information to your bug report. Thanks in advance!

When reporting bugs in the future please use apport, either via the appropriate application's "Help -> Report a Problem" menu or using 'ubuntu-bug' and the name of the package affected. You can learn more about this functionality at https://wiki.ubuntu.com/ReportingBugs.

[papukaija (papukaija)]

We'd like to figure out what's causing this bug for you, but we haven't heard back from you in a while. Could you please provide the requested information? Thanks!

[oaxacamatt1 (oaxacamatt1)]

Hi P,
Sorry I have been too busy to get back to you in a timely manner.

So the problem now stands as follows:
I found out that OOo had 3.2 and uninstalled 3.1 and installed 3.2 hoping that this would fix the issue. Unfortunately it did not. I have opened up the spreadsheet that I made using 3.1 Calc and the same issue shows up for 3.2. I am starting to think it is either the way 3.1 writes its files for Calc or something (easily) beyond my comprehension ;). I would like to send you the .xls file that contains the error.

Would that be helpful for you, See attached,
M

[papukaija (papukaija)]

Please execute the following command, as it will automatically gather debugging information, in a terminal:

apport-collect 567882

This will help us to find and resolve the problem. Bear in mind that you may need to install the python-launchpadlib package from the universe repository. Additionally, when prompted to give apport-collect permissions for Launchpad you will need to give it at least the ability to "Change Non-Private" data as it will be adding information to your bug report. Thanks in advance!

When reporting bugs in the future please use apport, either via the appropriate application's "Help -> Report a Problem" menu or using 'ubuntu-bug' and the name of the package affected. You can learn more about this functionality at https://wiki.ubuntu.com/ReportingBugs.

Ps. I'm not an OO.org expert so I'm not the right person to analyse your file.

[papukaija (papukaija)]

We'd like to figure out what's causing this bug for you, but we haven't heard back from you in a while. Could you please provide the requested information? Thanks!

[papukaija (papukaija)]

We are closing this bug report because it lacks the information we need to investigate the problem, as described in the previous comments. Please reopen it if you can give us the missing information, and don't hesitate to submit bug reports in the future. To reopen the bug report you can click on the current status, under the Status column, and change the Status back to "New". Thanks again!