[Desktop-packages] [Bug 1379341] Re: Basic: after sheets.copybyname or sheets.remove basic-variable points to wrong sheet
Synchronising bug status with upstream. ** Changed in: libreoffice (Ubuntu) Status: Incomplete => Fix Released -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1379341 Title: Basic: after sheets.copybyname or sheets.remove basic-variable points to wrong sheet Status in LibreOffice: Fix Released Status in libreoffice package in Ubuntu: Fix Released Bug description: This one is an upstream bug at libreoffice, so updating to a newer version of libre office should fix it! As 14.04 is a LTS, it should get fixed. See: https://www.libreoffice.org/bugzilla/show_bug.cgi?id=70079 To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1379341/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1379341] Re: Basic: after sheets.copybyname or sheets.remove basic-variable points to wrong sheet
Launchpad has imported 16 comments from the remote bug at
https://bugs.documentfoundation.org/show_bug.cgi?id=70079.
If you reply to an imported comment from within Launchpad, your comment
will be sent to the remote bug automatically. Read more about
Launchpad's inter-bugtracker facilities at
https://help.launchpad.net/InterBugTracking.
On 2013-10-03T14:13:14+00:00 Uwelengler wrote:
basic variable = sheets.getbyname(..)
After inserting a new sheet with sheets.copybyname before this sheet , the
basic variable points to the wrong sheet, here sheetpositon -1. You get the
same effect after removing a sheet, the variable points then to sheetpositon+1.
The problem is new in this LO version. A retest in LO 4.0 is OK.
REM * BASIC *
global otabledoc as variant
Sub Main
oTableDoc=ThisComponent
oSheets = oTableDoc.sheets
if osheets.hasbyname("Tabellenew") then
osheets.removebyname("Tabellenew")
endif
Sheet1 = oSheets.GetbyName("Tabelle1")
oSheets = oTableDoc.sheets
'msgbox osheets.dbg_methods
osheets.copybyname(sheet1.name,"Tabellenew",0) 'because 3.Parameter = 0 -->
insert the new sheet before the sheet1 Tabelle1
'if you insert the new sheet after the old sheet, everything is ok.
Sheet1.getCellByPosition(0,0).string=sheet1.name 'write to the sheet
Tabellenew, not to the sheet Tabelle1
End Sub
Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1379341/comments/1
On 2013-10-03T15:12:33+00:00 Uwelengler wrote:
*** Bug 70081 has been marked as a duplicate of this bug. ***
Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1379341/comments/3
On 2013-10-23T07:41:56+00:00 Eugeny Shkrigunov wrote:
*** Bug 70754 has been marked as a duplicate of this bug. ***
Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1379341/comments/5
On 2013-10-27T11:08:53+00:00 Eugeny Shkrigunov wrote:
Created attachment 88172
bug example
Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1379341/comments/7
On 2013-10-27T11:13:27+00:00 Eugeny Shkrigunov wrote:
Also getByIndex (see bug example).
Seems that affected all documents that assign variable = ThisComponent.Sheets.
...
Please, fix this bug in 4.1.3.
Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1379341/comments/9
On 2013-10-29T12:59:06+00:00 Eugeny Shkrigunov wrote:
Created attachment 88289
fix
A Sheet.RangeAddress does not get updated on copy or move.
Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1379341/comments/11
On 2013-11-12T09:28:48+00:00 Eugeny Shkrigunov wrote:
Include the fix in next release, please.
Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1379341/comments/13
On 2013-11-13T12:19:46+00:00 Michael-stahl wrote:
there's some patch attached here - could some Calc developer please take
a look?
Eugenij, it's best to send patches to gerrit - in bugzilla they are
usually only found by accident, months later
https://wiki.documentfoundation.org/Development/gerrit
Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1379341/comments/15
On 2013-11-13T12:36:42+00:00 Eugeny Shkrigunov wrote:
(In reply to comment #7)
> there's some patch attached here - could some Calc developer please take a
> look?
>
> Eugenij, it's best to send patches to gerrit - in bugzilla they are usually
> only found by accident, months later
>
> https://wiki.documentfoundation.org/Development/gerrit
Michael, thanks for the tip. I looked at the link. Sorry, I have no
experience with git.
Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1379341/comments/17
On 2014-02-03T11:43:36+00:00 Libreoffice-commits wrote:
Noel Power committed a patch related to this issue.
It has been pushed to "master":
http://cgit.freedesktop.org/libreoffice/core/commit/?id=8eec79e595eb651cd41e2f6a1918af67c4d43cf7
Revert "fix Worksheet.Cells by now allowing TableSheet..." fdo#70079
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds
Affected users are encouraged to test the fix and report feedback.
[Desktop-packages] [Bug 1379341] Re: Basic: after sheets.copybyname or sheets.remove basic-variable points to wrong sheet
** Bug watch added: Document Foundation Bugzilla #70079 https://bugs.documentfoundation.org/show_bug.cgi?id=70079 ** Changed in: df-libreoffice Importance: Medium => Unknown ** Changed in: df-libreoffice Status: Confirmed => Unknown ** Changed in: df-libreoffice Remote watch: LibreOffice Bugzilla #70079 => Document Foundation Bugzilla #70079 -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1379341 Title: Basic: after sheets.copybyname or sheets.remove basic-variable points to wrong sheet Status in LibreOffice: Unknown Status in libreoffice package in Ubuntu: Incomplete Bug description: This one is an upstream bug at libreoffice, so updating to a newer version of libre office should fix it! As 14.04 is a LTS, it should get fixed. See: https://www.libreoffice.org/bugzilla/show_bug.cgi?id=70079 To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1379341/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1379341] Re: Basic: after sheets.copybyname or sheets.remove basic-variable points to wrong sheet
This release of Ubuntu is no longer receiving maintenance updates. If this is still an issue on a maintained version of Ubuntu please let us know. ** Changed in: libreoffice (Ubuntu) Status: New => Incomplete -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1379341 Title: Basic: after sheets.copybyname or sheets.remove basic-variable points to wrong sheet Status in LibreOffice: Confirmed Status in libreoffice package in Ubuntu: Incomplete Bug description: This one is an upstream bug at libreoffice, so updating to a newer version of libre office should fix it! As 14.04 is a LTS, it should get fixed. See: https://www.libreoffice.org/bugzilla/show_bug.cgi?id=70079 To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1379341/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1379341] Re: Basic: after sheets.copybyname or sheets.remove basic-variable points to wrong sheet
Launchpad has imported 12 comments from the remote bug at https://www.libreoffice.org/bugzilla/show_bug.cgi?id=70079. If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://help.launchpad.net/InterBugTracking. On 2013-10-03T14:13:14+00:00 Uwelengler wrote: basic variable = sheets.getbyname(..) After inserting a new sheet with sheets.copybyname before this sheet , the basic variable points to the wrong sheet, here sheetpositon -1. You get the same effect after removing a sheet, the variable points then to sheetpositon+1. The problem is new in this LO version. A retest in LO 4.0 is OK. REM * BASIC * global otabledoc as variant Sub Main oTableDoc=ThisComponent oSheets = oTableDoc.sheets if osheets.hasbyname(Tabellenew) then osheets.removebyname(Tabellenew) endif Sheet1 = oSheets.GetbyName(Tabelle1) oSheets = oTableDoc.sheets 'msgbox osheets.dbg_methods osheets.copybyname(sheet1.name,Tabellenew,0) 'because 3.Parameter = 0 -- insert the new sheet before the sheet1 Tabelle1 'if you insert the new sheet after the old sheet, everything is ok. Sheet1.getCellByPosition(0,0).string=sheet1.name 'write to the sheet Tabellenew, not to the sheet Tabelle1 End Sub Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1379341/comments/0 On 2013-10-03T15:12:33+00:00 Uwelengler wrote: *** Bug 70081 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1379341/comments/1 On 2013-10-23T07:41:56+00:00 Eugeny Shkrigunov wrote: *** Bug 70754 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1379341/comments/2 On 2013-10-27T11:08:53+00:00 Eugeny Shkrigunov wrote: Created attachment 88172 bug example Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1379341/comments/3 On 2013-10-27T11:13:27+00:00 Eugeny Shkrigunov wrote: Also getByIndex (see bug example). Seems that affected all documents that assign variable = ThisComponent.Sheets. ... Please, fix this bug in 4.1.3. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1379341/comments/4 On 2013-10-29T12:59:06+00:00 Eugeny Shkrigunov wrote: Created attachment 88289 fix A Sheet.RangeAddress does not get updated on copy or move. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1379341/comments/5 On 2013-11-12T09:28:48+00:00 Eugeny Shkrigunov wrote: Include the fix in next release, please. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1379341/comments/6 On 2013-11-13T12:19:46+00:00 Mstahl wrote: there's some patch attached here - could some Calc developer please take a look? Eugenij, it's best to send patches to gerrit - in bugzilla they are usually only found by accident, months later https://wiki.documentfoundation.org/Development/gerrit Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1379341/comments/7 On 2013-11-13T12:36:42+00:00 Eugeny Shkrigunov wrote: (In reply to comment #7) there's some patch attached here - could some Calc developer please take a look? Eugenij, it's best to send patches to gerrit - in bugzilla they are usually only found by accident, months later https://wiki.documentfoundation.org/Development/gerrit Michael, thanks for the tip. I looked at the link. Sorry, I have no experience with git. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1379341/comments/8 On 2014-02-03T11:43:36+00:00 Libreoffice-commits wrote: Noel Power committed a patch related to this issue. It has been pushed to master: http://cgit.freedesktop.org/libreoffice/core/commit/?id=8eec79e595eb651cd41e2f6a1918af67c4d43cf7 Revert fix Worksheet.Cells by now allowing TableSheet... fdo#70079 The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Reply at:
