[access-uk] Re: Excel problem
- From: "Peter Bentley" <bentleypdlists@xxxxxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Sat, 20 Feb 2010 19:32:11 -0000
Carol
I don't think the previous proposition based on the help information produced
by the Insert+F1 keystroke in JAWS can be correct. This was that if only one
vertical border is identified, then all the data fits within one page width. In
the example below there are six pages and so there should be five horizontal
page breaks but only one is identified in the help information .
It seems to me that I am back to the drawing board. How does a blind person
know for sure that data does not spill over on to a second print page width
ways.
Peter Bentley
1 horizontal full page breaks, 1 pages for print area.
1 vertical full page breaks, 0 pages for print area.
6 landscape page(s) can be printed from this worksheet.
Headers and Footers:
Center footer: Page ; current page number
The region spans a 1 through i 1
visible range is A1 through N26
128 of the 364 visible cells contain data.
The worksheet contains 9 cells with comments.
To list cells with comments visible in the active window use
Control+Shift+Apostrophe.
There are 5 worksheets in the 2009.xls workbook.
To move to a particular worksheet use Control+Shift+S.
Gridlines are on
Black Surrounding Border of active cell:
Thin
Grid Line
The current settings file name is C:\Documents and Settings\User\Application
Data\Freedom
Scientific\JAWS\11.0\Settings\enu\PersonalizedSettings\excel_2009.xls.JSI.
----- Original Message -----
From: Carol Pearson
To: access-uk@xxxxxxxxxxxxx
Sent: Saturday, February 20, 2010 4:17 PM
Subject: [access-uk] Re: Excel problem
Peter that appears to be my experience so, yes, appears to be right - but
I'll always stand corrected! <Smiles>
--
Carol
carol.pearson29@xxxxxxxxxxxxxx
On Twitter: http://twitter.com/songbird49a
---- Original Message ----
From: Peter Bentley
To: access-uk@xxxxxxxxxxxxx
Sent: Saturday, February 20, 2010 4:07 PM
Subject: [access-uk] Re: Excel problem
> Carol, thanks for your input.
>
> I do use JAWS.
>
> Would it be a correct conclusion to assume that if JAWS
> reports no vertical page breaks, then all the data fits
> into one page width? That does seem logical even if it is
> not right.
>
> Peter
> ----- Original Message -----
> From: Carol Pearson
> To: access-uk@xxxxxxxxxxxxx
> Sent: Saturday, February 20, 2010 2:24 PM
> Subject: [access-uk] Re: Excel problem
>
>
> Peter/George:
>
> George, I think Peter may be able to keep it simpler than
> this, that is, if using Jaws. If you use Jaws Key
> (Insert) plus F1 whilst in the spread sheet area you get
> some useful information as follows:
>
> This is the spreadsheet area.
> The worksheet name is Week 8 2010 and its number is 8.
> Printable Pages Information:
> no horizontal or vertical page breaks.
> 1 landscape page(s) can be printed from this worksheet.
> Headers and Footers:
> There are no headers or footers for this worksheet.
> The region spans a 7 through g 16
> visible range is F1 through J12
> 10 of the 60 visible cells contain data.
> There are 8 worksheets in the Person Weekly Time Sheets
> 2010.xls workbook.
> To move to a particular worksheet use Control+Shift+S.
> Gridlines are on
> Black Left Edge
> Thin
> Continuous
> Black Top Edge
> Thin
> Continuous
> Black Right Edge
> Medium
> Continuous
> Black Bottom Edge
> Thin
> Continuous
> The current settings file name is C:\Documents and
> Settings\CAROL PEARSON\Application Data\Freedom
> Scientific\JAWS\11.0\Settings\enu\PersonalizedSettings\excel_Person
> Weekly Time Sheets 2010.xls.JSI.
>
>
> List JAWS Hot Keys
> Press ESCAPE to close this message.
>
> If you go over the page boundary then (hopefully) it will
> be reported that 2 pages can be printed from that work
> sheet.
>
> In addition, I find the Page Setup useful. On the Page
> tab you can "fit to". I don't totally understand how
> much difference this makes to the size of the print, so
> use carefully; but it does help me to fit to one page of
> a spread sheet and people find it very acceptable.
>
> Peter, I don't know if you're using Jaws so it may be not
> quite as helpful as I'd hope, but I do trust it's of use!
>
> --
> Carol
> carol.pearson29@xxxxxxxxxxxxxx
> On Twitter: http://twitter.com/songbird49a
>
>
>
>
>
> Ins+---- Original Message ----
> From: George Bell
> To: access-uk@xxxxxxxxxxxxx
> Sent: Saturday, February 20, 2010 1:06 PM
> Subject: [access-uk] Re: Excel problem
>
> > Tricky one Peter, but here's one possible suggestion.
> > All it will do though is tell you if it requires one
> > page or more though.
> >
> > I'd suggest using a point size of 10 as that is
> > generally acceptable for most normally sighted people.
> >
> > Once you have set up your spreadsheet and entered all
> > data, autofit the contents of rows and columns. This
> > will hopefully ensure that all of the data can be seen,
> > and not truncated by a narrow column.
> >
> > If you now go to the Print function. You will see there
> > is an option to select what pages you wish to print as
> > well as a Print Preview Button.
> >
> > You could begin by look at the print pages option and
> > see if is says for example "1-2".
> >
> > The tricky bit is going to be to establish if that's two
> > pages one after the other meaning you have many rows -
> > roughly speaking over 50 on a page. Or if your data has
> > too many columns and prints two sheet side by side.
> >
> > George.
> >
> > From: access-uk@xxxxxxxxxxxxx
> > [mailto:access-uk@xxxxxxxxxxxxx] On Behalf Of Peter
> > Bentley
> > Sent: 20 February 2010 12:44
> > To: access-uk@xxxxxxxxxxxxx
> > Subject: [access-uk] Excel problem
> >
> > Using office 2000 but suspect the same principle would
> > apply to any version.
> >
> > Can anybody tell me how to check if an Excel table will
> > fit on to a page with ways. I realise that there is an
> > "auto fit" function but this can squash text to the
> > extent that the figures become unreadable so it is not
> > really the answer.
> >
> > Any suggestions appreciated.
> >
> > Peter Bentley
> >
> >
> > __________ Information from ESET NOD32 Antivirus,
> > version of virus signature database 4881 (20100219)
> > __________
> >
> > The message was checked by ESET NOD32 Antivirus.
> >
> > http://www.eset.com
>
>
> __________ Information from ESET NOD32 Antivirus, version
> of virus signature database 4882 (20100220) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4882 (20100220) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4883 (20100220) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
Other related posts:
