Excel2003 "This font style name does not exist"

User avatar
ChrisGreaves
PlutoniumLounger
Posts: 15498
Joined: 24 Jan 2010, 23:23
Location: brings.slot.perky

Excel2003 "This font style name does not exist"

Post by ChrisGreaves »

See also Excel2003 - Copying styles

Instead of being smart and checking Eileen's Lounge for a technique to copy a style (see link above), I decided that it couldn't be done, and stumbled off to create a new style. I wanted a strike-through style that corresponds to my Word2003 character style "csStrikethrough", and just as in Word2003 I wanted it to have ONLY the characteristic of strike-through.
csStrikethrough01.png
To my surprise, although in Excel styles can be accumulated, components of styles can not be so readily accumulated.
In the screenshot above I am not allowed to create an Excel2003 style that has ONLY the characteristic of a strike-through; I have to include a Font Style name, whatever that is (it is, I assume, not a typeface name, for I have chosen Algerian)
csStrikethrough02.png
As far as I could see, the style csStrikethrough must have a typeface name, a Font style, and a Size before it can have the characteristic of strike-through.

At this point in a diatribe I usually paste in a boilerplate script about how the MSExcel team did not communicate with the MsWord team, but I must be mellowing in my old age. It is possible that the Excel team working on styles had finished early and gone home before the MSWord team got around to devising a better way of implementing styles.

Cheers, Chris
You do not have the required permissions to view the files attached to this post.
Last edited by ChrisGreaves on 01 Jul 2022, 17:31, edited 1 time in total.
An expensive day out: Wallet and Grimace

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Excel2003 "This font style name does not exist"

Post by HansV »

Your link doesn't work. It should be to https://eileenslounge.com/viewtopic.php?f=27&t=34239
ChrisGreaves wrote:
01 Jul 2022, 17:13
It is possible that the Excel team working on styles had finished early and gone home before the MSWord team got around to devising a better way of implementing styles.
If so, they still haven't returned to work in 2022.
Keep in mind that Excel was not intended to be a full-blown word processor. It is a spreadsheet application with some text formatting capabilities.
Best wishes,
Hans

User avatar
ChrisGreaves
PlutoniumLounger
Posts: 15498
Joined: 24 Jan 2010, 23:23
Location: brings.slot.perky

Re: Excel2003 "This font style name does not exist"

Post by ChrisGreaves »

HansV wrote:
01 Jul 2022, 17:26
Your link doesn't work. It should be to https://eileenslounge.com/viewtopic.php?f=27&t=34239
Thank you Hans; fixed!
If so, they still haven't returned to work in 2022.
Thanks too for this heads-up; I think I will stick with 2003 for a little while longer.
Keep in mind that Excel was not intended to be a full-blown word processor. It is a spreadsheet application with some text formatting capabilities.
Be that is it may :evilgrin: the Excel team was clearly ahead of MSWord in dreaming up additive styles, and each of the six "style includes" areas (except arguably Patterns and Protection) consists of what seem like arbitrary groups of components.

In the case of Number, "decimal places", "1000 separator" and "negative numbers" are components, so I can't think of a rational reason for not being able to split "Font", "Font style" and "Size".
'Border" and "Pattern" are common features of styles in both the word and spreadsheet processors. :grin:
Cheers, Chris
An expensive day out: Wallet and Grimace

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Excel2003 "This font style name does not exist"

Post by HansV »

You might select File > Feedback > I have a suggestion.

Oh wait, you have Office 2003... :stupidme:
Best wishes,
Hans

User avatar
ChrisGreaves
PlutoniumLounger
Posts: 15498
Joined: 24 Jan 2010, 23:23
Location: brings.slot.perky

Re: Excel2003 "This font style name does not exist"

Post by ChrisGreaves »

HansV wrote:
01 Jul 2022, 18:21
You might select File > Feedback > I have a suggestion.
Oh wait, you have Office 2003... :stupidme:
:laugh: :laugh: :laugh: Hans, if I upgrade to Office 2022 so that I can complain, will there be less for me to complain about? :evilgrin:
Cheers, Chris
An expensive day out: Wallet and Grimace

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Excel2003 "This font style name does not exist"

Post by HansV »

Don't worry, Chris. You will ALWAYS have something to complain about...
Best wishes,
Hans

User avatar
ChrisGreaves
PlutoniumLounger
Posts: 15498
Joined: 24 Jan 2010, 23:23
Location: brings.slot.perky

Re: Excel2003 "This font style name does not exist"

Post by ChrisGreaves »

HansV wrote:
01 Jul 2022, 20:25
Don't worry, Chris. You will ALWAYS have something to complain about...
:laugh: :rofl: :OhSoTrue!:
An expensive day out: Wallet and Grimace

User avatar
ChrisGreaves
PlutoniumLounger
Posts: 15498
Joined: 24 Jan 2010, 23:23
Location: brings.slot.perky

Re: Excel2003 "This font style name does not exist"

Post by ChrisGreaves »

HansV wrote:
01 Jul 2022, 20:25
Don't worry, Chris. You will ALWAYS have something to complain about...
OK.
This is not a complaint; it is an observation:-
csStrikethrough03.png
Using Format, Cells, Font, one can assign the format strike-through without specifying a Font Name, Font Style, or Size.
Another observation:-
This behaviour is not available through the Styles dialogue!
Cheers, Chris
You do not have the required permissions to view the files attached to this post.
An expensive day out: Wallet and Grimace