https://bugs.documentfoundation.org/show_bug.cgi?id=90447

            Bug ID: 90447
           Summary: vba calls to end(xlup) and find change cell/sheet
                    focus
           Product: LibreOffice
           Version: 4.0.0.0 beta1
          Hardware: Other
                OS: All
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: BASIC
          Assignee: [email protected]
          Reporter: [email protected]

Created attachment 114610
  --> https://bugs.documentfoundation.org/attachment.cgi?id=114610&action=edit
xls macro that demonstrates sheet focus change

When calling a function like Sheets("mySheet")...End(xlup), the UI switch to
mySheet.   In Excel, you need to add .Select to "jump" to that sheet/cell.  It
also worked like Excel in LO 3.6.

977cf448a89278afffc3dd6ece1dea3d0d695345 is the first bad commit
commit 977cf448a89278afffc3dd6ece1dea3d0d695345
Author: Bjoern Michaelsen <[email protected]>
Date:   Mon Dec 10 12:09:25 2012 +0000

    source-hash-cbc44df67cfd13849f3de85edcdd39b5fec8b06c

    commit cbc44df67cfd13849f3de85edcdd39b5fec8b06c
    Author:     Ricardo Montania <[email protected]>
    AuthorDate: Thu Sep 13 12:17:40 2012 -0300
    Commit:     Olivier Hallot <[email protected]>
    CommitDate: Fri Sep 14 00:00:16 2012 +0000

...
# bad: [977cf448a89278afffc3dd6ece1dea3d0d695345]
source-hash-cbc44df67cfd13849f3de85edcdd39b5fec8b06c
git bisect bad 977cf448a89278afffc3dd6ece1dea3d0d695345
# good: [bc819bc0c4d8592212f84069eb7f65e539517166]
source-hash-d9412fb4755377b8358a46a249cfe29a22ea9451
git bisect good bc819bc0c4d8592212f84069eb7f65e539517166

Last good date:      2012-09-11 05:31:43 (GMT)

Likely culprit (compiling failure, so I can't confirm):
author    Noel Power <[email protected]>    2012-09-11 07:48:02 (GMT)
committer    Michael Meeks <[email protected]>    2012-09-12 11:49:49
(GMT)
commit    4597483e00bffcc4e30d379dcf6fad42bc565e56 (patch)
tree    b590428b0e3ae3c7056e6c18f008d7179dc5ba38
parent    c414499bbd456389ac6cacf677327bff9e6b43f9 (diff)
targetted VBA re-work.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to