Bug 115335 - Formatted cell text is not exposed to assistive technologies
Summary: Formatted cell text is not exposed to assistive technologies
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.0.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: accessibility, bibisectRequest, regression
: 155789 (view as bug list)
Depends on:
Blocks: a11y, Accessibility Number-Format
  Show dependency treegraph
 
Reported: 2018-01-31 16:15 UTC by Joanmarie Diggs
Modified: 2023-07-19 19:22 UTC (History)
5 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 Joanmarie Diggs 2018-01-31 16:15:33 UTC
Steps to reproduce:
1. Launch Calc
2. Type in a date in cell A1, e.g. 01/31/2018
3. Format the cell so the month name is displayed, e.g. January 31, 2018
4. Launch Accerciser and select the accessible associated with A1 in the panel on the left
5. In Accerciser's Interface Viewer, expand and view the "Text" content

Expected results: The displayed text ("January 31, 2018") would be exposed.

Actual results: The text which was entered ("01/31/2018") is exposed.

Impact: Orca doesn't present the contents on the screen.
Comment 1 Alex ARNAUD 2018-02-01 10:43:46 UTC
Hello all,

I can confirm the issue on Windows 10 with LibreofficeDev 6.1 and NVDA 2017.4.

FYI, I've followed a simple steps:
1) Open LibreOffice Calc
2) Type 25 on the A1 cell
3) Go for format, cell
4) Change the cell to currency
5) The cell content moves from 25 to $25

Result: NVDA reads 25.
Expected result NVDA should read $25.

Best regards.
Comment 2 Milton 2018-08-02 20:30:08 UTC
LibreOffice Calc version: 6.0.5.2
Ubuntu 18.04
bug confirmed
Milton.
Comment 3 QA Administrators 2019-08-03 03:05:32 UTC Comment hidden (obsolete)
Comment 4 Milton 2019-08-03 18:41:15 UTC
Hi all, bug still remains, LibreOffice Calc 6.2.5 Ubuntu 19.04 with Orca master. Milton
Comment 5 Milton 2022-06-02 08:17:04 UTC
bug confirmed LibreOffice 7.3 Ubuntu 22.04 Orca master
Comment 6 Milton 2023-03-24 19:11:33 UTC
bug is still present in LibreOffice 7.5.2, Ubuntu 22.04.2, Orca master
Comment 7 Stéphane Guillou (stragu) 2023-07-19 11:15:00 UTC
Marking as affecting all OSs, not just Linux.

Confirming that a formatted date is still read a "digits-slash-digits-slash-digits" by Orca in:

Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 77fca616e0bd79e0b405fd0b3543cf8e94e15df3
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

Already bad in 5.2.0.3.

Regression as Orca reads it as formatted in LO 4.0.6.2 (checked with libreoffice-64-releases bibisect repository, but quite a few version I can't run with gtk vcl and therefore can't check test with Orca).

Michael, what do you think?
Comment 8 Stéphane Guillou (stragu) 2023-07-19 11:16:57 UTC
*** Bug 155789 has been marked as a duplicate of this bug. ***
Comment 9 ady 2023-07-19 19:22:04 UTC
(In reply to Stéphane Guillou (stragu) from comment #8)
> *** Bug 155789 has been marked as a duplicate of this bug. ***

To make it easier to track (and not forget testing it), in reference to bug 155789:
(In reply to Stéphane Guillou (stragu) from bug 155789 comment #2)
> I think this is the same issue as bug 115335, but will be worth testing this
> specific formatting with both Orca and NVDA once it is fixed.