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

[Francis Cave]

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?

Kind regards,

Francis



-----Original Message-----
From: Rex Jaeschke [mailto:rex at RexJaeschke.com] 
Sent: 23 February 2018 13:52
To: SC 34 WG4 <e-SC34-WG4 at ecma-international.org>
Subject: Question re the SML simple type ST_sqref and list-item separator

-----Original Message-----
From: Charlie Clark [mailto:charlie.clark at clark-consulting.eu] 
Sent: Friday, February 23, 2018 6:37 AM
To: Rex Jaeschke <rex at rexjaeschke.com>
Subject: Quick question

Hi Rex,

I'm not sure if I've already asked this but I couldn't find anything on it quickly. The simple type ST_sqref is a defined as a list of cell references, defines list items as separated by white space but Excel seems to use a comma for separation, for which I can't find any documentation:

sqref="AS475:AS1048576,AS1:AS465"

Is this correct?

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