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)
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.
--
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
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
In attachment ods file, sheet Results has been copied to end position as
Results 2. The function references are copied incorrectly and refer to
the wrong sheets. Compare Sheets Results and Results 2. Delete Results 2
and copy Result again again to end position. The errors are consistent.
I
Public bug reported:
Binary package hint: openoffice.org
Sheet reference translation error. After a sheet copy, sheet references
are shifted by one. In other words sheet1.range becomes sheet2.range in
thr sheet copy version.
[EMAIL PROTECTED]:~$ lsb_release -rd
Description:Ubuntu 7.10
** 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.
--