private void SelectLabelMode_ItemSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
String selectedItem = adapter[e.Position];
if (selectedItem.Equals("Accumulation Distribution Indicator"))
{
chart.TechnicalIndicators.RemoveAt(0);
AccumulationDistributionIndicator accumulationDistribution = new AccumulationDistributionIndicator();
NumericalAxis numericalAxis = new NumericalAxis();
numericalAxis.OpposedPosition = true;
numericalAxis.ShowMajorGridLines = false;
accumulationDistribution.YAxis = numericalAxis;
accumulationDistribution.SeriesName = "Series";
accumulationDistribution.XBindingPath = "XValue";
accumulationDistribution.Open = "Open";
accumulationDistribution.Close = "Close";
accumulationDistribution.High = "High";
accumulationDistribution.Low = "Low";
chart.TechnicalIndicators.Add(accumulationDistribution);
}
else if (selectedItem.Equals("Average True Indicator"))
{
chart.TechnicalIndicators.RemoveAt(0);
AverageTrueIndicator aTR = new AverageTrueIndicator();
NumericalAxis numericalAxis = new NumericalAxis();
numericalAxis.OpposedPosition = true;
numericalAxis.ShowMajorGridLines = false;
aTR.YAxis = numericalAxis;
aTR.Period = 14;
aTR.SeriesName = "Series";
aTR.XBindingPath = "XValue";
aTR.Open = "Open";
aTR.Close = "Close";
aTR.High = "High";
aTR.Low = "Low";
chart.TechnicalIndicators.Add(aTR);
}
else if (selectedItem.Equals("Exponential Moving Averge Indicator"))
{
chart.TechnicalIndicators.RemoveAt(0);
ExponentialMovingAverageIndicator eMA = new ExponentialMovingAverageIndicator();
NumericalAxis numericalAxis = new NumericalAxis();
numericalAxis.OpposedPosition = true;
numericalAxis.ShowMajorGridLines = false;
eMA.YAxis = numericalAxis;
eMA.Period = 14;
eMA.SeriesName = "Series";
eMA.XBindingPath = "XValue";
eMA.Open = "Open";
eMA.Close = "Close";
eMA.High = "High";
eMA.Low = "Low";
chart.TechnicalIndicators.Add(eMA);
}
else if (selectedItem.Equals("Momentum Indicator"))
{
chart.TechnicalIndicators.RemoveAt(0);
MomentumIndicator momentum = new MomentumIndicator();
NumericalAxis numericalAxis = new NumericalAxis();
numericalAxis.OpposedPosition = true;
numericalAxis.ShowMajorGridLines = false;
momentum.YAxis = numericalAxis;
momentum.SeriesName = "Series";
momentum.XBindingPath = "XValue";
momentum.Open = "Open";
momentum.Close = "Close";
momentum.High = "High";
momentum.Low = "Low";
momentum.Period = 14;
chart.TechnicalIndicators.Add(momentum);
}
else if (selectedItem.Equals("Simple Moving Average Indicator"))
{
chart.TechnicalIndicators.RemoveAt(0);
SimpleMovingAverageIndicator sMA = new SimpleMovingAverageIndicator();
sMA.SeriesName = "Series";
sMA.XBindingPath = "XValue";
sMA.Open = "Open";
sMA.Close = "Close";
sMA.High = "High";
sMA.Low = "Low";
sMA.Period = 14;
chart.TechnicalIndicators.Add(sMA);
}
else if (selectedItem.Equals("RSI Indicator"))
{
chart.TechnicalIndicators.RemoveAt(0);
RSIIndicator rSI = new RSIIndicator();
NumericalAxis numericalAxis = new NumericalAxis();
numericalAxis.OpposedPosition = true;
numericalAxis.ShowMajorGridLines = false;
rSI.YAxis = numericalAxis;
rSI.Period = 14;
rSI.SeriesName = "Series";
rSI.XBindingPath = "XValue";
rSI.Open = "Open";
rSI.Close = "Close";
rSI.High = "High";
rSI.Low = "Low";
chart.TechnicalIndicators.Add(rSI);
}
else if (selectedItem.Equals("Triangular Moving Average Indicator"))
{
chart.TechnicalIndicators.RemoveAt(0);
TriangularMovingAverageIndicator tMA = new TriangularMovingAverageIndicator();
NumericalAxis numericalAxis = new NumericalAxis();
numericalAxis.OpposedPosition = true;
numericalAxis.ShowMajorGridLines = false;
tMA.YAxis = numericalAxis;
tMA.Period = 14;
tMA.SeriesName = "Series";
tMA.XBindingPath = "XValue";
tMA.Open = "Open";
tMA.Close = "Close";
tMA.High = "High";
tMA.Low = "Low";
chart.TechnicalIndicators.Add(tMA);
}
else if (selectedItem.Equals("MACD Indicator"))
{
chart.TechnicalIndicators.RemoveAt(0);
MACDIndicator mACD = new MACDIndicator();
NumericalAxis numericalAxis = new NumericalAxis();
numericalAxis.OpposedPosition = true;
numericalAxis.ShowMajorGridLines = false;
mACD.YAxis = numericalAxis;
mACD.SeriesName = "Series";
mACD.XBindingPath = "XValue";
mACD.Open = "Open";
mACD.Close = "Close";
mACD.High = "High";
mACD.Low = "Low";
mACD.ShortPeriod = 2;
mACD.LongPeriod = 10;
mACD.Trigger = 14;
chart.TechnicalIndicators.Add(mACD);
}
else if (selectedItem.Equals("Stochastic Indicator"))
{
chart.TechnicalIndicators.RemoveAt(0);
StochasticIndicator stochastic = new StochasticIndicator();
NumericalAxis numericalAxis = new NumericalAxis();
numericalAxis.OpposedPosition = true;
numericalAxis.ShowMajorGridLines = false;
stochastic.YAxis = numericalAxis;
stochastic.SeriesName = "Series";
stochastic.XBindingPath = "XValue";
stochastic.Open = "Open";
stochastic.Close = "Close";
stochastic.High = "High";
stochastic.Low = "Low";
stochastic.Period = 14;
stochastic.KPeriod = 5;
stochastic.DPeriod = 6;
chart.TechnicalIndicators.Add(stochastic);
}
else if (selectedItem.Equals("Bollinger Band Indicator"))
{
chart.TechnicalIndicators.RemoveAt(0);
BollingerBandIndicator bB = new BollingerBandIndicator();
bB.Period = 14;
NumericalAxis numericalAxis = new NumericalAxis();
numericalAxis.OpposedPosition = true;
numericalAxis.ShowMajorGridLines = false;
//bB.YAxis = numericalAxis;
bB.SeriesName = "Series";
bB.XBindingPath = "XValue";
bB.Open = "Open";
bB.Close = "Close";
bB.High = "High";
bB.Low = "Low";
chart.TechnicalIndicators.Add(bB);
}
}
/**
* item select listener for province spinner
* */
private void provinceSpinner_ItemSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
Spinner spinner = (Spinner)sender;
this.province = spinner.SelectedItem.ToString();
}
//设置考试模式是白考还是夜间考试
private void ExamModeSpinner_ItemSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
ExamContext.ExamTimeMode = (ExamTimeMode)(e.Position + 1);
}
public void OnNothingSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
sfSchedule.ScheduleView = ScheduleView.WeekView;
}
private void spinner_ItemSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
// Spinner spinner = (Spinner)sender;
// string toast = string.Format ("The planet is {0}", spinner.GetItemAtPosition (e.Position));
// Toast.MakeText(this.context, toast, ToastLength.Long).Show();
}
private void spinner_ItemSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
spinnerPosition = e.Position;
}
private void QuestionSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
Spinner spinner = (Spinner)sender;
question = spinner.GetItemAtPosition(e.Position).ToString();
}
private void IdTypesSpinner_ItemSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
idTypeSelected = idTypesList[e.Position];
}
private void OnItemSelected(object sender, AdapterView.ItemSelectedEventArgs itemSelectedEventArgs)
{
OnItemSelected(itemSelectedEventArgs.Position);
}
private void SpinnerSkladiste_ItemSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
sifraSkladista = skladistaSifreList[e.Position];
}
void spinnerTriggers_ItemSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
triggerIndex = e.Position;
SetTrigger();
}
private void SpinnerVoditelj_ItemSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
sifraDjelatnika = djelatniciSifreList[e.Position];
}
private void spinner1_ItemSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
var spinner = (Spinner)sender;
username = string.Format("{0}", spinner.GetItemAtPosition(e.Position));
}
void ItemSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
RaiseNotifyChange();
}
private void Spinner_ItemSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
var item = (sender as Spinner).SelectedItem.ToString();
switch (item)
{
case "SUM":
case "AVG":
case "MAX":
case "MIN":
case "AVERAGE":
case "SUMSQ":
case "AVEDEV":
case "PRODUCT":
case "AVERAGEA":
case "GAMMADIST":
case "GEOMEAN":
case "HARMEAN":
case "NORMDIST":
case "COUNT":
case "COUNTA":
case "DEVSQ":
case "KURT":
case "MAXA":
case "MEDIAN":
case "MINA":
case "GCD":
case "LCM":
case "STDEV.P":
case "STDEV.S":
case "IMAGINARYDIFFERENCE":
case "IMPRODUCT":
case "PPMT":
case "IPMT":
case "ISPMT":
case "SYD":
formulaEdit.Text = "=" + item + "(A1,B1,C1,C4)";
break;
case "PI":
formulaEdit.Text = "=" + item + "()*(A1+B1*C1)";
break;
case "VLOOKUP":
formulaEdit.Text = "=" + item + "(A1,A2:C5,2,true)";
break;
case "HLOOKUP":
formulaEdit.Text = "=" + item + "(A1,A2:C5,3,true)";
break;
case "INDEX":
formulaEdit.Text = "=" + item + "(A1:C5,3,2)";
break;
case "CHAR":
case "UNICHAR":
formulaEdit.Text = "=" + item + "(C2)";
break;
case "DB":
case "DDB":
formulaEdit.Text = "=" + item + "(A1,B1,C1,5)";
break;
case "HYPGEOMDIST":
formulaEdit.Text = "=" + item + "(C1,A2,A1,B1)";
break;
case "IMSUM":
case "IMSQRT":
case "IMDIV":
formulaEdit.Text = "=" + item + "(\"1+4i\",\"1+3i\")";
break;
case "SIGN":
case "GAMMAIN":
case "COUNTBLANK":
case "FISHERINV":
case "EVEN":
case "INDIRECT":
case "ISEVEN":
case "ISODD":
case "ISREF":
case "N":
case "TAN":
case "ODD":
case "RADIANS":
case "SQRTPI":
case "FACTDOUBLE":
case "GAMMALN":
case "NORMSDIST":
case "SEC":
case "SECH":
case "COT":
case "COTH":
case "CSC":
case "CSCH":
case "ACOT":
case "ACOTH":
case "ACSCH":
case "TRUNCATE":
case "GAMMALN.PRECISE":
case "DEC2BIN":
case "DEC2OCT":
case "DEC2HEX":
case "HEX2BIN":
case "HEX2OCT":
case "HEX2DEC":
case "OCT2BIN":
case "OCT2HEX":
case "OCT2DEC":
case "IMABS":
case "IMAGINARY":
case "IMREAL":
case "IMCONJUGATE":
case "IMARGUMENT":
case "IMSIN":
case "IMCSC":
case "IMCOS":
case "IMSEC":
case "IMTAN":
case "IMCOT":
case "IMSINH":
case "IMCSCH":
case "IMCOSH":
case "IMSECH":
case "IMTANH":
case "IMCOTH":
case "IMLOG10":
case "IMLOG2":
case "IMLN":
case "IMEXP":
case "ERF":
case "ERF.PRECISE":
case "ERFC.PRECISE":
case "ERFC":
case "FORMULATEXT":
case "ISFORMULA":
case "TYPE":
case "WEEKNUM":
case "ISOWEEKNUM":
case "ROW":
case "AREAS":
case "MUNIT":
case "DEGREES":
formulaEdit.Text = "=" + item + "(A1)";
break;
case "MORMSINV":
formulaEdit.Text = "=" + item + "(A1/100)";
break;
case "NORMINV":
formulaEdit.Text = "=" + item + "(0.98,A2,A3)";
break;
case "FINV":
formulaEdit.Text = "=" + item + "(1,A1,B1)";
break;
case "IFERROR":
formulaEdit.Text = "=" + item + "(A1,\"Error in calculation\")";
break;
case "ACOS":
case "ASECH":
formulaEdit.Text = "=" + item + "(0.5)";
break;
case "ASIN":
case "ATANH":
case "FISHER":
formulaEdit.Text = "=" + item + "(0.6)";
break;
case "BIN2DEC":
case "BIN2OCT":
case "BIN2HEX":
formulaEdit.Text = "=" + item + "(11000011)";
break;
case "LARGE":
case "QUARTILE":
case "QUARTILE.EXC":
case "QUARTILE.INC":
case "SMALL":
formulaEdit.Text = "=" + item + "({C1,A2,C4,B2},3)";
break;
case "CORREL":
case "COVARIANCE.P":
case "COVARIANCE.S":
case "INTERCEPT":
case "PEARSON":
case "RSQ":
case "SLOPE":
case "STEYX":
formulaEdit.Text = "=" + item + "({C1,A2,C4},{B2,A1,C5})";
break;
case "PERCENTILE.EXC":
case "PERCENTILE.INC":
formulaEdit.Text = "=" + item + "({C1,A2,C4},0.7)";
break;
case "FORECAST":
formulaEdit.Text = "=" + item + "(A4,{C1,A2,C4},{B2,A1,C5})";
break;
case "RANDBETWEEN":
formulaEdit.Text = "=" + item + "(C1,A1)";
break;
case "PERCENTRANK":
formulaEdit.Text = "=" + item + "(A1:A5,A3)";
break;
case "TRANSPOSE":
formulaEdit.Text = "=" + item + "({100,200,300})";
break;
case "TRIMMEAN":
formulaEdit.Text = "=" + item + "(A1:A5,10%)";
break;
case "POW":
case "POWER":
case "SUMX2MY2":
case "SUMX2PY2":
case "SUMXMY2":
case "CHIDIST":
case "CHITEST":
case "CONCATENATE":
case "COMBIN":
case "COVAR":
case "PERCENTILE":
case "PERMUT":
case "ATAN2":
case "EFFECT":
case "QUOTIENT":
case "BIGMUL":
case "DIVREM":
case "IEEEREMAINDER":
case "COMBINA":
case "PERMUTATIONA":
case "CHISQ.DIST.RT":
case "IHDIST":
case "COMPLEX":
case "IMSUB":
case "IMPOWER":
case "GESTEP":
case "DELTA":
case "BITAND":
case "BITOR":
case "BITXOR":
case "BITLSHIFT":
case "BITRSHIFT":
case "BESSELI":
case "BESSELJ":
case "BESSELY":
case "BESSELK":
case "BASE":
case "DAYS":
case "EDATE":
case "EOMONTH":
case "WORKDAY.INTL":
case "WORKDAY":
case "YEARFRAC":
case "DAYS360":
case "MOD":
formulaEdit.Text = "=" + item + "(A1,C1)";
break;
case "IF":
formulaEdit.Text = "=" + item + "(A1+B1>C1+A4,True)";
break;
case "SUMIF":
formulaEdit.Text = "=" + item + "(A1:A5,\">C5\")";
break;
case "NOT":
formulaEdit.Text = "=" + item + "(IF(A1+B1>C1,True))";
break;
case "FALSE":
case "TRUE":
formulaEdit.Text = "=(IF(A1+B1>C1,True))" + item + "()";
break;
case "LEFT":
case "RIGHT":
case "LEFTB":
case "RIGHTB":
formulaEdit.Text = "=" + item + "(A1,3)";
break;
case "LEN":
case "LENB":
case "INT":
case "COLUMN":
case "ISERROR":
case "ISNUMBER":
case "ISLOGICAL":
case "ISNA":
case "ISERR":
case "ISBLANK":
case "ISTEXT":
case "ISNONTEXT":
case "EXP":
case "SINH":
case "SQRT":
case "LOG10":
case "LN":
case "ACOSH":
case "ASINH":
case "ATAN":
case "COS":
case "SIN":
case "COSH":
case "TANH":
case "LOG":
case "FACT":
formulaEdit.Text = "=" + item + "(Sum(A1,B1,C1))";
break;
case "ABS":
formulaEdit.Text = "=" + item + "(B3)";
break;
case "FV":
case "PMT":
case "MIRR":
case "NPER":
case "NPV":
case "RATE":
case "DATE":
case "TIME":
case "EXPONDIST":
case "FDIST":
case "LOGNORMDIST":
case "NEGBINOMDIST":
case "POISSON":
case "STANDARDSIZE":
case "WEIBULL":
case "SUBSTITUTE":
case "MULTINOMIAL":
case "SLN":
case "SKEW.P":
case "F.DIST.RT":
formulaEdit.Text = "=" + item + "(A1,B1,C1)";
break;
case "RAND":
formulaEdit.Text = "=" + item + "()*Sum(A1,B1,C1)";
break;
case "CEILING":
case "FLOOR":
case "ROUNDDOWN":
case "ROUND":
formulaEdit.Text = "=" + item + "(Sum(A1,B1,C1),0.5)";
break;
case "DAY":
case "HOUR":
case "MINUTE":
case "SECOND":
case "MONTH":
case "WEEKDAY":
case "YEAR":
formulaEdit.Text = "=" + item + "(A1)";
break;
case "DATEVALUE":
formulaEdit.Text = "=" + item + "(\"1990/01/24\")";
break;
case "OFFSET":
formulaEdit.Text = "=" + item + "(A1,2,2)";
break;
case "MID":
formulaEdit.Text = "=" + item + "(\"MidPoint\",1,A1)";
break;
case "MIDB":
formulaEdit.Text = "=" + item + "(\"Simple Text\",1,6)";
break;
case "EXACT":
formulaEdit.Text = "=" + item + "(A1,A1)";
break;
case "FIXED":
case "PROB":
case "SKEW":
case "STDEV":
case "STDEVA":
case "STDEVP":
case "STDEVPA":
case "VAR":
case "VARA":
case "VARP":
case "VARPA":
case "ZTEST":
case "UNIDIST":
formulaEdit.Text = "=" + item + "(A1,A2,A3)";
break;
case "LOWER":
formulaEdit.Text = "=" + item + "(\"LOWERTEXT\")";
break;
case "UPPER":
formulaEdit.Text = "=" + item + "(\"uppertext\")";
break;
case "TRIM":
formulaEdit.Text = "=" + item + "(\"Simple Text\")";
break;
case "TEXT":
formulaEdit.Text = "=" + item + "(Sum(A1,B1,C1),$0.00)";
break;
case "XIRR":
formulaEdit.Text = "=" + item + "(A1:A5," + DateTime.Now + ",0.1)";
break;
case "VALUE":
formulaEdit.Text = "=" + item + "(Avg(A1,B1,C1))";
break;
case "MODE":
formulaEdit.Text = "=" + item + "(A1,B1,C1,A1)";
break;
case "MODE.SNGL":
formulaEdit.Text = "=" + item + "(A1,B1,B1,C4)";
break;
case "MODE.MULT":
formulaEdit.Text = "=" + item + "(A1,B1,C1,C1)";
break;
case "TRUNC":
formulaEdit.Text = "=" + item + "(A1/1.3,3)";
break;
case "COUNTIF":
case "NORM.S.DIST":
formulaEdit.Text = "=" + item + "(A1,True)";
break;
case "AND":
case "OR":
case "XOR":
formulaEdit.Text = "=" + item + "(A1<B1,C5<B4)";
break;
case "IFNA":
formulaEdit.Text = "=" + item + "(VLOOKUP(A1,A2:A5,2,true),\"Not Found\")";
break;
case "LOOKUP":
formulaEdit.Text = "=" + item + "(B2,A1:B4,C1:C5)";
break;
case "SUMPRODUCT":
case "GROWTH":
formulaEdit.Text = "=" + item + "(A1:A5,B1:B5,C1:C5)";
break;
case "MATCH":
formulaEdit.Text = "=" + item + "(B3,A2:B4,0)";
break;
case "FIND":
case "FINDB":
case "SEARCH":
case "SEARCHB":
formulaEdit.Text = "=" + item + "(\"n\",\"Syncfusion\",1)";
break;
case "CHOOSE":
formulaEdit.Text = "=" + item + "(4,A1,A2,A3,A4,A5)";
break;
case "CLEAN":
formulaEdit.Text = "=" + item + "(CHAR(9)&\"Monthly report\"&CHAR(10))";
break;
case "DOLLAR":
case "ROUNDUP":
case "ROMAN":
case "CEILING.MATH":
formulaEdit.Text = "=" + item + "(A4, 4)";
break;
case "DOLLARDE":
case "DOLLARFR":
formulaEdit.Text = "=" + item + "(C2,B5)";
break;
case "DURATION":
formulaEdit.Text = "=" + item + "(A1,A3,C1,B2,2,1)";
break;
case "FVSCHEDULE":
formulaEdit.Text = "=" + item + "(1,{0.09,0.11,0.1})";
break;
case "DISC":
formulaEdit.Text = "=" + item + "(A1,B4,C1,C4,1)";
break;
case "INTRATE":
formulaEdit.Text = "=" + item + "(\"01/24/1990\",\"01/24/1991\",A5,B5,2)";
break;
case "CUMIPMT":
formulaEdit.Text = "=" + item + "(A2/12,A3*12,A4,1,1,0)";
break;
case "CUMPRINC":
formulaEdit.Text = "=" + item + "(0.1,A3,A4,1,1,0)";
break;
case "NA":
case "SHEET":
case "SHEETS":
case "NOW":
case "TODAY":
formulaEdit.Text = "=" + item + "()";
break;
case "ERROR.TYPE":
formulaEdit.Text = "=" + item + "(#REF!)";
break;
case "SUBTOTAL":
formulaEdit.Text = "=" + item + "(9,A1:B4,C1:C5)";
break;
case "PV":
formulaEdit.Text = "=" + item + "(A3, A4, A2,B4, 0)";
break;
case "ACCRINT":
formulaEdit.Text = "=" + item + "(DATE(A1,A2,B2), DATE(C1,C2,B2), DATE(B1,B2,C1),0.1,C5,2,0)";
break;
case "ACCRINTM":
formulaEdit.Text = "=" + item + "(DATE(A1,A2,B2),DATE(C2,C4,C5),0.1,B5,2)";
break;
case "VDB":
formulaEdit.Text = "=" + item + "(A1,A2,A3,DATE(A1,A2,B2),DATE(C2,C4,C5))";
break;
case "TIMEVALUE":
formulaEdit.Text = "=" + item + "(\"2:24 AM\")";
break;
case "MROUND":
formulaEdit.Text = "=" + item + "(A1,3)";
break;
case "NORMSINV":
case "NORM.S.INV":
formulaEdit.Text = "=" + item + "(0.8)";
break;
case "LOGEST":
case "LOGESTB":
formulaEdit.Text = "=" + item + "(A1:A5,B1:B5,TRUE,TRUE)";
break;
case "PERCENTRANK.EXC":
case "PERCENTRANK.INC":
case "Z.TEST":
formulaEdit.Text = "=" + item + "(A1:A5,3)";
break;
case "STANDARDIZE":
formulaEdit.Text = "=" + item + "(A1,A5,1.5)";
break;
case "ADDRESS":
formulaEdit.Text = "=" + item + "(2,3)";
break;
case "AVERAGEIF":
formulaEdit.Text = "=" + item + "(B2:B5,\"<23000\")";
break;
case "AVERAGEIFS":
formulaEdit.Text = "=" + item + "(A2:A5, C2:C5, \">30\", A2:A5, \"<90\")";
break;
case "SUMIFS":
formulaEdit.Text = "=" + item + "(A2:A5, C1:C5,\">C4\")";
break;
case "NETWORKDAYS":
formulaEdit.Text = "=" + item + "(C4,B5)";
break;
case "CONFIDENCE.T":
case "CONFIDENCE":
case "GAMMAINV":
case "LOGINV":
formulaEdit.Text = "=" + item + "(0.6,B2,A1)";
break;
case "BINOMDIST":
formulaEdit.Text = "=" + item + "(A1,B1,0.6,TRUE)";
break;
case "CHISQ.TEST":
formulaEdit.Text = "=" + item + "(A1:A3, C1:C3)";
break;
case "MMULT":
formulaEdit.Text = "=" + item + "(A2:A5, B2:B5)";
break;
case "NORM.DIST":
formulaEdit.Text = "=" + item + "(A2,A3,B1,TRUE)";
break;
case "NORM.INV":
formulaEdit.Text = "=" + item + "(0.908789,A5,B2)";
break;
case "WEIBULL.DIST":
case "GAMMA.DIST":
case "LOGNORM.DIST":
case "F.DIST":
formulaEdit.Text = "=" + item + "(A2,A3,A4,TRUE)";
break;
case "EXPON.DIST":
case "CHISQ.DIST":
formulaEdit.Text = "=" + item + "(0.3,A3,TRUE)";
break;
case "GAMMA.INV":
case "F.INV.RT":
case "LOGNORM.INV":
case "CONFIDENCE.NORM":
formulaEdit.Text = "=" + item + "(0.068094,A3,A4)";
break;
case "BINOM.INV":
case "CRITBINOM":
formulaEdit.Text = "=" + item + "(A1,0.5,0.6)";
break;
case "HYPGEOM.DIST":
formulaEdit.Text = "=" + item + "(A1,A2,A3,A4,TRUE)";
break;
case "BETA.DIST":
formulaEdit.Text = "=" + item + "(A2,A3,A4,TRUE,B1,B2)";
break;
case "CHISQ.INV":
case "CHISQ.INV.RT":
case "T.INV":
case "CHIINV":
formulaEdit.Text = "=" + item + "(0.5,A3)";
break;
case "BINOM.DIST":
case "NEGBINOM.DIST":
formulaEdit.Text = "=" + item + "(A1,A3,0.7,TRUE)";
break;
case "RANK.AVG":
formulaEdit.Text = "=" + item + "(A2,A1:A5,1)";
break;
case "RANK.EQ":
formulaEdit.Text = "=" + item + "(B3,B1:B5,1)";
break;
case "RANK":
formulaEdit.Text = "=" + item + "(C4,C1:C5,1)";
break;
case "POISSON.DIST":
case "T.DIST":
formulaEdit.Text = "=" + item + "(A1,A2,TRUE)";
break;
case "CONVERT":
formulaEdit.Text = "=" + item + "(A1,\"F\",\"C\")";
break;
case "REPLACE":
case "REPLACEB":
formulaEdit.Text = "=" + item + "(\"SimpleText\",6,5,\"*\")";
break;
case "CODE":
case "UNICODE":
case "ASC":
case "JIS":
case "ENCODEURL":
case "T":
formulaEdit.Text = "=" + item + "(\"SimpleText\")";
break;
case "PROPER":
formulaEdit.Text = "=" + item + "(\"SimPleTeXt\")";
break;
case "NUMBERVALUE":
formulaEdit.Text = "=" + item + "(\"2.500,27\",\",\",\".\")";
break;
case "REPT":
formulaEdit.Text = "=" + item + "(\"SimpleText\",3)";
break;
case "MDETERM":
case "ROWS":
case "COLUMNS":
case "IRR":
formulaEdit.Text = "=" + item + "(A1:A5)";
break;
case "MINVERSE":
formulaEdit.Text = "=" + item + "({1,2,4})";
break;
case "DECIMAL":
formulaEdit.Text = "=" + item + "(\"FF\",16)";
break;
case "SERIESSUM":
formulaEdit.Text = "=" + item + "(A3,0,2,A1:A5)";
break;
case "ARABIC":
formulaEdit.Text = "=" + item + "(\"LVII\")";
break;
case "NETWORKDAYS.INTL":
formulaEdit.Text = "=" + item + "(\"1990/01/24\",\"1992/01/24\")";
break;
case "HYPERLINK":
formulaEdit.Text = "=" + item + "(\"http:\\www.syncfusion.com\",\"Syncfusion\")";
break;
case "INFO":
formulaEdit.Text = "=" + item + "(\"NUMFILE\")";
break;
case "CELL":
formulaEdit.Text = "=" + item + "(\"col\",C3)";
break;
}
}
private void Edittexts_ItemSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
Spinner spin = (Spinner)sender;
Toasty.Info(this, "" + spin.SelectedItem, 3, true).Show();
}
private void spinner_ItemSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
//set measurement type based on spinner position
SetMeasurementType(e.Position);
}
private void langSpinner_ItemSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
// fill voices
String lang = _langCodes[e.Position].Code;
var voices = new List <String>();
_eli = new List <EngInt>();
String initVoice = Intent.GetStringExtra(INIT_LANG);
String initLangIso3 = null;
if (initVoice != null)
{
initVoice = initVoice.ToLower();
initLangIso3 = new Locale(initVoice).ISO3Language.ToLower();
}
String initEngine = Intent.GetStringExtra(INIT_ENGINE);
int selPos = -1, selQual = -1, maxQual = -100, n = 0;
foreach (EngLang el in _allEngines)
{
String ttsEngName = el.Label().Replace(" TTS", "");
bool useThis = initVoice != null && initEngine != null && initEngine == el.Name();
for (int i = 0; i < el.Voices.Count; i++)
{
if (lang == el.Iso3ln[i])
{
Locale loc = LangSupport.LocaleFromString(el.Voices[i]);
String locStr = loc.ToString().ToLower().Replace('_', '-');
if (useThis && locStr == initVoice)
{
selPos = n;
useThis = false;
initVoice = null; // to stop looking for more
}
if (maxQual < el.Quality)
{
maxQual = el.Quality;
selQual = n;
}
String country = loc.GetDisplayCountry(loc);
String variant = loc.Variant;
String s = ttsEngName;
if ("" != country)
{
s += ", " + country;
}
if ("" != variant)
{
s += ", " + variant;
}
voices.Add(s);
_eli.Add(new EngInt(el, i));
n++;
}
}
}
var adapter = new ArrayAdapter <String>(this, Android.Resource.Layout.SimpleSpinnerItem, voices);
adapter.SetDropDownViewResource(Android.Resource.Layout.SimpleSpinnerDropDownItem);
_voiceSpinner.Adapter = adapter;
if (selPos < 0)
{
selPos = selQual;
}
if (selPos > -1)
{
_selectedEngine = _eli[selPos].El;
_selectedVoice = _eli[selPos].Pos;
bool autoSel = (Intent != null && Intent.GetBooleanExtra(INIT_AUTOSEL, false)) ? true : false;
if (autoSel && _selectedEngine != null && _selectedVoice > -1)
{
if (initLangIso3 == _selectedEngine.Iso3ln[_selectedVoice])
{
UseSelected();
return;
}
else
{
Intent.PutExtra(SELECTED_VOICE, initLangIso3 + "_n/a");
SetResult(Result.Ok, Intent);
Finish();
return;
}
}
_voiceSpinner.SetSelection(selPos); // fix this, use previous selection or best quality...
}
}
//Building Screen
private void spinner_ItemSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
Spinner spinner = (Spinner)sender;
currGroup = spinner.GetItemAtPosition(e.Position).ToString();
}
private void spinner_ItemSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
Spinner spinner = (Spinner)sender;
SelectedPaymentMeth = spinner.SelectedItem.ToString();
}
private void ServiceSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
Spinner spinner = (Spinner)sender;
serviceSelected = e.Position + 1;
}
private void SpinnerNation_ItemSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
shipsAll = arrayOfShips.ShipsListApi;
spinnerRank.SetSelection(0);
switch (e.Position)
{
case 0:
shipAdapter = new ShipAdapter(this, arrayOfShips.ShipsListApi);
listView.Adapter = shipAdapter;
break;
case 1:
shipsAll = shipsAll.Where(x => x.Nation == "USA").ToList();
shipAdapter = new ShipAdapter(this, shipsAll);
listView.Adapter = shipAdapter;
break;
case 2:
shipsAll = shipsAll.Where(x => x.Nation == "Germany").ToList();
shipAdapter = new ShipAdapter(this, shipsAll);
listView.Adapter = shipAdapter;
break;
case 3:
shipsAll = shipsAll.Where(x => x.Nation == "USSR").ToList();
shipAdapter = new ShipAdapter(this, shipsAll);
listView.Adapter = shipAdapter;
break;
case 4:
shipsAll = shipsAll.Where(x => x.Nation == "Britain").ToList();
shipAdapter = new ShipAdapter(this, shipsAll);
listView.Adapter = shipAdapter;
break;
case 5:
shipsAll = shipsAll.Where(x => x.Nation == "Japan").ToList();
shipAdapter = new ShipAdapter(this, shipsAll);
listView.Adapter = shipAdapter;
break;
case 6:
shipsAll = shipsAll.Where(x => x.Nation == "China").ToList();
shipAdapter = new ShipAdapter(this, shipsAll);
listView.Adapter = shipAdapter;
break;
case 7:
shipsAll = shipsAll.Where(x => x.Nation == "Italy").ToList();
shipAdapter = new ShipAdapter(this, shipsAll);
listView.Adapter = shipAdapter;
break;
case 8:
shipsAll = shipsAll.Where(x => x.Nation == "France").ToList();
shipAdapter = new ShipAdapter(this, shipsAll);
listView.Adapter = shipAdapter;
break;
case 9:
shipsAll = shipsAll.Where(x => x.Nation == "Sweden").ToList();
shipAdapter = new ShipAdapter(this, shipsAll);
listView.Adapter = shipAdapter;
break;
}
}
private void cboRole_ItemSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
this.viewModel.Model.Role = (int)e.Id;
}
private void setString(object sender, AdapterView.ItemSelectedEventArgs e)
{
make = manufacturer.GetItemAtPosition(e.Position).ToString();
}
/**
* item select listener for month spinner, updates the days spinner if required
* */
private void birthDateMonthSpinner_ItemSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
Spinner spinner = (Spinner)sender;
string strMonth = spinner.SelectedItem.ToString();
//Based on the item selected by the Month spinner, set the value of the month from alpha to numeric only
switch (strMonth)
{
case "January":
strMonth = "01";
break;
case "February":
strMonth = "02";
break;
case "March":
strMonth = "03";
break;
case "April":
strMonth = "04";
break;
case "May":
strMonth = "05";
break;
case "June":
strMonth = "06";
break;
case "July":
strMonth = "07";
break;
case "August":
strMonth = "08";
break;
case "September":
strMonth = "09";
break;
case "October":
strMonth = "10";
break;
case "November":
strMonth = "11";
break;
case "December":
strMonth = "12";
break;
default:
strMonth = "";
break;
}
this.month = strMonth;
//Set the class variable of month to the month selected by the spinner
if (!String.IsNullOrEmpty(this.month))
{
calculateDatesOfMonth();
}
}
private void TypeSelector_ItemSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
enemyTypeIndex = e.Position;
_ = InitLoadProcess(false);
}
private void Spinner_ItemSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
var spinner = sender as Spinner;
s_section_role = spinner.GetItemAtPosition(e.Position).ToString();
}
private void Spnlanguage_ItemSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
langcode = languagecodelist[e.Position];
}
private void ListView_ItemSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
e.View.Selected = true;
}
private void spinner_ItemSelected2(object sender, AdapterView.ItemSelectedEventArgs e)
{
Spinner spinner = (Spinner)sender;
OPDRACHT = string.Format("{0}", spinner.GetItemAtPosition(e.Position));
}
