1. Turn on IAccessible2 support and run LibreOffice with NVDA.
2. Create a new Spreadsheet document.
3. Navigate around using the arrow keys.
Expected: Cells should be announced with their coordinates, and "blank" or something similar should be spoken to indicate the cell is empty.
Actual: The cell coordinates are announced, but the value is then spoken as "0". This would give the indication that there is a value of 0 in each cell, even though visually the cells definitely do not contain zeroes.
This should be changed so that there is a clear indication whether there is a 0 in a cell or the cell is blank. 0 could be the result of a calculation!
Confirming behavior on Windows builds
Build ID: 05dceb5d363845f2cf968344d7adab8dcfb2ba71
Build ID: 4bb7e9a1b0dd2f72609affde0170c0a2d4fff44b
TinderBox: Win-x86@42, Branch:master, Time: 2014-02-02_01:08:10
It picks up the '0' from its MSAA accValue, for the correctly assigned IAccessible2 role tableCell. So that default assignment probably needs to be adjusted from '0' to "empty"? Anyone up on what ODF 1.2 calls for in .ods formatting?
The other aspect of this is what would get assigned for that value with tableCells in Writer. Seems we are not there yet.
Looking at it, at present a table inserted there gets assigned an IAccessible2 role of 'paragraph', with MSAA accRole of clientArea but is also assigned the same accValue of '0', rather than "empty". So, unless there is a major structural issue with ODF .odt for writer that would need to be changed on both counts as well.
Should Calc really present "blank" or "empty" as the accValue? Wouldn't it make more sence to return an empty string and possibly let the screen reader take care of presenting it as empty?
Marco, Niklas, *,
Bug 84854 is disrupting QA of 32-bit builds, but working as best as possible with 32-bit builds on Windows, I think you are getting close with this.
Still have an issue in gaining focus to the Calc tablecells, but once focused the blank tablecells are no longer sounding a "zero".
Build ID: ae218f4895082ea9fca8f414a332bcf47045ba8c
TinderBox: Win-x86@39, Branch:master, Time: 2014-10-20_15:19:52
resolved fixed with http://cgit.freedesktop.org/libreoffice/core/commit/?id=55eca9dbb34aec8c435da91c0748453e3e097f1e
Caolán, Niklas could we back port to 4.3 for the 4.3.4 build?
Niklas Johansson committed a patch related to this issue.
It has been pushed to "libreoffice-4-3":
fdo#74441 [Accessiblity] Don't expose 0 for empty cells in Calc
It will be available in 4.3.3.
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:
Affected users are encouraged to test the fix and report feedback.
setting target to 4.3.4