Description: When landing on a cell including a formula it is important to know if it contains a formula like prior versions does. Steps to Reproduce: 1. Type in cell A1 the formula =b1*b21. 2. Press Enter to land on cell A2 and Arrow Up to cell A1. Actual Results: Orca screen reader says 'zero'. Expected Results: like in Calc 7.4 and 7.3 Orca says 'Zero, Contains formula'. Reproducible: Always User Profile Reset: No Additional Info: Is it no more the case to have the announcement in 7.5.3 or has it to do like in: https://bugs.documentfoundation.org/show_bug.cgi?id=115335
Milton, the person who filed this bug, is an avid user of LibreOffice and he can't see. I offered to react on this "QA:needsComment" because reacting on a bug is difficult to him. Milton, wonders if "QA:needsComment" means that any sort of action is required from his side.
Milton adds that he uses version 7.5.4 on Ubuntu 22.04 LTS
Also, shouldn't be this bug a part of Bug 101912 (a11y, Accessibility) - [META] Accessibility (a11y) bugs and enhancements?
(In reply to pieter kristensen from comment #1) > Milton, wonders if "QA:needsComment" means that any sort of action is > required from his side. "QA:needsComment" is not for the original reporter to reply. It is a way to trigger comments from other participants. (In reply to pieter kristensen from comment #3) > Also, shouldn't be this bug a part of Bug 101912 (a11y, Accessibility) - > [META] Accessibility (a11y) bugs and enhancements? Someone from the QA Team might evaluate (at some point) whether this report should be related to some [META] report, in which case the [META] report will be listed in the "Blocks" field of this bug report. For this bug report to be reproduced, someone with a similar context would have to attempt the steps posted in the original description (i.e. comment 0). I will manually add "QA:needsComment" again, but I'm not sure it will remain as such. In any case, the next comment will automatically trigger its removal.
Thank you Milton for catching this regression. Thanks Pieter for following up. I can reproduce the issue in: Version: 7.5.4.2 (X86_64) / LibreOffice Community Build ID: 36ccfdc35048b057fd9854c757a8b67ec53977b6 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded And in recent master build: Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 66da786bdd4588b31755058acf46034c2056215c CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded And I confirm that it worked as expected in: Version: 7.4.7.2 / LibreOffice Community Build ID: 723314e595e8007d3cf785c16538505a1c878ca5 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Bibisected with linux-64-7.5 repository to first bad commit cea5af03761842273c4e14b12d87f40aca7bb782 which points to core commit: commit 7b20a1b0736825c9c934288428e6e581f79971e2 author Caolán McNamara <caolanm@redhat.com> Thu Aug 04 16:32:10 2022 +0100 committer Caolán McNamara <caolanm@redhat.com> Fri Aug 05 09:52:50 2022 +0200 tdf#117388 use native scrollbar under gtk in calc document Reviewed-on: https://gerrit.libreoffice.org/c/core/+/137810 Caolán, can you please have a look?
Now with Orca 46alpha the problem is solved. LibreOffice Calc 7.6.2.1.
(In reply to Milton from comment #6) > Now with Orca 46alpha the problem is solved. LibreOffice Calc 7.6.2.1. Thanks for the update! Likely fixed by this Orca commit: commit dd3f91de0bda82dba33917bb3234b28fd5ae915a Author: Joanmarie Diggs Date: Mon Nov 13 17:38:39 2023 +0100 Create and begin using table-related utilities that use Atspi directly. Also eliminate cruft found along the way. For instance, LO Calc now exposes the spreadsheet cell formula via object attribute, so we no longer have to try to find the input line via accessibility tree. And there was much rejoicing. See issue #300.