[Libreoffice-bugs] [Bug 100460] Can not query sheet cells with annotations

[bugzilla-daemon]

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

Caolán McNamara  changed:

   What|Removed |Added

 Status|NEW |ASSIGNED
   Assignee|libreoffice-b...@lists.free |caol...@redhat.com
   |desktop.org |

--- Comment #7 from Caolán McNamara  ---
yoink this to me cause I think I can fix it

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100460] Can not query sheet cells with annotations

[bugzilla-daemon]

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

Commit Notification  changed:

   What|Removed |Added

 Whiteboard||target:5.3.0

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100460] Can not query sheet cells with annotations

[bugzilla-daemon]

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

--- Comment #6 from Commit Notification 
 ---
Caolán McNamara committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=84dc0157df9cb173ec74da2bd27507329efc3816

Related: tdf#100460 GetNotesInRange doesn't count last cell in range

It will be available in 5.3.0.

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.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100460] Can not query sheet cells with annotations

[bugzilla-daemon]

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

Caolán McNamara  changed:

   What|Removed |Added

  Component|sdk |Calc

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100460] Can not query sheet cells with annotations

[bugzilla-daemon]

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

Caolán McNamara  changed:

   What|Removed |Added

   Keywords|bibisectRequest |bisected

--- Comment #5 from Caolán McNamara  ---
while I can't bibisect this the change has to be...

commit c06dbbe7594c2a0b5a5b19f8e183d9c421e6e094
Author: Markus Mohrhard 
Date:   Thu Feb 23 23:36:49 2012 +0100

remove mpNote from ScBaseCell

which removed the sheet::CellFlags::ANNOTATION check

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100460] Can not query sheet cells with annotations

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

   Keywords||bibisectRequest, regression
 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1

--- Comment #4 from Buovjaga  ---
Ok now I got it after deleting
globalscope.basiclibraries.loadlibrary("myTools").

Cell Ranges with Annotations ueried from A1:A20: 0

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100460] Can not query sheet cells with annotations

[bugzilla-daemon]

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

--- Comment #3 from Andreas Säger  ---
(In reply to Buovjaga from comment #2)
> I get
> 
> BASIC runtime error.
> An exception occurred 
> Type: com.sun.star.container.NoSuchElementException
> Message: .
> 

Oh sorry. Delete the line which raises the error and try again.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100460] Can not query sheet cells with annotations

[bugzilla-daemon]

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

--- Comment #2 from Buovjaga  ---
I get

BASIC runtime error.
An exception occurred 
Type: com.sun.star.container.NoSuchElementException
Message: .

64-bit, KDE Plasma 5
Build ID: 5.1.3.2 Arch Linux build-1
CPU Threads: 8; OS Version: Linux 4.5; UI Render: default; 
Locale: fi-FI (fi_FI.UTF-8)

Arch Linux 64-bit, KDE Plasma 5
Version: 5.3.0.0.alpha0+
Build ID: c13f60e7cd18df6b0ab70289f5b91ee01e4ae126
CPU Threads: 8; OS Version: Linux 4.6; UI Render: default; 
Locale: fi-FI (fi_FI.UTF-8)
Built on June 18th 2016

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100460] Can not query sheet cells with annotations

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

 CC||todven...@suomi24.fi
 Attachment #125713|application/x-zip   |application/vnd.oasis.opend
  mime type||ocument.spreadsheet

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100460] Can not query sheet cells with annotations

[bugzilla-daemon]

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

--- Comment #1 from Andreas Säger  ---
Created attachment 125713
  --> https://bugs.documentfoundation.org/attachment.cgi?id=125713=edit
Some annotated cells and Basic macro

When you hit the push button, a message box reports
"Cell Ranges with Annotations ueried from A1:A20: 0"

AOO reports
"Cell Ranges with Annotations ueried from A1:A20: 4"
since there are 4 blocks of annotated cells.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100460] Can not query sheet cells with annotations

[bugzilla-daemon]

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

Andreas Säger  changed:

   What|Removed |Added

Version|unspecified |5.1.3.2 release

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs