[vicsireland] Re: Apache Open Office improved accessibility

  • From: "Gerry Ellis" <gerry.ellis@xxxxxxxxxxxxxxxxxx>
  • To: <vicsireland@xxxxxxxxxxxxx>
  • Date: Wed, 14 May 2014 17:42:25 +0100

Hi,

If you want to select a range of cells in Excel, Press <F5>, input the
starting and finishing cells with a colon in between and then hit <Enter>.
For example,inputting  A7:D9 selects the entire block within that range. 

To select an entire Row hold down the <Shift> key and hit <Space>. 

To select an entire Column hold down the <Control> key and hit <Space>.

For a list of 220 keyboard alternatives for Excel, see
https://exceljet.net/keyboard-shortcuts

The way that some of these keyboard combinations are presented in this list
are not accessible to us as they use graphics, but I think that there are
enough usable ones there for this resource to be of use.

I do not know how many of these will work in Open office.

 

Take care,

Gerry Ellis

If you don't know where you're going,
How will you know when you get there?

-----Original Message-----
From: vicsireland-bounce@xxxxxxxxxxxxx
[mailto:vicsireland-bounce@xxxxxxxxxxxxx] On Behalf Of Cearbhall O'Meadhra
Sent: 14 May 2014 13:41
To: vicsireland@xxxxxxxxxxxxx
Subject: [vicsireland] Re: Apache Open Office improved accessibility

Ronan,

I am currently looking at open Office calc with NVDA in the latest release.
I can confirm that it is performing almost completely as fluently as Excel.
I can enter data and code formulas perfectly. The editor is a bit dodgy when
moving the cursor from left to right across the text of a formula in edit
mode 2pressing F2). NVDA reads the entire formula perfectly when the cursor
is placed on the equal sign bypressing the home key. He solution of
selecting al the text and then editing in notepad provides a work around. I
notice that JAWS cannot do this at all. Also I find that JaWS has similar
trouble with Excel 2010 so I still count this as accessible in Open Office.

I found that I could create a fill series of my own and fill down a
repeating lsit. This is different from excel bu I was able to paly around
with this tool perfectly in Open Office.

On serious problem in Open Office was to do with formatting a cel or range
of cels. Highlighting is no problem but when I open the format function
(application key - f as in Excel) The category name is not readable.
However, NVDA states that the category is, say, "3 of 11". I tabbed away
from the field and then shited tab back again and NVDA was then able to
speak the category name. All the other fields in the format property were
adjustable and fully accessible.

I am not clear how to select a range. In excel, I do this my pressing F8 at
the start and pressing F5 to go to the last cell in the range. How should I
do this in Calc?

Another difficulty I had was with Help in Open Office. I found it impossible
to get an answer to my query. This was probably because I was using the same
methods that I use in Exce. I found it best to use Google to find the answer
that I needed. Again, this is sometimes the best way to get an answer when
using excel because so many of the Excel help screens are just not
accessible.

The alt- Page UP and alt-  page down commands work perfectly to switch
between worksheets within the same workbook in Calc.

I hope these observations hep.



All the best,

Cearbhall

m +353 (0)833323487 Ph: _353 (0)1-2864623 e: cearbhall.omeadhra@xxxxxxx



-----Original Message-----
From: vicsireland-bounce@xxxxxxxxxxxxx
[mailto:vicsireland-bounce@xxxxxxxxxxxxx] On Behalf Of Joshue O'Connor
Sent: 14 May 2014 12:22
To: vicsireland; Ronan McGuirk
Subject: [vicsireland] Re: Apache Open Office improved accessibility

Hi Ronan,

Thanks for the news. It would be great to hear more about how you find it.

Thanks

Josh

-----Original Message-----
From: Ronan McGuirk <ronan.p.mcguirk@xxxxxxxxx>
To: vicsireland <vicsireland@xxxxxxxxxxxxx>
Date: Wed, 14 May 2014 11:59:36 +0100
Subject: [vicsireland] Apache Open Office improved accessibility

> Hi all,
> 
> As many of you may know, Open Office is a free open source package 
> that is similar to MS Office.
> At the end of April, Apache Open Office 4.1 was released. This 
> included a major accessibility enhancement - it now uses iAccessible2 
> rather than relying on Java Access Bridge.
> 
> I have begun looking at  Open Office 4.1 with NVDA. First impressions 
> are good.
> 
> Has anyone else on this list had any experience with Open Office 4.1 ?
> 
> Best Regards,
> Ronan
> ===========================================================
> The vicsireland mailing list
> 
> To unsubscribe at any time send a mail to:
> 
> vicsireland-request@xxxxxxxxxxxxx
> 
> with the word "unsubscribe", without the quotes in the subject of the 
> message.
> 
> To contact the moderator send mail to:
> 
> tim.j.culhane@xxxxxxxxx
> 
> For mor information on the Visually Impaired Computer Society visit:
> 
> http://www.vicsireland.org
> 



Follow us on Facebook:
https://www.facebook.com/ncbiworkingforpeoplewithsightloss
Follow us on Twitter: www.twitter.com/ncbi_sightloss

Check-out NCBI's Micheal O Muircheartaigh appeal on the following link. 
http://youtu.be/25P2tiuCi0U

NCBI Group - CRO No 26293  CHY 20902
NCBI Services - CRO No 527862  CHY 4626
NCBI Retail - CRO No 527863  CHY 20619
NCBI Charitable Foundation - CRO No 527864 CHY 12673 


********************************************************************
Information in this email (including attachments) is confidential.  It is
intended for receipt and consideration only by the intended recipient.  If
you are not an addressee or intended recipient, any use, dissemination,
distribution, disclosure, publication or copying of information contained in
this email is strictly prohibited.  Opinions expressed in this email may be
personal to the author and are not necessarily the opinions of NCBI.

If this email has been received by you in error we would be grateful if you
could immediately notify the IT Service Desk by telephone at +353 1 8821911
or by email to service.desk@xxxxxxx and thereafter delete this e-mail from
your system

********************************************************************


===========================================================
The vicsireland mailing list

To unsubscribe at any time send a mail to:

vicsireland-request@xxxxxxxxxxxxx

with the word "unsubscribe", without the quotes in the subject of the
message. 

To contact the moderator send mail to:

tim.j.culhane@xxxxxxxxx

For mor information on the Visually Impaired Computer Society visit:

http://www.vicsireland.org

===========================================================
The vicsireland mailing list

To unsubscribe at any time send a mail to:

vicsireland-request@xxxxxxxxxxxxx

with the word "unsubscribe", without the quotes in the subject of the
message. 

To contact the moderator send mail to:

tim.j.culhane@xxxxxxxxx

For mor information on the Visually Impaired Computer Society visit:

http://www.vicsireland.org


===========================================================
The vicsireland mailing list

To unsubscribe at any time send a mail to:

vicsireland-request@xxxxxxxxxxxxx

with the word "unsubscribe", without the quotes in the subject of the message. 

To contact the moderator send mail to:

tim.j.culhane@xxxxxxxxx

For mor information on the Visually Impaired Computer Society visit:

http://www.vicsireland.org

Other related posts: