John,
No attachments in your message. Could you try again?
I note that you did try to define a name in Calc. Are you saying that you
exported the file to Excel but the defined name did not travel with the file?
what exactly happened?
Are these the steps that you tried:
How do you name a cell in OpenOffice Calc?
Select one or more cells and choose Insert → Names → Define. Type the name,
click Add , and click OK .
All the best,
Cearbhall
m +353 (0)833323487 Ph: _353 (0)1-2864623 e: cearbhall.omeadhra@xxxxxxx
-----Original Message-----
From: fb-exchange-bounce@xxxxxxxxxxxxx <fb-exchange-bounce@xxxxxxxxxxxxx> On
Behalf Of John Acton
Sent: Friday, November 26, 2021 2:32 PM
To: fb-exchange@xxxxxxxxxxxxx
Subject: [fb-exchange] Re: Reading Column and Row headings in Excel further
notes
Hi Cearbhall
I tried the define name with LibreOffice Calc but the nvda did not work. So I
decided to send you this simplified excel file so that you can add the
defined name and test with nvda. The file contains real budget figures so I
would appreciate that you treat this file confidentially. The bottom righy
cell is F21. It should be straightforward for me but not so without excel
and nvda on the one computer.
Regards
John
On Thu, 25 Nov 2021 at 12:07, Cearbhall O'Meadhra <
cearbhall.omeadhra@xxxxxxx> wrote:
Hi all and Mary,
I described the simple operation of setting rows and column headings
using the JAWS keystrokes JAWS-key+control+alt+c or
JAWS-key+control+alt+r. These are enabled in JAWS by default.
For NVDA users the keystrokes are NVDA-key+shift +c or NVDA-key+shift+r.
These are not enabled by default so the user must make sure both "Tables"
and
"Row/column headers" are checked in the tables grouping In Document
settings (NVDA+control+d) to enable this feature.
Both of the above only report rows and columns that are filled with
data and stop at the first blank cell in any row or column.
Excel has a built-in feature using "Defined Names" that is easy to
apply but may seem more complicated at first. JAWS users will need to
have " define names override" set to "off".
NVDA users can access Define Names by default.
Procedure:
* First you must identify the bottom rightmost cell that you want to
define.
Then, position the cursor on the first cell in the top left corner of
the worksheet where your column and row headings intersect.
* Now open "Define Names", by pressing control+F3 followed by the
letter "n"
for "new".
This opens on the edit box where you can type the new name.
*In this box type any name ie "beads", "title1", "Cars" ... followed
immediately by two full stops followed by the cell coordinates of the
bottom righthand corner of the area you want to cover The result
should look like: "Cars..Z25"
* Tab severaltimes to OK if that is available or simply close the
define names dialogue.
Now both JAWS and NVDA will report the column headings or the row
headings when your cursor is anywhere within the area you are
covering. This will keep going even if there are blank rows or columns
within the area.
Here is a friendly video that might make it clearer. It uses JAWS as
the screen reader but it is the same for NVDA without the need to set
the override.
https://www.youtube.com/watch?v=Uv2K2lv9-jY
All the best,
Cearbhall
m +353 (0)833323487 Ph: _353 (0)1-2864623 e:
cearbhall.omeadhra@xxxxxxx
--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
===========================================================
The fb-exchange mailing list
Manage account,
List Page: https://www.freelists.org/list/fb-exchange
Subscribe: mailto:fb-exchange-request@xxxxxxxxxxxxx?Subject=subscribe
Unsubscribe:
mailto:fb-exchange-request@xxxxxxxxxxxxx?Subject=unsubscribe
Archive: https://www.freelists.org/archive/fb-exchange
Administrative contact: insight@xxxxxxxxxxxxxxxxxxxx
===========================================================
