WebAIM - Web Accessibility In Mind

E-mail List Archives

Re: Accessible spreadsheets

for

From: Brandon Keith Biggs
Date: Jun 24, 2018 5:41PM

Hello,
I extensively use Google Sheets with NVDA.
I have used pivot tables, but not very much. Dropdowns are very accessible.
There are a few things that are not optimal, like selecting cells when you
start typing a formula, but you can just ignore that and keep typing.
You can set row and column headers in the accessibility menu. You can also
read row and column headers with the ctrl+alt+shift+c and r commands.

Excel is OK, but I found it too slow for small sheets. You can assign
headers for columns and rows by pressing NVDA+shift+r and c.

I don't think widgets are very accessible in excel.
Thanks,


Brandon Keith Biggs <http://brandonkeithbiggs.com/>;

On Sun, Jun 24, 2018 at 1:47 PM, Ryan E. Benson < <EMAIL REMOVED> >
wrote:

> > assign header cells
>
> With newer versions of excel you should be able to select the table and
> data, then use the "format as a table" function on the home tab. If you
> select the "table has headers option, the top row should become effectively
> THs. andhave an experience like you would in Word. You can't mark row
> headers though.
>
>
> --
> Ryan E. Benson
>
> On Fri, Jun 22, 2018 at 1:43 PM, Birkir R. Gunnarsson <
> <EMAIL REMOVED> > wrote:
>
> > Quite accessible with a screen reader, Jaws in particular.
> > YOu can browse spreadsheets by cels, review formulas and comments with
> > keystrokes, assign header cells (Jaws only), name and move worksheets
> > around (I think Jaws only, but not sure), you can get a list of
> > objects (at least in Jaws) that enable you to e.g. click buttons to
> > run scripts (I used to work full-time writing VBA scripts for massive
> > risk monitoring applications for a bank, the fact that the bank went
> > under is not my fault, I promise).
> >
> > There are some difficulties navigating custom dropdowns in Excel (have
> > not tested with latest version, both in Jaws and NVDA.
> > I've not been able to create or use pivot tables.
> >
> > Hope this helps, if you just want a number I'd say 85% with Jaws, 75%
> with
> > NVDA.
> >
> >
> >
> > On 6/22/18, <EMAIL REMOVED> < <EMAIL REMOVED> > wrote:
> > > The recent thread about Sec. 508 regarding Excel prompted this
> question:
> > >
> > >
> > >
> > > How accessible are spreadsheets with current assistive technologies?
> > >
> > >
> > >
> > > I'm sure the answer will be "it depends," but let's take 2 basic
> samples:
> > >
> > >
> > >
> > > 1. A spreadsheet of just plain data, such as a directory with names,
> > > addresses and emails in rows and columns.
> > > 2. A spreadsheet with common, basic formulas, such as summation of a
> > > column of numbers.
> > >
> > >
> > >
> > > - - -
> > >
> > > Bevi Chagnon, founder/CEO | <EMAIL REMOVED> <mailto: <EMAIL REMOVED> >
> > >
> > > - - -
> > >
> > > PubCom: Technologists for Accessible Design + Publishing
> > >
> > > consulting . training . development . design . sec. 508 services
> > >
> > > Upcoming classes at www.PubCom.com/classes
> > >
> > > - - -
> > >
> > >
> > >
> > >
> > >
> > > > > > > > > > > > > > >
> >
> >
> > --
> > Work hard. Have fun. Make history.
> > > > > > > > > >
> > > > >