mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-23 22:38:28 +00:00
MarkBaker
99f488efc6
Note that this method is used when translating Excel functions between en and other locale languages, as well as when converting formulae between different spreadsheet formats (e.g. Ods to Excel) Nor is this a perfect solution, as there may still be issues when function calls have array arguments that themselves contain function calls; but it's still better than the current logic
84 lines
2.0 KiB
PHP
84 lines
2.0 KiB
PHP
<?php
|
|
|
|
return [
|
|
[
|
|
'=DAGEN360(DATUM(2010;2;5);DATUM(2010;12;31);WAAR)',
|
|
'nl',
|
|
'=DAYS360(DATE(2010,2,5),DATE(2010,12,31),TRUE)',
|
|
],
|
|
[
|
|
'=DIAS360(DATA(2010;2;5);DATA(2010;12;31);VERDADEIRO)',
|
|
'pt_br',
|
|
'=DAYS360(DATE(2010,2,5),DATE(2010,12,31),TRUE)',
|
|
],
|
|
[
|
|
'=ДНЕЙ360(ДАТА(2010;2;5);ДАТА(2010;12;31);ИСТИНА)',
|
|
'ru',
|
|
'=DAYS360(DATE(2010,2,5),DATE(2010,12,31),TRUE)',
|
|
],
|
|
[
|
|
'=TEKST.SAMENVOEGEN(A1; " "; B1)',
|
|
'nl',
|
|
'=CONCATENATE(A1, " ", B1)',
|
|
],
|
|
[
|
|
'=TEKST.SAMENVOEGEN("""Hello "; B1; ""","; " I said.")',
|
|
'nl',
|
|
'=CONCATENATE("""Hello ", B1, """,", " I said.")',
|
|
],
|
|
[
|
|
'=ЕСЛИ(1;1;1)',
|
|
'ru',
|
|
'=IF(1,1,1)',
|
|
],
|
|
[
|
|
'=ИСКЛИЛИ(1;1)',
|
|
'ru',
|
|
'=XOR(1,1)',
|
|
],
|
|
[
|
|
'=TEKST.SAMENVOEGEN(JAAR(VANDAAG());
|
|
" is ";
|
|
ALS(
|
|
DAGEN(DATUM(JAAR(VANDAAG())+1; 1; 1); DATUM(JAAR(VANDAAG()); 1; 1)) = 365;
|
|
"NOT a Leap Year";
|
|
"a Leap Year"
|
|
)
|
|
)',
|
|
'nl',
|
|
'=CONCATENATE(YEAR(TODAY()),
|
|
" is ",
|
|
IF(
|
|
DAYS(DATE(YEAR(TODAY())+1, 1, 1), DATE(YEAR(TODAY()), 1, 1)) = 365,
|
|
"NOT a Leap Year",
|
|
"a Leap Year"
|
|
)
|
|
)',
|
|
],
|
|
'Spanish with accented character' => [
|
|
'=AÑO(B1)',
|
|
'es',
|
|
'=YEAR(B1)',
|
|
],
|
|
'Bulgarian with accent and period' => [
|
|
'=ПОЛУЧИТЬ.ДАННЫЕ.СВОДНОЙ.ТАБЛИЦЫ(B1)',
|
|
'bg',
|
|
'=GETPIVOTDATA(B1)',
|
|
],
|
|
'Czech with accent and period' => [
|
|
'=DSMODCH.VÝBĚR(B1)',
|
|
'cs',
|
|
'=DSTDEV(B1)',
|
|
],
|
|
'Turkish with accent and period' => [
|
|
'=İŞGÜNÜ.ULUSL(B1)',
|
|
'tr',
|
|
'=WORKDAY.INTL(B1)',
|
|
],
|
|
[
|
|
'=STØRST(ABS({2,-3;-4,5}); ABS{-2,3;4,-5})',
|
|
'nb',
|
|
'=MAX(ABS({2,-3;-4,5}), ABS{-2,3;4,-5})',
|
|
],
|
|
];
|