[Bug 243271] Re: Open Office Spreadsheet Sheet Copy error

2009-01-17 Thread Chris Cheney
** Bug watch added: OpenOffice.org Issue Tracker #98185 http://qa.openoffice.org/issues/show_bug.cgi?id=98185 ** Also affects: openoffice via http://qa.openoffice.org/issues/show_bug.cgi?id=98185 Importance: Unknown Status: Unknown ** Changed in: openoffice.org (Ubuntu)

[Bug 243271] Re: Open Office Spreadsheet Sheet Copy error

2008-10-12 Thread bs66
Bug still there in OOo 3.0 release (build 9358) on Windows. -- Open Office Spreadsheet Sheet Copy error https://bugs.launchpad.net/bugs/243271 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list

[Bug 243271] Re: Open Office Spreadsheet Sheet Copy error

2008-10-08 Thread bs66
Maybe already reported here? http://www.openoffice.org/issues/show_bug.cgi?id=1715 -- Open Office Spreadsheet Sheet Copy error https://bugs.launchpad.net/bugs/243271 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs

[Bug 243271] Re: Open Office Spreadsheet Sheet Copy error

2008-10-01 Thread bs66
To reproduce: http://launchpadlibrarian.net/16381493/lottoPermErr.ods Open lottoPermErr.ods in Calc (the version that is 39.7 KiB. se attachment above) Save the file locally (must do this in order to copy sheets) Select the sheet Results (leftclick the tab at the bottom) Rightclick the Results

[Bug 243271] Re: Open Office Spreadsheet Sheet Copy error

2008-10-01 Thread bs66
Same problem with Ubuntu 8.04.1 and OpenOffice 3.0 RC3. -- Open Office Spreadsheet Sheet Copy error https://bugs.launchpad.net/bugs/243271 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list

[Bug 243271] Re: Open Office Spreadsheet Sheet Copy error

2008-09-30 Thread bs66
I would say that this is not a bug, its a feature. The behavior is similar to how Microsoft Office Excel 2003 works when copying sheets. /bs66 -- Open Office Spreadsheet Sheet Copy error https://bugs.launchpad.net/bugs/243271 You received this bug notification because you are a member of

[Bug 243271] Re: Open Office Spreadsheet Sheet Copy error

2008-09-30 Thread bs66
ehrm. my mistake. i misunderstood the problem. sorry. the behavior is NOT the same as in Microsoft Office Excel 2003. Excel behaves as the reporter expects OOo to behave. I can reproduce the behavior here. 0:~$ lsb_release -rd Description:Ubuntu intrepid (development branch) Release:

[Bug 243271] Re: Open Office Spreadsheet Sheet Copy error

2008-09-30 Thread Neil Munro
Since two people can confirm this bug exists, it has now been marked as confirmed. ** Changed in: openoffice.org (Ubuntu) Status: Incomplete = Confirmed -- Open Office Spreadsheet Sheet Copy error https://bugs.launchpad.net/bugs/243271 You received this bug notification because you are a

[Bug 243271] Re: Open Office Spreadsheet Sheet Copy error

2008-07-29 Thread Derek Abson
To reproduce the Copy error, in file lottoPermErr.ods, you must copy sheet, Results, say, to Results 2, then compare the functions that appear in the lotto and plus columns in both versions of the copied sheet. In the original version, Results, you will see functions: =countif(lotto.range;value)

[Bug 243271] Re: Open Office Spreadsheet Sheet Copy error

2008-07-25 Thread Derek Abson
Yes! I still have this bug in Ubuntu 8.04! But my version is now openoffice.org 1:2.4.0-3ubuntu6. -- Open Office Spreadsheet Sheet Copy error https://bugs.launchpad.net/bugs/243271 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. --

[Bug 243271] Re: Open Office Spreadsheet Sheet Copy error

2008-07-25 Thread Chris Cheney
Derek, You should be able to get 1:2.4.1-1ubuntu2 if you make sure that hardy- updates is in the list to download from. Once you upgrade to this version see if the problem still exists since it has a lot of other fixes from what was in the normal Ubuntu 8.04 (Hardy) release. Thanks, Chris

[Bug 243271] Re: Open Office Spreadsheet Sheet Copy error

2008-07-25 Thread Derek Abson
Done the update to openoffice.org 1:2.4.1-1ubuntu2! Sorry, still doesn't work. -- Open Office Spreadsheet Sheet Copy error https://bugs.launchpad.net/bugs/243271 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing

[Bug 243271] Re: Open Office Spreadsheet Sheet Copy error

2008-07-25 Thread Chris Cheney
Ok, I see the document but can't seem to reproduce the problem you are having. If I insert a sheet it becomes Sheet10 but it doesn't seem to affect any of the formulas, and if I copy for example countLotto to become countLotto 2 it doesn't seem to affect any formulas either. Can you explain in a

[Bug 243271] Re: Open Office Spreadsheet Sheet Copy error

2008-07-24 Thread Chris Cheney
Do you still have this problem with openoffice.org 1:2.4.1-1ubuntu2 in Ubuntu 8.04? ** Changed in: openoffice.org (Ubuntu) Status: New = Incomplete -- Open Office Spreadsheet Sheet Copy error https://bugs.launchpad.net/bugs/243271 You received this bug notification because you are a

[Bug 243271] Re: Open Office Spreadsheet Sheet Copy error

2008-06-27 Thread Derek Abson
To protect a reference to sheet1, say, before copying sheet containing reference to sheet1, prefix sheet1 with $ sign. Then reference to sheet1 becomes $sheet1 in original sheet and remains $sheet1 in generated copy. I'm not really sure if it should normally be necessary to protect references

[Bug 243271] Re: Open Office Spreadsheet Sheet Copy error

2008-06-26 Thread Derek Abson
** Attachment added: lottoPermErr.ods http://launchpadlibrarian.net/15626176/lottoPermErr.ods -- Open Office Spreadsheet Sheet Copy error https://bugs.launchpad.net/bugs/243271 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. --