[vicsireland] Re: Apache Open Office improved accessibility
- From: "Gerry Ellis" <gerry.ellis@xxxxxxxxxxxxxxxxxx>
- To: <vicsireland@xxxxxxxxxxxxx>
- Date: Thu, 15 May 2014 08:29:19 +0100
Hi, Ronan,
There is a WIKI on Open Office. I don't know if you have come across it.
Each section of the WIKI refers to one element of Open Office, i.e. writer,
calc, etc. Apendix A of each refers to keyboard shortcuts. The one for calc
is found at:
https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/K
eyboard_Shortcuts
Some specific shortcuts for selecting data are found at:
https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/N
avigation_and_selection_shortcuts
There is also the option throughout Open Office of defining your own
shourtcuts.
A good source for shortcuts in general is found at:
www.keyxl.com
I hope this is of help.
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 Ronan McGuirk
Sent: 14 May 2014 22:15
To: vicsireland@xxxxxxxxxxxxx
Subject: [vicsireland] Re: Apache Open Office improved accessibility
Hi Folks,
Gerard, I have looked at Open Office Writer and calc but not at the
database yet. So far, the accessibility of Writer and Calc look very
good. Cearbhall seems to have had more in-depth experience with
Calc.
With regard to the Excel shortcut keys...
Many of these are the same in Open Office but not all.
I am not sure as yet as to how to select a range by shortcut key. I am
guessing that it should be possible with some option under F5 or
control shift F5, but at a quick glance, I haven't
Best regards,
Ronanspotted how to do it yet.
On 14/05/2014, Gerry Ellis <gerry.ellis@xxxxxxxxxxxxxxxxxx> wrote:
> 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
>
>
===========================================================
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: