formatting within an asterisk mask in format cells give me problem.

Topics: Developer Forum
Sep 26, 2012 at 2:30 PM
Edited Sep 26, 2012 at 3:46 PM

i'm just a little confuse with the definitions of the dialog window Format Cells ->Number ->Date (on the lists category) on microsoft office excel

the dialog told that in the note, "Date formats display date and time serial numbers as date values. Date formats that begin with an asterisk (*) respond to changes in regional date and time settings that are specified for the operation system. Formats without an asterisk are not affected by operating system settings."

i just curious with the note above, how it could impact the result of rangeToArray($pRange = 'A1', $nullValue = null, $calculateFormulas = true, $formatData = true, $returnCellRef = false)  function?

with parameter of formatData = true ? i've tested  and got that the result is not same as the excel screen, i just expect that the result wouldn't change but infact i got a different result.

data example on the sheets as appear on my screen are:


after i carefully checking the format cells types, this is a date formatting data with an asterisk follow by '*3/14/2001' with data sample 7/1/1962 . i try to see the custom number on the category, i see the data it self formatting as 'm/d/yyyy'

this is the link of attachment in image


Excel Source for sample in:

Sep 26, 2012 at 10:18 PM

From the road map:

  • Additional languages (e.g. Greek, Japanese) and locale features (e.g. date masks such as J instead of Y for Years) for formulae.

locale-aware date masks aren't yet supported