W
Wayne Knazek
In the example below, there is a list used as a pull down menu. Th
object
is, when the pull down is used, the "list" consists of "comments" mos
commonly used in the Comments field of a report. Some of the entries i
the
list are actually hyperlinks. (The 1st 4 in the list below ar
hyperlinks)
The pull down works fine. But when one of the hyperlinks is selected
it
becomes normal text when it goes into the comment cell.
What we want is for the customer to be able to go directly to the are
of
the spreadsheet with that specific information.
There is no way to know in advance what comments will be needed in an
particular row. It all depends on the data in the report. To save time
and
automate as much as possible, there are "standard" comments, ones mos
commonly used.
For example, if a particular row is for reporting "Position Deviation"
(which might be row 27 in one report, lines 2, 12 and 34 in another
etc.)
and if that Position Deviation exceeds tolerance, then there is
location in
the spreadsheet for calculating Bonus Tolerance.
So this particular comment might be . . .
OK with Bonus Tolerance. Click Here to go to "Bonus Tolerance Calcs"
As opposed to being a text line saying . . .
OK with Bonus Tolerance. See "Bonus Tolerance Calcs" section
This is an abreviated typical pull down list. 1 through 4 are suppose
to
be hyperlinks. In the actual reference list, the hyperlinks work fine
OK with Bonus Tolerance. Click Here to go to "Bonus Tolerance Calcs"
See Min Max section below Click Here to go to "MinMax"
See Normal Deviation section below. Click Here to go to "NormDev"
Verified with Calipers: Click Here to go to "MinMax"
Verified on Plate with indicator
Verified with Calipers
Verified with Mics
See Profile Charts Tab
Note: The entire line can be a link. It doesn't have to be just th
"Click
here".
Also, lookinvg ahead . . . I'm guessing that when I do get this t
work, when the hyperlink is entered, it'll become an actual link. I
there a way to "keep" the formatting of the cell the same. As in . .
the link won't come in as very tiny pitch, in blue, and underlined
object
is, when the pull down is used, the "list" consists of "comments" mos
commonly used in the Comments field of a report. Some of the entries i
the
list are actually hyperlinks. (The 1st 4 in the list below ar
hyperlinks)
The pull down works fine. But when one of the hyperlinks is selected
it
becomes normal text when it goes into the comment cell.
What we want is for the customer to be able to go directly to the are
of
the spreadsheet with that specific information.
There is no way to know in advance what comments will be needed in an
particular row. It all depends on the data in the report. To save time
and
automate as much as possible, there are "standard" comments, ones mos
commonly used.
For example, if a particular row is for reporting "Position Deviation"
(which might be row 27 in one report, lines 2, 12 and 34 in another
etc.)
and if that Position Deviation exceeds tolerance, then there is
location in
the spreadsheet for calculating Bonus Tolerance.
So this particular comment might be . . .
OK with Bonus Tolerance. Click Here to go to "Bonus Tolerance Calcs"
As opposed to being a text line saying . . .
OK with Bonus Tolerance. See "Bonus Tolerance Calcs" section
This is an abreviated typical pull down list. 1 through 4 are suppose
to
be hyperlinks. In the actual reference list, the hyperlinks work fine
OK with Bonus Tolerance. Click Here to go to "Bonus Tolerance Calcs"
See Min Max section below Click Here to go to "MinMax"
See Normal Deviation section below. Click Here to go to "NormDev"
Verified with Calipers: Click Here to go to "MinMax"
Verified on Plate with indicator
Verified with Calipers
Verified with Mics
See Profile Charts Tab
Note: The entire line can be a link. It doesn't have to be just th
"Click
here".
Also, lookinvg ahead . . . I'm guessing that when I do get this t
work, when the hyperlink is entered, it'll become an actual link. I
there a way to "keep" the formatting of the cell the same. As in . .
the link won't come in as very tiny pitch, in blue, and underlined