Navigation Menu

Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Excel: detect more formatting information in Excel #3583

Closed
nvaccessAuto opened this issue Oct 16, 2013 · 5 comments
Closed

Excel: detect more formatting information in Excel #3583

nvaccessAuto opened this issue Oct 16, 2013 · 5 comments

Comments

@nvaccessAuto
Copy link

Reported by vrdhn on 2013-10-16 17:17
Filing this as excel part of the ticket #1680

This is the excellent list prepared by Suman:

Formatting in Excel

written by: Suman Dogra
Date: August 29, 2013

number category:
typeof data:
genral
number
currency
date
time
percentage
fraction
scientific
text
special
custom

decimal
the number ofdecimalplaces to be notified

the type of currency to benotified
if fraction
towhat digit should benotified

if special the type ofcode to be notified

horizontal alignment-
genral
left affect
centre
right affect
fill
justified
centre across selection
distributing affect

effect number
vertical-
bottom
justified
distributed

wrappedtext
merged cell
degrees
text controlfromrightleft
text ornot
textdirection-
context
left to right
right to left

font name

font style-
regular
italics
bold
bold italic

font size

strike through
superscript
subscript

underline-
single
double
single accounting
double accounting

font color

cell border-
thin
double
medium
slanteddash dot
mediumdash dot
hair
dotted
dash dot dot
dash dot
dash

cell border color

celloutline
top
left
right
bottom
diagnol down

diagnol up

fill/cell shade
color
fill effects

pattern grouping
solid
horizontal stripe
thin horizontal stripe
75% grey
vertical stripe
thin vertical stripe
50% gray
reverse diagnol stripe
thin reverse diagnol stripe
25% gray
diagnol stripe
thin diagnol stripe
12.5% gray
diagonal cross patch
thin horizontal cross patch
6.25% gray
thinkdiagonalcross patch
6.25%gray

The work for this is being done on NVDA-India repo.

@nvaccessAuto
Copy link
Author

Comment 1 by jteh on 2013-10-16 21:13
This is a very large amount of info. I'm concerned that having this much info will make the report formatting command far less useful, since it is too much info to absorb and means you can't get a summary of the most important formatting info. Also, I'll wager most of this isn't directly visible to sighted users without using dialogs or toolbars. For example, number of decimal places and currency type are only reflected in the value of the cell, so this info is just as evident to a screen reader user as a sighted user without including it in formatting info. I also very much doubt the type of data is reflected for a sighted user. Anything that isn't obvious to any other user shouldn't be listed in this command. It is only really meant for info which can't be communicated as part of the value.

@nvaccessAuto
Copy link
Author

Comment 2 by sumandogra on 2013-11-28 07:49
Suggestion to modify the font info to be announced as follows:

ont name
font style
if underlined, the underline style
font size
font text color
background color
vertical alignment
horizontal alignment
wrapped or not
merged or not
text direction
degrees at which data is present in a cell
number format category
number ofdecimal places
type of cell border

@nvaccessAuto
Copy link
Author

Comment 3 by manish on 2013-11-28 09:35
Instead of having all this information spoken at once, can we have nvda pop a dialog that has this information? Most of the information suman has mentioned in her comment is actually evident to a sighted person simply by looking at the text but I doubt if hearing it as a single string will be easy for a screen reader user to absorb.

@nvaccessAuto
Copy link
Author

Comment 4 by manshulvbelani on 2015-06-01 10:47
I have started working on this issue and I wanted to know how should we move forward with presenting this info. Hearing it as a single string will be too much verbose for the user to absorb, so should we present all this in a dialogue box which displays on NVDA+f and the user can navigate up an down within the box to know these properties.

@jcsteh
Copy link
Contributor

jcsteh commented Jun 13, 2017

It's now possible for a user to browse font information by pressing NVDA+f twice. See #4908.

Most of these formatting items are now reported.

@ManshulBelani, I'm going to close this. If there are still formatting items you want to implement here, please file separate issues with full details, use cases, test cases, etc. Thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants