oCellRange.queryContentCells(com.sun.star.sheet.CellFlags.ANNOTATION)always reports zero. Works with OpenOffice.
Created attachment 125713 [details] 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.
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
(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.
Ok now I got it after deleting globalscope.basiclibraries.loadlibrary("myTools"). Cell Ranges with Annotations ueried from A1:A20: 0
while I can't bibisect this the change has to be... commit c06dbbe7594c2a0b5a5b19f8e183d9c421e6e094 Author: Markus Mohrhard <markus.mohrhard@googlemail.com> Date: Thu Feb 23 23:36:49 2012 +0100 remove mpNote from ScBaseCell which removed the sheet::CellFlags::ANNOTATION check
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.
yoink this to me cause I think I can fix it
Caolán McNamara committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=83f977c7f40d1a5fb975b8ce7c9958c992dba3f1 Resolves: tdf#100460 queryContentCells doesn't count annotations... 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.
https://gerrit.libreoffice.org/#/c/26608/ 5-2 https://gerrit.libreoffice.org/#/c/26609/ 5-1
Caolán McNamara committed a patch related to this issue. It has been pushed to "libreoffice-5-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=b8b51fc4b253b3468396addd3bf72766d6d82710&h=libreoffice-5-2 Resolves: tdf#100460 queryContentCells doesn't count annotations... It will be available in 5.2.0.2. 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.
Caolán McNamara committed a patch related to this issue. It has been pushed to "libreoffice-5-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=28e3843433c3dfa04aae70c3c0516911ee80bf69&h=libreoffice-5-1 Resolves: tdf#100460 queryContentCells doesn't count annotations... It will be available in 5.1.5. 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.