PC Review


Reply
Thread Tools Rate Thread

File Type Ordering Inconsistency

 
 
Julian
Guest
Posts: n/a
 
      1st Feb 2008
Almost trivial but annoying! [Vista HP, Office 2002]

I have a folder containing Excel .XLS files and CSV files associated with
Excel...

Unfortunately, when I "Group by Type" CSV files appear under "Microsoft
Excel Comma Separated Values Files", whereas XLS files are under "XLS
Files". (Excel Templates are also "Microsoft Excel Template in Windows
Explorer, charts are "Microsoft Excel Chart", etc. etc. i.e. XLS seems to be
an exception)

I'd rather like all the Excel types to be adjacent...

Looked in the registry (The reg key is at HKEY_CLASSES_ROOT\Excel.CSV) and
under the Excel.CSV key is the "(default)" string "Microsoft Excel Comma
Separated Values Files", but surprisingly there is no Excel.XLS key that I
could find to modify to give Windows Explorer a common Type-string
beginning...

How might I assert some control over this? What and where could I change in
the registry? Of course there is the vanilla .xls key, which has as
(default) "Excel.Sheet.8" - if I put a new (default) under Excel.Sheet.8
with the string "Microsoft Excel XLS Files" would that work?

TIA

Julian

--
Julian I-Do-Stuff

Some Vista stuff, but mostly just Stuff at http://berossus,blogspot.com

 
Reply With Quote
 
 
 
 
Gary Mount
Guest
Posts: n/a
 
      1st Feb 2008
Add this key
HKEY_CLASSES_ROOT\.xls\PersistentHandler
and add a REG_SZ with the same value as you find in the
Microsoft Excel Chart key.
In my case with Office 2000 the value is
{98de59a0-d175-11cd-a7bd-00006b827d94}
but yours will be different.

I exported my entire key to a text file as an example, as follows.

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\.xls]
"Content Type"="application/vnd.ms-excel"
@="Excel.Sheet.8"

[HKEY_CLASSES_ROOT\.xls\Excel.Sheet.8]
@=""

[HKEY_CLASSES_ROOT\.xls\Excel.Sheet.8\ShellNew]
"FileName"="excel9.xls"

[HKEY_CLASSES_ROOT\.xls\PersistentHandler]
@="{98de59a0-d175-11cd-a7bd-00006b827d94}"

But as I said, this is Office 2000.



"Julian" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Almost trivial but annoying! [Vista HP, Office 2002]
>
> I have a folder containing Excel .XLS files and CSV files associated with
> Excel...
>
> Unfortunately, when I "Group by Type" CSV files appear under "Microsoft
> Excel Comma Separated Values Files", whereas XLS files are under "XLS
> Files". (Excel Templates are also "Microsoft Excel Template in Windows
> Explorer, charts are "Microsoft Excel Chart", etc. etc. i.e. XLS seems to
> be an exception)
>
> I'd rather like all the Excel types to be adjacent...
>
> Looked in the registry (The reg key is at HKEY_CLASSES_ROOT\Excel.CSV) and
> under the Excel.CSV key is the "(default)" string "Microsoft Excel Comma
> Separated Values Files", but surprisingly there is no Excel.XLS key that I
> could find to modify to give Windows Explorer a common Type-string
> beginning...
>
> How might I assert some control over this? What and where could I change
> in the registry? Of course there is the vanilla .xls key, which has as
> (default) "Excel.Sheet.8" - if I put a new (default) under Excel.Sheet.8
> with the string "Microsoft Excel XLS Files" would that work?
>
> TIA
>
> Julian
>
> --
> Julian I-Do-Stuff
>
> Some Vista stuff, but mostly just Stuff at http://berossus,blogspot.com


 
Reply With Quote
 
 
 
 
Julian
Guest
Posts: n/a
 
      1st Feb 2008
Thanks for replying Gary -

However, I was under the impression that the PersistentHandler supported the
search/indexing of a file type... I've already got a PersistentHandler under
x.ls (CLSID {98DE59A0-D175-11CD-A7BD-00006B827D94} - just the same as yours
as it happens!)

As it is, the answer would seem to apply to a different question

--
Julian I-Do-Stuff

Some Vista stuff, but mostly just Stuff at http://berossus,blogspot.com
"Gary Mount" <(E-Mail Removed)> wrote in message
news:B1CF132A-F195-472C-8CE6-(E-Mail Removed)...
> Add this key
> HKEY_CLASSES_ROOT\.xls\PersistentHandler
> and add a REG_SZ with the same value as you find in the
> Microsoft Excel Chart key.
> In my case with Office 2000 the value is
> {98de59a0-d175-11cd-a7bd-00006b827d94}
> but yours will be different.
>
> I exported my entire key to a text file as an example, as follows.
>
> Windows Registry Editor Version 5.00
>
> [HKEY_CLASSES_ROOT\.xls]
> "Content Type"="application/vnd.ms-excel"
> @="Excel.Sheet.8"
>
> [HKEY_CLASSES_ROOT\.xls\Excel.Sheet.8]
> @=""
>
> [HKEY_CLASSES_ROOT\.xls\Excel.Sheet.8\ShellNew]
> "FileName"="excel9.xls"
>
> [HKEY_CLASSES_ROOT\.xls\PersistentHandler]
> @="{98de59a0-d175-11cd-a7bd-00006b827d94}"
>
> But as I said, this is Office 2000.
>
>
>
> "Julian" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Almost trivial but annoying! [Vista HP, Office 2002]
>>
>> I have a folder containing Excel .XLS files and CSV files associated with
>> Excel...
>>
>> Unfortunately, when I "Group by Type" CSV files appear under "Microsoft
>> Excel Comma Separated Values Files", whereas XLS files are under "XLS
>> Files". (Excel Templates are also "Microsoft Excel Template in Windows
>> Explorer, charts are "Microsoft Excel Chart", etc. etc. i.e. XLS seems to
>> be an exception)
>>
>> I'd rather like all the Excel types to be adjacent...
>>
>> Looked in the registry (The reg key is at HKEY_CLASSES_ROOT\Excel.CSV)
>> and under the Excel.CSV key is the "(default)" string "Microsoft Excel
>> Comma Separated Values Files", but surprisingly there is no Excel.XLS key
>> that I could find to modify to give Windows Explorer a common Type-string
>> beginning...
>>
>> How might I assert some control over this? What and where could I change
>> in the registry? Of course there is the vanilla .xls key, which has as
>> (default) "Excel.Sheet.8" - if I put a new (default) under Excel.Sheet.8
>> with the string "Microsoft Excel XLS Files" would that work?
>>
>> TIA
>>
>> Julian
>>
>> --
>> Julian I-Do-Stuff
>>
>> Some Vista stuff, but mostly just Stuff at http://berossus,blogspot.com

>


 
Reply With Quote
 
Julian
Guest
Posts: n/a
 
      1st Feb 2008
That was marked for Send Later!

Nevermind, I was going to add that having just amended the (default) value
immediately under Excel.Sheet.8 to "Microsoft Excel Worksheet" it had no
effect... (after logoff/logon and restart)

What am I missing?

--
Julian I-Do-Stuff

Some Vista stuff, but mostly just Stuff at http://berossus,blogspot.com
"Julian" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thanks for replying Gary -
>
> However, I was under the impression that the PersistentHandler supported
> the search/indexing of a file type... I've already got a PersistentHandler
> under x.ls (CLSID {98DE59A0-D175-11CD-A7BD-00006B827D94} - just the same
> as yours as it happens!)
>
> As it is, the answer would seem to apply to a different question
>
> --
> Julian I-Do-Stuff
>
> Some Vista stuff, but mostly just Stuff at http://berossus,blogspot.com
> "Gary Mount" <(E-Mail Removed)> wrote in message
> news:B1CF132A-F195-472C-8CE6-(E-Mail Removed)...
>> Add this key
>> HKEY_CLASSES_ROOT\.xls\PersistentHandler
>> and add a REG_SZ with the same value as you find in the
>> Microsoft Excel Chart key.
>> In my case with Office 2000 the value is
>> {98de59a0-d175-11cd-a7bd-00006b827d94}
>> but yours will be different.
>>
>> I exported my entire key to a text file as an example, as follows.
>>
>> Windows Registry Editor Version 5.00
>>
>> [HKEY_CLASSES_ROOT\.xls]
>> "Content Type"="application/vnd.ms-excel"
>> @="Excel.Sheet.8"
>>
>> [HKEY_CLASSES_ROOT\.xls\Excel.Sheet.8]
>> @=""
>>
>> [HKEY_CLASSES_ROOT\.xls\Excel.Sheet.8\ShellNew]
>> "FileName"="excel9.xls"
>>
>> [HKEY_CLASSES_ROOT\.xls\PersistentHandler]
>> @="{98de59a0-d175-11cd-a7bd-00006b827d94}"
>>
>> But as I said, this is Office 2000.
>>
>>
>>
>> "Julian" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> Almost trivial but annoying! [Vista HP, Office 2002]
>>>
>>> I have a folder containing Excel .XLS files and CSV files associated
>>> with Excel...
>>>
>>> Unfortunately, when I "Group by Type" CSV files appear under "Microsoft
>>> Excel Comma Separated Values Files", whereas XLS files are under "XLS
>>> Files". (Excel Templates are also "Microsoft Excel Template in Windows
>>> Explorer, charts are "Microsoft Excel Chart", etc. etc. i.e. XLS seems
>>> to be an exception)
>>>
>>> I'd rather like all the Excel types to be adjacent...
>>>
>>> Looked in the registry (The reg key is at HKEY_CLASSES_ROOT\Excel.CSV)
>>> and under the Excel.CSV key is the "(default)" string "Microsoft Excel
>>> Comma Separated Values Files", but surprisingly there is no Excel.XLS
>>> key that I could find to modify to give Windows Explorer a common
>>> Type-string beginning...
>>>
>>> How might I assert some control over this? What and where could I change
>>> in the registry? Of course there is the vanilla .xls key, which has as
>>> (default) "Excel.Sheet.8" - if I put a new (default) under Excel.Sheet.8
>>> with the string "Microsoft Excel XLS Files" would that work?
>>>
>>> TIA
>>>
>>> Julian
>>>
>>> --
>>> Julian I-Do-Stuff
>>>
>>> Some Vista stuff, but mostly just Stuff at http://berossus,blogspot.com

>>

>


 
Reply With Quote
 
Julian
Guest
Posts: n/a
 
      2nd Feb 2008
Well, I fixed it - but not through the registry... I just re-associated .xls
with Excel, even though it was already apparently associated! (Clicked
"browse" in the "open with" dialog, kept the "always use this..." check box
checked, navigated to C:\Program Files\Microsoft Office\Office10 and
selected Excel.exe

....must look to see what changed in the registry later... would be rather
informative!

--
Julian I-Do-Stuff

Some Vista stuff, but mostly just Stuff at http://berossus,blogspot.com
"Julian" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> That was marked for Send Later!
>
> Nevermind, I was going to add that having just amended the (default) value
> immediately under Excel.Sheet.8 to "Microsoft Excel Worksheet" it had no
> effect... (after logoff/logon and restart)
>
> What am I missing?
>
> --
> Julian I-Do-Stuff
>
> Some Vista stuff, but mostly just Stuff at http://berossus,blogspot.com
> "Julian" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Thanks for replying Gary -
>>
>> However, I was under the impression that the PersistentHandler supported
>> the search/indexing of a file type... I've already got a
>> PersistentHandler under x.ls (CLSID
>> {98DE59A0-D175-11CD-A7BD-00006B827D94} - just the same as yours as it
>> happens!)
>>
>> As it is, the answer would seem to apply to a different question
>>
>> --
>> Julian I-Do-Stuff
>>
>> Some Vista stuff, but mostly just Stuff at http://berossus,blogspot.com
>> "Gary Mount" <(E-Mail Removed)> wrote in message
>> news:B1CF132A-F195-472C-8CE6-(E-Mail Removed)...
>>> Add this key
>>> HKEY_CLASSES_ROOT\.xls\PersistentHandler
>>> and add a REG_SZ with the same value as you find in the
>>> Microsoft Excel Chart key.
>>> In my case with Office 2000 the value is
>>> {98de59a0-d175-11cd-a7bd-00006b827d94}
>>> but yours will be different.
>>>
>>> I exported my entire key to a text file as an example, as follows.
>>>
>>> Windows Registry Editor Version 5.00
>>>
>>> [HKEY_CLASSES_ROOT\.xls]
>>> "Content Type"="application/vnd.ms-excel"
>>> @="Excel.Sheet.8"
>>>
>>> [HKEY_CLASSES_ROOT\.xls\Excel.Sheet.8]
>>> @=""
>>>
>>> [HKEY_CLASSES_ROOT\.xls\Excel.Sheet.8\ShellNew]
>>> "FileName"="excel9.xls"
>>>
>>> [HKEY_CLASSES_ROOT\.xls\PersistentHandler]
>>> @="{98de59a0-d175-11cd-a7bd-00006b827d94}"
>>>
>>> But as I said, this is Office 2000.
>>>
>>>
>>>
>>> "Julian" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> Almost trivial but annoying! [Vista HP, Office 2002]
>>>>
>>>> I have a folder containing Excel .XLS files and CSV files associated
>>>> with Excel...
>>>>
>>>> Unfortunately, when I "Group by Type" CSV files appear under "Microsoft
>>>> Excel Comma Separated Values Files", whereas XLS files are under "XLS
>>>> Files". (Excel Templates are also "Microsoft Excel Template in Windows
>>>> Explorer, charts are "Microsoft Excel Chart", etc. etc. i.e. XLS seems
>>>> to be an exception)
>>>>
>>>> I'd rather like all the Excel types to be adjacent...
>>>>
>>>> Looked in the registry (The reg key is at HKEY_CLASSES_ROOT\Excel.CSV)
>>>> and under the Excel.CSV key is the "(default)" string "Microsoft Excel
>>>> Comma Separated Values Files", but surprisingly there is no Excel.XLS
>>>> key that I could find to modify to give Windows Explorer a common
>>>> Type-string beginning...
>>>>
>>>> How might I assert some control over this? What and where could I
>>>> change in the registry? Of course there is the vanilla .xls key, which
>>>> has as (default) "Excel.Sheet.8" - if I put a new (default) under
>>>> Excel.Sheet.8 with the string "Microsoft Excel XLS Files" would that
>>>> work?
>>>>
>>>> TIA
>>>>
>>>> Julian
>>>>
>>>> --
>>>> Julian I-Do-Stuff
>>>>
>>>> Some Vista stuff, but mostly just Stuff at http://berossus,blogspot.com
>>>

>>

>


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
RE: data type inconsistency Jim Thomlinson Microsoft Excel Misc 0 6th Jul 2009 11:07 PM
Data type Conversion from Excel inconsistency =?Utf-8?B?UmFjZXI0OQ==?= Microsoft Access Macros 2 3rd Oct 2007 11:56 PM
An inconsistency was encountered in the requested backup file. Wellman Hoff Windows XP Security 1 14th Oct 2003 01:23 AM
file inconsistency on D drive marc james Windows XP Performance 0 22nd Jul 2003 01:33 AM
boot up, check drive d for file inconsistency marc james Windows XP General 0 16th Jul 2003 11:19 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:35 PM.