Bug 155789 - ui,accessibility: cell format settings are not appreciated by screen readers
Summary: ui,accessibility: cell format settings are not appreciated by screen readers
Status: RESOLVED DUPLICATE of bug 115335
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:
Depends on:
Blocks:
 
Reported: 2023-06-12 13:53 UTC by ilya paschuk
Modified: 2023-07-19 11:16 UTC (History)
1 user (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 ilya paschuk 2023-06-12 13:53:31 UTC
steps to reproduce:
1) start a NVDA screen reader
2) start a libreoffice calc and create a new table
3) type "=1/3" in any cell
4) press ctrl+1 to open a cell format dialog
5) switch format to fraction and press "ok"


expected:
screen reader should read cell content as displayed, as "1/3"

actual:
screen reader steal uses default format and outputs as 0,33333...

notes:
1) if after the steps I press ctrl+c on that cell, the "1 / 3" is copied to my clipboard. this confirms that format was really changed.
2) if you will fix the bug, please add a setting to revert the old behavior to accessibility settings.


my screen reader: nvda 2023.1
Comment 1 Stéphane Guillou (stragu) 2023-06-22 12:59:02 UTC
Thank you for the report, Ilya!

Confirmed using Orca screen reader on Ubuntu 20.04 with:

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

Using e.g. percent format reads the cell contents as a percentage.

Regression, as it was read out as "1/3" in OOo 3.3, but a decimal since at least 5.2:

Version: 5.2.0.1
Build ID: fcbcb4963bda8633ba72bd2108ca1e802aad557d
CPU Threads: 8; OS Version: Linux 5.15; UI Render: default; 
Locale: en-AU (en_AU.UTF-8)
Comment 2 Stéphane Guillou (stragu) 2023-07-19 11:16:57 UTC
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.

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