desktop-packages team mailing list archive

[Bug Watch Updater <1379341@xxxxxxxxxxxxxxxxxx>]

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:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1379341/comments/9

------------------------------------------------------------------------
On 2014-02-03T11:44:22+00:00 Nopower wrote:

*** Bug 74118 has been marked as a duplicate of this bug. ***

Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1379341/comments/10

------------------------------------------------------------------------
On 2014-10-09T13:16:51+00:00 MMS-Prodeia wrote:

Just wanted to let you know that this bug is still present in version
4.2.6.3!

It gave me a headache as my macro wasn't working anymore until I found
this bug here!

As it is quite old, I thought it should have been fixed already!?

Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1379341/comments/11


** Changed in: df-libreoffice
       Status: Unknown => Confirmed

** Changed in: df-libreoffice
   Importance: Unknown => Medium

-- 
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 Productivity Suite:
  Confirmed
Status in “libreoffice” package in Ubuntu:
  New

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