[vicsireland] Re: Apache Open Office improved accessibility
- From: "Cearbhall O'Meadhra" <cearbhall.omeadhra@xxxxxxx>
- To: <vicsireland@xxxxxxxxxxxxx>
- Date: Sun, 18 May 2014 01:25:47 +0100
Hi Barry and Ronan,
I have been mulling over the differences between Apache Open Office and
Excel and I realise that the section function is covered in Calc.
Step Excel Calc
Select first cell position cursor in desired cel position cursor in
desired cell
Start range selection F8 No action
Move to last cell in range f5 type cell reference shift-F5; press
"end"; type":" followed by target cell reference
Select range Range is now selected Range is now selected
From the above, you can see that the shift F5 in Calc combines the functions
of F8 and F5 in Excel to achieve the same result. The extra two keystrokes
in Calc (moving to the right of the first element of the desired range
with the "end" key and then typing a ":") is matched by the earlier use of
F8 in Excel. In both cases, it is necessary to type in the last cell of the
range.
The next selection difference is in the fill down and right functions. Excel
offers control-D and control -R once the range is selected. Calc offers its
fil functions after pressing alt-e-I and arrowing around the fill dialog
that results. When you know the fill function you can add the shortcut for
the desired function thus:
Fill down: alt-e-i-d and right: alt-e-i-r. This is not too tedious a
manoeuvre, I think.
I found a useful comparison of the operation of Calc in comparison to Excel
that you might like to see. Rather than attach the page I have saved it in
my Drop Box:
https://www.dropbox.com/s/u1vcc3hxh0epv6d/Differences%20in%20Use%20between%2
0Calc%20and%20Excel%20-%20Apache%20OpenOffice%20Wiki.mht
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 Ronan McGuirk
Sent: 15 May 2014 15:29
To: vicsireland@xxxxxxxxxxxxx
Subject: [vicsireland] Re: Apache Open Office improved accessibility
Hi Barry and Cearbhall,
Barry, F5 works well as you describe.
If you hit F5 then edit the column destination, then tab and edit the row
destination and press enter. This jumps you to the correct destination.
One thing to watch for is that the current row and column are already
populated and you need to delete/overwrite them when entering the new
location.
Control shift F5 works for selecting ranges. Simply type the range into the
name box for example A3:B20 and press enter. NVDA doesn't verbally confirm
that these are selected but if you hit control c and then move to a
destination area and hit control v it seems to copy and paste correctly. For
some reason, Calc gives a warning that the destination area is already
populated, even when it isn't, before letting you paste, but it does it
correctly nonetheless.
All, in all, so far, I think Open Office 4.1 is looking very
encouraging from an accessibility point of view.
I think these issues I am experiencing relate more to learning and
familiarity rather than to accessibility...
Ronan
On 15/05/2014, Barry McMullin <barry.mcmullin@xxxxxx> wrote:
> Cearbhall asks:
>
>> My next question is how to jump to a specific cell?
>
> I'm not aware of any really easy way of doing this; but in libreoffice
> (and I assume openoffice is likely the same, as libreoffice is a fork
> from openoffice), you can press F5 to open a so-called "navigator"
> dialogue. While this has quite complex potential functionality, the
> simplest facility is to fill in a "row" field and a "column" field and
> press enter. You may have to press F5 again to close the navigator
> dialogue. I'm hoping those two fields are labelled in a way that you
> can find them; for me, when you open the dialogue, the cursor is
> already in the row field, and one tab brings it to the column field.
> It's all obviously quite clumsy, but may be worth while for jumping
> "far"
> in the sheet.
>
> Good luck,
>
> - Barry.
>
> --
> Professor Barry McMullin,
> Executive Dean, Faculty of Engineering and Computing Dublin City
> University
> phone: +353-1-700-5432
> web: http://www.eeng.dcu.ie/~mcmullin/
> skype: barrymcmullin-dcu.ie
> room: L116
>
> ======================================================================
> ===== Disclaimer Text Required by my Employer:
>
> "This email and any files transmitted with it are confidential and are
> intended solely for use by the addressee. Any unauthorised
> dissemination, distribution or copying of this message and any
> attachments is strictly prohibited. If you have received this email in
> error please notify the sender and delete the message. Any views or
> opinions presented in this email may solely be the views of the author
> and cannot be relied upon as being those of Dublin City University.
> E-mail communications such as this cannot be guaranteed to be virus
> free, timely, secure or error free and Dublin City University do not
> accept liability for any such matters or their consequences. Please
> consider the environment before printing this Email."
> --
>
>
> *Email Disclaimer"This e-mail and any files transmitted with it are
> confidential and are intended solely for use by the addressee. Any
> unauthorised dissemination, distribution or copying of this message
> and any attachments is strictly prohibited. If you have received this
> e-mail in error, please notify the sender and delete the message. Any
> views or opinions presented in this e-mail may solely be the views of
> the author and cannot be relied upon as being those of Dublin City
> University. E-mail communications such as this cannot be guaranteed to
> be virus-free, timely, secure or error-free and Dublin City University
> does not accept liability for any such matters or their consequences.
> Please consider the environment before printing this e-mail."Séanadh
> Ríomhphoist"Tá an ríomhphost seo agus aon chomhad a sheoltar leis faoi
> rún agus is lena úsáid ag an seolaí agus sin amháin é. Tá cosc iomlán
> ar scaipeadh, dháileadh nó chóipeáil neamhúdaraithe ar an
> teachtaireacht seo agus ar aon cheangaltán atá ag dul leis. Má tá an
> ríomhphost seo faighte agat trí dhearmad cuir sin in iúl le do thoil
> don seoltóir agus scrios an teachtaireacht. D'fhéadfadh sé gurb iad
> tuairimí an údair agus sin amháin atá in aon tuairimí no dearcthaí atá
> curtha i láthair sa ríomhphost seo agus níor chóir glacadh leo mar
> thuairimí nó dhearcthaí Ollscoil Chathair Bhaile Átha Cliath. Ní
> ghlactar leis go bhfuil cumarsáid ríomhphoist den sórt seo saor ó
> víreas, in am, slán, nó saor ó earráid agus ní ghlacann Ollscoil Chathair
Bhaile Átha Cliath le dliteanas in aon chás den sórt sin ná as aon iarmhairt
a d'eascródh astu.
> Cuimhnigh ar an timpeallacht le do thoil sula gcuireann tú an
> ríomhphost seo i gcló."*
>
> 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: