arrayListSeparator Field

Indicates the separator for the constants in one row of an array constant in a formula.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.CultureInfo();
var value; // Type: string
value = instance.arrayListSeparator;

var arrayListSeparator : string;

Example

This example creates a custom culture.

Javascript

var myCulture = new GcSpread.Sheets.CultureInfo();
myCulture.currencySymbol = "€"
myCulture.numberDecimalSeparator = ",";
myCulture.numberGroupSeparator = ".";
myCulture.arrayGroupSeparator = ";";
myCulture.arrayListSeparator = "\\";
myCulture.listSeparator = ";";
myCulture.amDesignator = "";
myCulture.pmDesignator = "";
myCulture.abbreviatedMonthNames = ["Jan","Feb","Mrz","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez",""];
myCulture.abbreviatedDayNames = ["So","Mo","Di","Mi","Do","Fr","Sa"];
myCulture.abbreviatedMonthGenitiveNames = ["So","Mo","Di","Mi","Do","Fr","Sa"];
myCulture.dayNames = ["Sonntag","Montag","Dienstag","Mittwoch","Donnerstag","Freitag","Samstag"];
myCulture.fullDateTimePattern = "dddd, d. MMMM yyyy HH:mm:ss";
myCulture.longDatePattern = "dddd, d. MMMM yyyy";
myCulture.longTimePattern = "HH:mm:ss";
myCulture.monthDayPattern = "dd MMMM";
myCulture.monthNames = ["Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember",""];
myCulture.monthGenitiveNames = ["Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember",""];
myCulture.shortDatePattern = "dd.MM.yyyy";
myCulture.shortTimePattern = "HH:mm";
myCulture.yearMonthPattern = "MMMM yyyy";
 
//add one culture
GcSpread.Sheets.addCultureInfo("de-DE", myCulture);
//switch to "de-DE" culture
GcSpread.Sheets.Culture("de-DE");
var d = new Date();
//With culture
activeSheet.setValue(1, 0, new Date(d.setDate(d.getDate()+1)));
activeSheet.setFormatter(1, 0, new GcSpread.Sheets.GeneralFormatter("F", GcSpread.Sheets.FormatMode.StandardDateTimeMode));
var dvalue= 12345.6789;
var nvalue = 12345;
activeSheet.setColumnWidth(0, 100);
activeSheet.setColumnWidth(1, 100);
activeSheet.setColumnWidth(2, 100);
activeSheet.setValue(0,0,dvalue);
activeSheet.getCell(0, 0).formatter(new GcSpread.Sheets.GeneralFormatter("c3", GcSpread.Sheets.FormatMode.StandardNumericMode));
//Without culture
activeSheet.setValue(2, 0, new Date(d.setDate(d.getDate() + 1)));
//With culture
activeSheet.setFormatter(3, 0, "yyyy/MMM/dddd");
activeSheet.setValue(3, 0, new Date());

Reference

CultureInfo type