Bug 157616 - Calc does not update accessible information when cell edited
Summary: Calc does not update accessible information when cell edited
Status: RESOLVED DUPLICATE of bug 157568
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.1.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: accessibility, bibisected, bisected, regression
Depends on:
Blocks: a11y, Accessibility
  Show dependency treegraph
 
Reported: 2023-10-05 12:24 UTC by Michael Whapples
Modified: 2023-10-07 22:45 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Michael Whapples 2023-10-05 12:24:42 UTC
Description:
When I edit a cell is LibreOffice Calc, the accessible information is not updated and so it is not possible to read the new value with a screen reader.

Steps to Reproduce:
1. Launch LibreOffice Calc.
2. Navigate to a cell and just type.
3. Press enter to finish editing.
4. Move back to the cell which was edited and observe the accessible information

Actual Results:
The accessible information shows the content of the cell prior to editing.

Expected Results:
Accessibility information should be updated to reflect the new content after editing.


Reproducible: Always


User Profile Reset: No

Additional Info:
Tested with both NVDA screen reader and narrator screen reader.
[Information automatically included from LibreOffice]
Locale: en-GB
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: yes
Comment 1 Michael Whapples 2023-10-05 12:29:12 UTC
This was working correctly in LibreOffice 7.5.7, not tested with 7.6.0.
Comment 2 Michael Whapples 2023-10-05 12:31:15 UTC
This makes LibreOffice Calc very unusable with a screen reader.
Comment 3 ilya.y.komarov 2023-10-05 13:43:04 UTC
Everything works fine with NVDA screen reader in :

Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win
Locale: en-CA (en_CA); UI: en-US
Calc: CL threaded

And

Version: 24.2.0.0.alpha0+ (x86) / LibreOffice Community
Build ID: 2902ab24ecc5ffbf4907ea83b2028508b9de6364
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-CA (en_CA); UI: en-US
Calc: CL threaded.

But with the Narrator screen reader 

I can reproduce this bug in both versions.

1. Open LibreOffice 
2. Select cell
3. Type 12345
4. Press enter to finish editing
5. Select the previously edited cell
Expected result- The Narrator Screen reader pronounces numbers
6. Select the cell with 12345 info
7. Change info to ABCDE
8. Press enter
9. Select the cell again
Expected result -the Narrator screen reader should pronounce letters
Actual result-  the Narrator screen reader pronounces previous info 12345

Additional info:
Also sometimes the Narrator screen reader says no item in view when you select the cell.
I have to press Alt + Tab to open Libre Office again. After that, the screen reader is able to identify cells and the information in them.
Edition	Windows 10 Pro
Version	22H2
Installed on	‎2021-‎03-‎11
OS build	19045.3448
Experience	Windows Feature Experience Pack 1000.19044.1000.0
Comment 4 ilya.y.komarov 2023-10-05 14:00:50 UTC
Produced that bug again with the narrator screen reader.
I've found out that newly edited info is pronounced correctly only after you minimize the libre office and then get back to the program again ( or press Alt + Tab) 

1. select cell
2. type info 
3. press enter
4. select the same cell
5. change info
6. press enter
7. minimize the program
8. maximize the program

Result - New ifo is pronounced 

Additional info:

No item in view bug happens a lot.
Comment 5 Michael Weghorn 2023-10-06 08:22:45 UTC
There's also a related report for NVDA:
https://github.com/nvaccess/nvda/issues/15485

Bibisecting that one gives the same result as in tdf#157568:

    commit c8a8b8e3a03a02c7ee0b616eb728103fb7cefad0
    Author: Noel Grandin
    Date:   Mon Jun 12 20:02:19 2023 +0200

        tdf#155376 weakly cache ScAccessibleCell
Comment 6 Michael Weghorn 2023-10-07 22:45:18 UTC
This works fine again with the fix for tdf#157568 in place.

Thanks, Noel!

Pending backport for 7.6:
https://gerrit.libreoffice.org/c/core/+/157627

*** This bug has been marked as a duplicate of bug 157568 ***