mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-30 03:59:11 +00:00
oleibman
64a1d1ab02
* Slk Shared Formulas Fix #2267. The Slk format has a way to express a "shared formula", but the Slk reader does not yet understand it. Thanks to @SheetJSDev for documenting the problem and pointing the way towards a solution. It has taken a long time to get there. Part of the problem is that I have not been successful in getting Excel to use this type of construction when saving a Slk file. So I have resorted to saving a Slk file where shared formulas *could* be used, and then editing it by hand to actually use them. It would not surprise me in the least to have neglected one or more possible ways to specify a shared formula; but, at least the issue as documented is resolved, and if new issues arise, we'll probably be in better shape to deal with them. * Update CHANGELOG.md
90 lines
1.7 KiB
Plaintext
90 lines
1.7 KiB
Plaintext
ID;PWXL;N;E
|
|
P;PGeneral
|
|
P;P0
|
|
P;P0.00
|
|
P;P#,##0
|
|
P;P#,##0.00
|
|
P;P#,##0_);;\(#,##0\)
|
|
P;P#,##0_);;[Red]\(#,##0\)
|
|
P;P#,##0.00_);;\(#,##0.00\)
|
|
P;P#,##0.00_);;[Red]\(#,##0.00\)
|
|
P;P"$"#,##0_);;\("$"#,##0\)
|
|
P;P"$"#,##0_);;[Red]\("$"#,##0\)
|
|
P;P"$"#,##0.00_);;\("$"#,##0.00\)
|
|
P;P"$"#,##0.00_);;[Red]\("$"#,##0.00\)
|
|
P;P0%
|
|
P;P0.00%
|
|
P;P0.00E+00
|
|
P;P##0.0E+0
|
|
P;P#\ ?/?
|
|
P;P#\ ??/??
|
|
P;Pyyyy/mm/dd
|
|
P;Pdd/mmm/yy
|
|
P;Pdd/mmm
|
|
P;Pmmm/yy
|
|
P;Ph:mm\ AM/PM
|
|
P;Ph:mm:ss\ AM/PM
|
|
P;Ph:mm
|
|
P;Ph:mm:ss
|
|
P;Pyyyy/mm/dd\ h:mm
|
|
P;Pmm:ss
|
|
P;Pmm:ss.0
|
|
P;P@
|
|
P;P[h]:mm:ss
|
|
P;P_("$"* #,##0_);;_("$"* \(#,##0\);;_("$"* "-"_);;_(@_)
|
|
P;P_(* #,##0_);;_(* \(#,##0\);;_(* "-"_);;_(@_)
|
|
P;P_("$"* #,##0.00_);;_("$"* \(#,##0.00\);;_("$"* "-"??_);;_(@_)
|
|
P;P_(* #,##0.00_);;_(* \(#,##0.00\);;_(* "-"??_);;_(@_)
|
|
P;FCalibri;M220;L9
|
|
P;FCalibri;M220;L9
|
|
P;FCalibri;M220;L9
|
|
P;FCalibri;M220;L9
|
|
P;ECalibri;M220;L9
|
|
P;ECalibri Light;M360;L55
|
|
P;ECalibri;M300;SB;L55
|
|
P;ECalibri;M260;SB;L55
|
|
P;ECalibri;M220;SB;L55
|
|
P;ECalibri;M220;L18
|
|
P;ECalibri;M220;L21
|
|
P;ECalibri;M220;L61
|
|
P;ECalibri;M220;L63
|
|
P;ECalibri;M220;SB;L64
|
|
P;ECalibri;M220;SB;L53
|
|
P;ECalibri;M220;L53
|
|
P;ECalibri;M220;SB;L10
|
|
P;ECalibri;M220;L11
|
|
P;ECalibri;M220;SI;L24
|
|
P;ECalibri;M220;SB;L9
|
|
P;ECalibri;M220;L10
|
|
P;ESegoe UI;M200;L9
|
|
F;P0;DG0G8;M320
|
|
B;Y6;X5;D0 0 5 4
|
|
O;D;V0;K47;G100 0.001
|
|
F;W1 16384 10
|
|
C;Y1;X1;K1
|
|
C;X2;K10
|
|
C;X3;K100
|
|
C;X4;K101
|
|
C;X5;K102
|
|
C;Y2;X1;K2;ER[-1]C+1
|
|
C;X2;K11;ER[-1]C+1
|
|
C;X3;K101;S;R2;C1
|
|
C;X4;K102;S;R2;C1
|
|
C;X5;K103;S;R2;C1
|
|
C;Y3;X1;K3;S;R2;C1
|
|
C;X2;K12;ER[-1]C+1
|
|
C;X3;K102;S;R2;C1
|
|
C;X4;K103;S;R2;C1
|
|
C;X5;K104;S;R2;C1
|
|
C;Y4;X1;K4;S;R2;C1
|
|
C;X2;K13;ER[-1]C+1
|
|
C;X3;K103;S;R2;C1
|
|
C;X4;K104;S;R2;C1
|
|
C;X5;K105;S;R2;C1
|
|
C;Y5;X1;K5;S;R2;C1
|
|
C;X2;K14;ER[-1]C+1
|
|
C;X3;K104;S;R2;C1
|
|
C;X4;K105;S;R2;C1
|
|
C;X5;K106;S;R2;C1
|
|
E
|