what group for "bug" finds

[OutsideObserver]

Hey, I found a stupidity bug (yes it was stupid to have missed it).

When you detail a hyperlink, all is fine. When you format the
hyperlink, all is fine.

IF you subsequently edit the hyperlink in any way, the formatting gets
reset to the STUPID MS default, which should ALSO be something that we
can set down as OUR standard defaults.

Another one is the validation comments. They too should be something
the workbook author can set, and the default setting should also be able
to be modified.

The bug alone wastes hours when one has a sheet that was copied as a
template to other sheets, and then each hyperlink has to be edited for
the pointer, and THEN one has to re-edit the damned thing to put the
formatting back in place!

Fix it, you overpaid, undereducated (not talking about your degree, but
more likely how you got it) dopes!

The big question is how does something so blatant get overlooked by the
overpaid dopes that are there to examine the software and catch the
mistakes? They should have folks like me in place to catch them. That
appears obvious.

 

[Harlan Grove]

OutsideObserver <Stand And (e-mail address removed)>
wrote...
....

IF you subsequently edit the hyperlink in any way, the formatting gets
reset to the STUPID MS default, which should ALSO be something that we
can set down as OUR standard defaults.

You need to change the Hyperlink and Followed Hyperlink styles.
Excel's behavior is poorly documented, and it might not be ideal, but
it's not a bug. This does mean you can't use different hyperlink
formatting in the same workbook. Again, maybe not ideal, but not a
bug.

Another one is the validation comments.  They too should be something
the workbook author can set, and the default setting should also be able
to be modified.

....

?

Do you mean Data Validation input and error messages? They're set,
respectively, in the Input Message and Error Alert tabs of the Data
Validation dialog. They can be set specific to each cell for which
data validation is applied.

 

[OutsideObserver]

Do you mean Data Validation input and error messages? They're set,
respectively, in the Input Message and Error Alert tabs of the Data
Validation dialog. They can be set specific to each cell for which
data validation is applied.

I know how to set the message. There is no facility to set the
formatting of the message box. That is what I want to do.

As far as the hyperlink error goes, I found it to be faster to just
cut-and-special paste formats only from a nearby cell with the desired
formatting, than the hand select the font, size, and color for my
hyperlink. I find it very annoying that a mere hyperlink edit RESETS
the formatting for the text that the hyperlink is tied to. Funnier still
is that if I use a shape or image to make a hyperlink, it does nothing to
modify those. So why should it modify a text pointer? That is just
lame.

 

[Harlan Grove]

I know how to set the message.  There is no facility to set the
formatting of the message box.  That is what I want to do.

That was unclear before. This could be classed as a design mistake or
oversight but not a bug.

As far as the hyperlink error goes, I found it to be faster to just
cut-and-special paste formats only from a nearby cell with the desired
formatting, than the hand select the font, size, and color for my
hyperlink.  I find it very annoying that a mere hyperlink edit  RESETS
the formatting for the text that the hyperlink is tied to. Funnier still
is that if I use a shape or image to make a hyperlink, it does nothing to
modify those.  So why should it modify a text pointer?  That is just
lame.

Lame perhaps, but it's intentional functionality, so not a bug. I
figure Excel's treatment of hyperlinks is roughly like that of
conditional formatting where the condition is whether the cell
contained a hyperlink. I also figure that the goal is consistency in
displaying hyperlinks.

To repeat, you can change hyperlink formatting by changing the
Hyperlink and Followed Hyperlink styles, and it doesn't take much
effort to so.

As for shapes and images, they're unaffected by conditional formatting
(at least so far), and that's partly why I speculate that hyperlink
formatting may be related to conditional formatting.

 

[OutsideObserver]

That was unclear before. This could be classed as a design mistake or
oversight but not a bug.


Lame perhaps, but it's intentional functionality, so not a bug. I
figure Excel's treatment of hyperlinks is roughly like that of
conditional formatting where the condition is whether the cell
contained a hyperlink. I also figure that the goal is consistency in
displaying hyperlinks.

To repeat, you can change hyperlink formatting by changing the
Hyperlink and Followed Hyperlink styles, and it doesn't take much
effort to so.

As for shapes and images, they're unaffected by conditional formatting
(at least so far), and that's partly why I speculate that hyperlink
formatting may be related to conditional formatting.

I should also be able to concatenate a hyperlink as well. Can I do
that? If so, I would be able to construct the hyperlink which I
currently copy then edit, from sheet to sheet, so it would work
regardless of which sheet I put it on.

I also find no facility to construct a string using the sheet name.

I am just too unfamiliar with the office function string construction,
and then where VB strings need to be used, which I am even less familiar
with.

 

[Harlan Grove]

OutsideObserver <Stand And (e-mail address removed)>
wrote...
....

I should also be able to concatenate a hyperlink as well. Can I do
that? If so, I would be able to construct the hyperlink which I
currently copy then edit, from sheet to sheet, so it would work
regardless of which sheet I put it on.

If you use the HYPERLINK function, it's arguments can be any valid
string-valued expressions.

I also find no facility to construct a string using the sheet name.

Meaning, e.g., you want a formula that returns the name of the cell's
containing worksheet? IOW, a formula entered in some cell in a
worksheet named FOOBAR that would return FOOBAR? That's something
Excel does do poorly. If the workbook has been saved, I find it most
efficient to define the name WSN referrring to the formula

=MID(CELL("Filename",!$1:$65536),FIND("]",CELL("Filename",!$1:$65536))
+1,32)

If the workbook hasn't been saved, VBA is the better option.

 

[OutsideObserver]

Meaning, e.g., you want a formula that returns the name of the cell's
containing worksheet? IOW, a formula entered in some cell in a
worksheet named FOOBAR that would return FOOBAR? That's something
Excel does do poorly. If the workbook has been saved, I find it most
efficient to define the name WSN referrring to the formula

=MID(CELL("Filename",!$1:$65536),FIND("]",CELL("Filename",!$1:$65536))
+1,32)

If the workbook hasn't been saved, VBA is the better option.

You just allowed me to see what I need.

I will just add the sheet name to a cell on my sheet. I may even name
the range so I can call it that way as well. Or try to, that is. I am
experimenting with methods of keeping a user from overwriting their
template. I always save a new book including the date in the file name
so that I keep the previous... or template sheet. So I have a directly
full of time sheets, for instance, where each one is the same, except for
the filename, and the data in the cells.

I was thinking of making a button for that, since I use a known date, my
week starting date.

I was also thinking of making a button to clear the contents of the
sheet,as far as the user editable fields go.

Can that be done without bring macros and VB into it?

 

[OutsideObserver]

That was unclear before. This could be classed as a design mistake or
oversight but not a bug.

I DID find a bug of sorts though.

If one clicks on the tab for a sheet that contains a pivot table, the
cursor goes dead as far as selecting a different sheet tab or many other
'handles', until one clicks within a cell on the sheet with the table,
and then a different cell... THEN one can select a different sheet tab.

So, it goes into alternate sheet limbo whenever a pivot table sheet is
selected until one navigates about on the sheet a bit. I was guessing
while it figures out the pivot table, but it can't be that slow doing
that. This 'outage' lasts several seconds.