Bug 155789

Summary:	ui,accessibility: cell format settings are not appreciated by screen readers
Product:	LibreOffice	Reporter:	ilya paschuk <ilusha.paschuk>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	stephane.guillou
Priority:	medium
Version:	5.2.0.4 release
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:

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 ***