From a tree-dump of a Writer document in which the table cell formula was A1+A2: --> ATSPI_ROLE_TABLE_CELL (0x7f892c0bf7c0) NAME: 'A3' DESCRIPTION: 'A3' [...] ATTRIBUTES: Formula=<94789629766128>+<94789629801536> Orca has a command to present the table cell formula (Orca+Equal as of today in Orca's main branch). It presents the value of the object attribute as-is. * Works fine in Calc * Works fine in Writer when the formula is literal (e.g. =1+2) * Doesn't work fine when the formula contains cell references as shown above Michael, hopefully this is easy to solve. Thanks in advance!
Thanks for the report, Joanie. Pending change series: https://gerrit.libreoffice.org/c/core/+/197604 This also includes changes to only report the "Formula" object attribute for Calc and Writer cells if a formula is actually set, i.e. no longer an empty one. One remaining difference between Writer and Calc is that Writer uses "<A1>" as a cell reference while Calc uses "A1" (without the brackets), but that is not specific to a11y and is the same in the UI.
Michael Weghorn committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/cc5e445092347bfcef8fb70bc0e6008c107fd0bc tdf#170338 sw a11y: Add helper to get table's SwTabFrame It will be available in 26.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Michael Weghorn committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/1579423b8756a299ea1a9a523d53d2078c689836 tdf#170338 sw a11y: Don't report empty "Formula" attribute It will be available in 26.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Michael Weghorn committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/324a9bbbfa6f2b0252ba34f090c9d16d7615dc41 tdf#170338 sc a11y: Don't report empty "Formula" attribute It will be available in 26.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Michael Weghorn committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/19182801fcb67fde8b4bdd4715c2a5388681eca6 tdf#170338 sw a11y: Use cell names in formula It will be available in 26.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.