[vicsireland] Re: Apache Open Office improved accessibility
- From: Ronan McGuirk <ronan.p.mcguirk@xxxxxxxxx>
- To: vicsireland@xxxxxxxxxxxxx
- Date: Mon, 19 May 2014 09:47:50 +0100
Hi Cearbhall,
I think this is a good summary of similarities and differences in
selecting a range.
I think I will try to use Writer and Calc as my word processor and
spreadsheet for the next few weeks and keep a log of issues as they
emerge. I suspect that it is only in daily use that it will be clear
to me whether Open Office is a viable solution.
However, I am still optimistic.
Ronan
On 18/05/2014, Cearbhall O'Meadhra <cearbhall.omeadhra@xxxxxxx> wrote:
> 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
>
>
==========================================================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: