| Summary: | Can not query sheet cells with annotations | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Andreas Säger <villeroy> |
| Component: | Calc | Assignee: | Caolán McNamara <caolan.mcnamara> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | h3734236, ilmari.lauhakangas |
| Priority: | medium | Keywords: | bisected, regression |
| Version: | 5.1.3.2 release | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | target:5.3.0 target:5.2.0.2 target:5.1.5 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | Some annotated cells and Basic macro | ||
|
Description
Andreas Säger
2016-06-17 15:56:44 UTC
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. 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. |