Question re the SML simple type ST_sqref and list-item separator

[Charlie Clark]

Am .02.2018, 16:08 Uhr, schrieb Francis Cave <francis at franciscave.com>:

> Hi Charlie
>
> I've just created a simple test document in Excel 2016 on Windows 10. In  
> the case of both <conditionalFormatting> and <protectedRange>, this  
> version of Excel uses spaces to separate multiple ranges specified in  
> @sqref, in accordance with the standard. I haven't checked the other use  
> of @sqref (<ignoredError>), but I anticipate that the same will apply.
>
> However, I note that in the Excel user interface multiple ranges are  
> displayed with commas between the ranges, where in the SML document  
> there are spaces. Might this be simply a difference between the file  
> format and the user interface?

Hi Francis,

thanks very much for checking this. I think I may have been a little hasty  
attributing blame to Excel as it looks like the file might have been  
created by another application such as LibreOffice: the creator app is  
missing in one file's metadata, but I've just received another with the  
same approach that was created by LibreOffice. It it is, therefore, be one  
of the many bugs that LibreOffice has when it comes to styles.

So thanks again and sorry for the noise!

Charlie
-- 
Charlie Clark
Managing Director
Clark Consulting & Research
German Office
Kronenstr. 27a
Düsseldorf
D- 40217
Tel: +49-211-600-3657
Mobile: +49-178-782-6226