-
Notifications
You must be signed in to change notification settings - Fork 16
/
Copy pathexcel.htm
1743 lines (1570 loc) · 63.5 KB
/
excel.htm
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
<!DOCTYPE html>
<html>
<head>
<title>Comparison of Spreadsheet Programs</title>
<meta name="description" content="Comparison of Spreadsheet Programs">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta charset="UTF-8">
<meta name="keywords" content="Technology, Browsers, Firefox, Chrome, Edge, Safari, Brave, Vivaldi, Operating Systems, Desktop Environments, GNOME, KDE, Xfce, Linux, Unix, BSD, Solaris, Windows, macOS, Instant Messengers, Chat, Software, Cloud, Sync, Email, Privacy, Excel, Libreoffice, Onlyoffice, Softmaker, WPS">
<meta name="author" content="Alphonse Eylenburg">
<link rel="stylesheet" href="style.css">
<style>
:root {
--legendwidth: 370px;
--columnwidth: 260px;
}
table {
margin-top: 1em;
text-align: center;
border: none;
table-layout: fixed;
font-size: small;
width: calc(var(--legendwidth) + 5 * var(--columnwidth));
}
td {
border: none;
padding: 1px 1px;
vertical-align: top;
}
td.green,
td.lgreen,
td.yellow,
td.lred,
td.red,
td.line {
border-top: 1px solid ivory;
border-bottom: 1px solid ivory;
}
th {
border: none;
position: -webkit-sticky;
position: sticky;
top: 0px;
z-index: 10;
background-color: white;
font-weight: bold;
}
table.comparison tr>th:first-child, table.comparison tr>td:first-child {
background-color: white;
}
@media (prefers-color-scheme: dark) {
th, table.comparison tr>th:first-child, table.comparison tr>td:first-child {background-color: #222; color: white; }
td.green,
td.lgreen,
td.yellow,
td.lred,
td.red,
td.line { color: #222; }
}
@media (min-width: 578px){
table.comparison tr>th:first-child, table.comparison tr>td:first-child {
position: -webkit-sticky;
position: sticky;
left: 0;
}
}
td img {
padding: 15px 0px;
}
table.comparison tr td:first-child {
text-align: left;
white-space: nowrap;
padding-right: 5px;
}
.semititle {
text-decoration: underline;
font-weight: bold;
vertical-align: bottom; }
.center {
text-align: center;
}
.tooltip {
text-decoration: underline;
text-decoration-style: dotted;
text-decoration-color: darkred;
}
.tooltip .tooltiptext {
visibility: hidden;
background-color: black;
color: #fff;
text-align: center;
border-radius: 6px;
padding: 5px 5px;
position: absolute;
z-index: 1;
}
.tooltip:hover .tooltiptext {
visibility: visible;
font-weight: normal;
}
.green {
background-color: #CEE6BB;
}
.lgreen {
background-color: #E7F2DD;
}
.yellow {
background-color: #E7DEB1;
}
.lred {
background-color: #F5E0D6;
}
.red {
background-color: #EBC1AD;
}
.blue{
background-color: aliceblue;
}
</style>
</head>
<body>
<script src="top.js"></script>
<header>
<p><a href="index.html">← Sitemap</a></p>
</header>
<h1>Comparison of Spreadsheet Programs</h1>
<p>Microsoft Excel is the king of spreadsheet programs. It is ubiquitous in many office jobs and 99% of finance or accounting departments are completely dependent on it.</p> <a href="https://xkcd.com/2347/" target="_blank"><img src="pics/excel-xkcd.jpg" style="max-width: 100%; max-height: 250 px;"/></a>
<p style="font-size: small; text-align: center;">I have been informed that actually LibreOffice can have a better backwards compatibility with Excel 2003 compared to Excel 365. Sorry!</p>
<p>Personally, I use it daily in my job and have become quite fond of it; Excel now is my <a href="https://en.wikipedia.org/wiki/Law_of_the_instrument" target="_blank">golden hammer</a>, a tool that I like to use for any task it might be remotely suitable for. I run Linux on my private computer and the lack of Excel has been annoying: complex Excel files won't calculate or display correctly in alternative apps and I don't like to re-learn the workflows and keyboard shortcuts (only noobs use the mouse). While it is kind of possible to <a href="https://gist.github.com/eylenburg/38e5da371b7fedc0662198efc66be57b" target="_blank">run Excel in Linux</a> it is not straight-forward most people recommend alternatives like LibreOffice or OnlyOffice instead. So I set out to compare these in detail, with the overall question: <strong>"Can this program replace Excel? Do we actually <em>need</em> Excel on Linux?"</strong><br /><br />
I had a closer look at these applications:</p>
<ul>
<li><span style="font-weight: bold;">Microsoft Office/Excel</span>, the defining spreadsheet program that powers the world, even though it shouldn't</li>
<li><span style="font-weight: bold;">LibreOffice</span>, the most popular free and open source (FOSS) alternative, preinstalled on many Linux distributions; a fork of the dormant OpenOffice and successor of the commercial StarOffice with its roots going back to 1985</li>
<li><span style="font-weight: bold;">OnlyOffice</span>, a newer FOSS contender with an Excel-like ribbon interface, first released in 2014</li>
<li><span style="font-weight: bold;">Softmaker Office</span>, a proprietary office suite from Germany that has been developed since 1987 and is available in free and paid versions</li>
<li><span style="font-weight: bold;">WPS Office</span>, a proprietary office suite from China going back to 1988</li>
</ul>
<p>I limited this comparison to the best-known Excel alternatives and also excluded all those that are not sufficiently cross-platform (Windows, macOS, Linux). For example, not included in the comparison are:</p>
<ul>
<li><span style="font-weight: bold;">Apache OpenOffice</span>, as its development has become quite dormant and LibreOffice is a more modern and feature-rich fork</li>
<li><span style="font-weight: bold;">Calligra Sheets</span>, a KDE app initially release in 2000 as part of KOffice but currently only available for Linux and Unix</li>
<li><span style="font-weight: bold;">Gnumeric</span>, a GNOME app dating back to 2001 that is currently only available for Linux and Unix</li>
<li><span style="font-weight: bold;">Ability Office</span>, an office suite developed since 1996 but which is available for Windows</li>
<li><span style="font-weight: bold;">Quattro Pro</span>, initially released in 1988 and now part of WordPerfect Office, which is only available for Windows</li>
<li><span style="font-weight: bold;">Apple Numbers</span>, part of the iWork office suite (initial release 2004) which is only available for MacOS and iOS</li>
<li><span style="font-weight: bold;">Google Sheets</span>, as it's only available in the browser or as a mobile app</li>
<li><span style="font-weight: bold;">Zoho Sheet</span>, as it's only available in the browser or as a mobile app</li>
<li><span style="font-weight: bold;">Hancom Office</span>, a Korean office suite that's quite unknown abroad and is not available for Linux</li>
<li><span style="font-weight: bold;">Polaris Office</span>, ditto</li>
</ul>
<p><a href="supporting/Testfile.xlsx">Here is a test spreadsheet created in Excel that I used to check the compatibility.</a></p>
<h2 class="center">Comparison of Spreadsheet Programs</h2>
<p class="center">Source: eylenburg.github.io</p>
<p class="center" style="color: red; font-size: small;">Last updated: 7 February 2025</p>
<table class="comparison">
<colgroup>
<col style="text-align: left; white-space: nowrap; padding-right: 5px; width: var(--legendwidth);"> <!-- legend -->
<col style="border-left: double; width: var(--columnwidth);">
<col style="border-left: 1px solid lightgrey; width: var(--columnwidth);">
<col style="border-left: 1px solid lightgrey; width: var(--columnwidth);">
<col style="border-left: 1px solid lightgrey; width: var(--columnwidth);">
<col style="border-left: 1px solid lightgrey; width: var(--columnwidth);">
</colgroup>
<thead>
<tr style="height: 1px; display: none;">
<td style="width: var(--legendwidth);"></td>
<td style="width: var(--columnwidth);"></td>
<td style="width: var(--columnwidth);"></td>
<td style="width: var(--columnwidth);"></td>
<td style="width: var(--columnwidth);"></td>
<td style="width: var(--columnwidth);"></td>
</tr>
<tr style="font-size: larger; font-weight: bold;">
<th></th>
<th>Microsoft Office<br />Excel 365</th>
<th>LibreOffice / CollaboraOffice<br />Calc</th>
<th>OnlyOffice</th>
<th>Softmaker Office / FreeOffice<br />Planmaker</th>
<th>WPS Office<br />Spreadsheets</th>
</tr>
<tr>
<td style="text-align: left;">Version tested</td>
<td>2408</td>
<td>2024.08</td>
<td>8.2.0</td>
<td>2024 (rev F1218.0824)</td>
<td>11.1.0</th>
</tr>
</thead>
<tbody>
<tr>
<td></td>
<td style="vertical-align: middle;"><img src="pics/logos/excel/excel.svg" style="height: 100px; max-width: 190px;" /></td>
<td style="vertical-align: middle;"><img src="pics/logos/excel/libreoffice.svg" style="height: 100px; max-width: 190px;" /></td>
<td style="vertical-align: middle;"><img src="pics/logos/excel/onlyoffice.svg" style="height: 100px; max-width: 190px;" /></td>
<td style="vertical-align: middle;"><img src="pics/logos/excel/softmaker.png" style="height: 100px; max-width: 190px;" /></td>
<td style="vertical-align: middle;"><img src="pics/logos/excel/wps.png" style="height: 100px; max-width: 190px;" /></td>
</tr>
<tr><td class="semititle"><br /> </td><td></td><td></td><td></td><td></td><td></td></tr>
<tr>
<td>License</td>
<td class="red">Proprietary</td>
<td class="green">MPL</td>
<td class="green">AGPL</td>
<td class="red">Proprietary</td>
<td class="red">Proprietary</td>
</tr>
<tr>
<td>Price</td>
<td class="red">Paid</td>
<td class="green">Free</td>
<td class="green">Free</td>
<td class="yellow">Free or paid (more features)</td>
<td class="yellow">Free or paid (more features)</td>
</tr>
<tr>
<td>Works without registering for an account</td>
<td class="red">No</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="red">No</td>
<td class="yellow">Only Linux version</td>
</tr>
<tr>
<td class="semititle"><br />Platforms</td><td colspan="5" style="text-align: center; font-style: italic; font-size: small; vertical-align: bottom;">Some features may be limited to certain platforms, such as macros not working in the web or mobile versions.</td>
</tr>
<tr>
<td>Windows</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>macOS</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Linux</td>
<td class="red">No <a href="https://gist.github.com/eylenburg/38e5da371b7fedc0662198efc66be57b" target="_blank">(workarounds)</a></td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Unix</td>
<td class="red">No</td>
<td class="green">Yes</td>
<td class="red">No</td>
<td class="red">No</td>
<td class="red">No</td>
</tr>
<tr>
<td>Web version</td>
<td class="green">Yes</td>
<td class="green">Yes (CollaboraOffice)</td>
<td class="green">Yes</td>
<td class="red">No</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Mobile version</td>
<td class="lgreen">Yes (limited editing)</td>
<td class="lgreen">Yes (CollaboraOffice) (limited editing)</td>
<td class="lgreen">Yes (limited editing)</td>
<td class="green">Yes</td>
<td class="lgreen">Yes (limited editing)</td>
</tr>
<tr><td class="semititle"><br />File formats</td><td></td><td></td><td></td><td></td><td></td></tr>
<tr>
<td>XLSX support</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>ODS support</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="yellow">Opening but not saving</td>
<td class="red">No</td>
</tr>
<tr>
<td>CSV import and export</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr><td class="semititle"><br />Functions</td><td colspan="5" style="text-align: center; font-style: italic; font-weight: bold; vertical-align: bottom;"><a href="supporting/spreadsheet_functions.htm">CLICK HERE FOR A COMPLETE LIST OF FUNCTIONS IN ALL THESE APPLICATIONS</a></td></tr>
<tr>
<td>Total functions</td>
<td class="green">515</td>
<td class="green">516</td>
<td class="lgreen">482</td>
<td class="yellow">405</td>
<td class="yellow">377</td>
</tr>
<tr>
<td>No. of extra functions that are missing in Excel</td>
<td>n/a</td>
<td>56</td>
<td>12</td>
<td>32</td>
<td>10</td>
</tr>
<tr>
<td>No. of missing Excel functions</td>
<td>n/a</td>
<td class="lred">53</td>
<td class="lred">43</td>
<td class="red">140</td>
<td class="red">146</td>
</tr>
<tr>
<td></td>
<td></td>
<td style="font-size: 80%;"><code>ARRAYTOTEXT BINOM.DIST.RANGE BYCOL BYROW CALL CHOOSECOLS CHOOSEROWS CUBEKPIMEMBER CUBEMEMBER CUBEMEMBERPROPERTY CUBERANKEDMEMBER CUBESET CUBESETCOUNT CUBEVALUE DBCS DETECTLANGUAGE DROP ECMA.CEILING EXPAND FIELDVALUE FORECAST.ETS FORMULATEXT GROUPBY HSTACK IMAGE ISOMITTED LAMBDA MAKEARRAY MAP PHONETIC PIVOTBY PY REDUCE REGEXEXTRACT REGEXREPLACE REGEXTEST REGISTER.ID RTD SCAN SINGLE SKEW.P SQL.REQUEST STOCKHISTORY TAKE TEXTAFTER TEXTBEFORE TEXTSPLIT TOCOL TOROW TRANSLATE TRIMRANGE VALUETOTEXT VSTACK</code></td>
<td style="font-size: 80%;"><code>AREAS BAHTTEXT BYCOL BYROW CALL COUNTBLANK CUBEKPIMEMBER CUBEMEMBER CUBEMEMBERPROPERTY CUBERANKEDMEMBER CUBESET CUBESETCOUNT CUBEVALUE DBCS DETECTLANGUAGE ENCODEURL EUROCONVERT FIELDVALUE FILTERXML GROUPBY IMAGE INFO ISOMITTED JIS LAMBDA LET MAKEARRAY MAP PHONETIC PIVOTBY PY REDUCE REGEXEXTRACT REGEXREPLACE REGEXTEST REGISTER.ID RTD SCAN SINGLE SQL.REQUEST STOCKHISTORY TRANSLATE TRIMRANGE</code></td>
<td style="font-size: 70%;"><code>ACCRINT ACCRINTM AGGREGATE AMORDEGRC AMORLINC ARABIC ARRAYTOTEXT ASC BAHTTEXT BITAND BITLSHIFT BITOR BITRSHIFT BITXOR BYCOL BYROW CALL CEILING.MATH CEILING.PRECISE CHISQ.DIST CHISQ.INV CHOOSECOLS CHOOSEROWS COMBINA CONFIDENCE.T COUPDAYBS COUPDAYS COUPDAYSNC COUPNCD COUPNUM COUPPCD CSC CSCH CUBEKPIMEMBER CUBEMEMBER CUBEMEMBERPROPERTY CUBERANKEDMEMBER CUBESET CUBESETCOUNT CUBEVALUE DBCS DETECTLANGUAGE DISC DOLLAR DROP DURATION ECMA.CEILING ENCODEURL ERF.PRECISE ERFC.PRECISE EXPAND F.DIST F.INV FIELDVALUE FILTER FILTERXML FLOOR.MATH FLOOR.PRECISE FORECAST.ETS FORECAST.LINEAR GAMMALN.PRECISE GROUPBY HSTACK IMAGE IMCOSH IMCOT IMCSC IMCSCH IMSEC IMSECH IMSINH IMTAN INFO INTRATE ISO.CEILING ISOMITTED JIS LAMBDA LET MAKEARRAY MAP MDURATION MODE.MULT MUNIT NETWORKDAYS.INTL ODDFPRICE ODDFYIELD ODDLPRICE ODDLYIELD PDURATION PERMUTATIONA PHONETIC PIVOTBY PRICE PRICEDISC PRICEMAT PY RANDARRAY RECEIVED REDUCE REGEXEXTRACT REGEXREPLACE REGEXTEST REGISTER.ID RTD SCAN SEC SECH SEQUENCE SINGLE SKEW.P SORT SORTBY SQL.REQUEST STOCKHISTORY TAKE TBILLEQ TBILLPRICE TBILLYIELD TEXTAFTER TEXTBEFORE TEXTSPLIT TOCOL TOROW TRANSLATE TRIMRANGE UNICHAR UNICODE UNIQUE VALUETOTEXT VDB VSTACK WEBSERVICE WORKDAY.INTL WRAPCOLS WRAPROWS XLOOKUP XMATCH YEARFRAC YIELD</code></td>
<td style="font-size: 70%;"><code>ACOT ACOTH ARABIC ARRAYTOTEXT BASE BETA.DIST BETA.INV BYCOL BYROW CALL CEILING.MATH CEILING.PRECISE CHISQ.DIST.RT CHISQ.INV.RT CHISQ.TEST CHOOSECOLS CHOOSEROWS COMBINA CONFIDENCE.NORM CONFIDENCE.T COT COTH CSC CSCH CUBEKPIMEMBER CUBEMEMBER CUBEMEMBERPROPERTY CUBERANKEDMEMBER CUBESET CUBESETCOUNT CUBEVALUE DECIMAL DETECTLANGUAGE DROP ECMA.CEILING EFFECT ERF.PRECISE ERFC.PRECISE EUROCONVERT EVEN EXPAND EXPON.DIST F.DIST F.DIST.RT F.INV F.INV.RT F.TEST FILTERXML FLOOR.MATH FLOOR.PRECISE FORECAST.ETS FORECAST.LINEAR FVSCHEDULE GAMMA GAMMA.DIST GAMMA.INV GAUSS GROUPBY HSTACK HYPGEOM.DIST IMAGE IMCOSH IMCOT IMCSC IMCSCH IMSEC IMSECH IMSINH IMTAN INTRATE ISO.CEILING ISOMITTED ISOWEEKNUM JIS LAMBDA LET LOGNORM.DIST LOGNORM.INV MAKEARRAY MAP MODE.MULT MODE.SNGL MUNIT NEGBINOM.DIST NOMINAL ODDFPRICE ODDFYIELD ODDLPRICE ODDLYIELD PDURATION PERCENTILE.EXC PERCENTILE.INC PERCENTRANK.EXC PERCENTRANK.INC PERMUTATIONA PHI PIVOTBY POISSON.DIST PRICEDISC PY QUARTILE.EXC QUARTILE.INC RECEIVED REDUCE REGEXEXTRACT REGEXREPLACE REGEXTEST REGISTER.ID RRI SCAN SEC SECH SHEET SHEETS SINGLE SKEW.P SQL.REQUEST STDEV.P STDEVP STOCKHISTORY SUMXMY2 T.DIST T.DIST.2T T.DIST.RT T.INV T.INV.2T T.TEST TAKE TBILLEQ TBILLPRICE TBILLYIELD TEXTAFTER TEXTBEFORE TEXTSPLIT TOCOL TOROW TRANSLATE TRIMRANGE VALUETOTEXT VSTACK WEBSERVICE WEIBULL.DIST WRAPCOLS WRAPROWS XMATCH YIELDDISC</code></td>
</tr>
<tr><td class="semititle"><br />Basic spreadsheet features</td><td></td><td></td><td></td><td></td><td></td></tr>
<tr>
<td>Filter and sort data in columns</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Create "tables"</td>
<td class="green">Yes</td>
<td class="lred tooltip">No, but Excel tables are displayed<span class="tooltiptext">LibreOffice Calc does not have a direct equivalent to Excel’s “tables” feature, which includes functionalities like automatic formatting, structured references, and dynamic range expansion. However, you can achieve similar results using a combination of named ranges, autofilters, and autoformat styles. When you open an Excel file containing tables in Calc, the tables will be imported and displayed with basic functionality like sorting and filtering, but table formatting will be lost and some table features like structured references are not fully supported.</span></td>
<td class="green">Yes</td>
<td class="green">Yes <span style="color: red;" class="tooltip">(paid version only)<span class="tooltiptext">The free version can still display tables created in Excel but not create new ones</span></span></td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Pivot tables</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Data validation for cells</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Set print areas</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Hide and group rows and columns</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Hide and unhide sheets</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Comments (simple "notes" and threaded "comments")</td>
<td class="green">Yes</td>
<td class="yellow">Threaded will be converted to notes</td>
<td class="green">Yes</td>
<td class="yellow">Threaded will be converted to notes</td>
<td class="yellow">Threaded will be converted to notes</td>
</tr>
<tr>
<td>Freeze panes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Format cells as text when started with <code>'</code></td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Name manager</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Hyperlinks in cells</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Link to other spreadsheet files</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="lgreen">Yes, via Copy → Paste Link<a href="https://helpcenter.onlyoffice.com/ONLYOFFICE-Editors/ONLYOFFICE-Spreadsheet-Editor/UsageInstructions/AddExternalLinks.aspx" target="_blank">*</a></td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Check, update and edit external links</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Merge cells</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Split text into multiple columns</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="yellow">Only by delimiter, not by fixed width</td>
<td class="red">No</td>
<td class="green">Yes</td>
</tr>
<tr>
<td class="tooltip">Apply formulas on multiple adjacent sheets<span class="tooltiptext">e.g. `=SUM(Sheet1:Sheet4!A1)` to sum cell A1 from these sheets</span></td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr><td class="semititle"><br />Basic calculation features</td><td></td><td></td><td></td><td></td><td></td></tr>
<tr>
<td>Data tables (in What-if Analysis)</td>
<td class="green">Yes</td>
<td class="green">Yes ("Multiple Operations")</td>
<td class="red">No</td>
<td class="red">No</td>
<td class="red">No</td>
</tr>
<tr>
<td>Goalseek</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="yellow">Yes, but target must be an integer</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Can enable iterative calculation</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Can disable automatic recalculation</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="red">No</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr><td class="semititle"><br />Formatting compatibility with Excel</td><td></td><td></td><td></td><td></td><td></td></tr>
<tr>
<td>Border styles and colours</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Two-colour fill for cell backgrounds</td>
<td class="green">Yes</td>
<td class="red">No</td>
<td class="yellow">Not all styles (e.g. no fill from centre)</td>
<td class="red">No</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Pattern fill for cell backgrounds</td>
<td class="green">Yes</td>
<td class="red">No</td>
<td class="green">Yes</td>
<td class="yellow">Fewer patterns supported</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Conditional formatting</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Apply colour scales or insert data bars</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr><td style="text-align: left; font-style: italic; text-decoration: underline;">Text formatting:</td><td></td><td></td><td></td><td></td><td></td></tr>
<tr>
<td>Rich text, including partial formatting in a cell</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Superscript and subscript</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Indentation</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Center across selection (without merging cells)</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="red">No</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Accounting underline</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Wrap text</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Vertical and rotated text</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr><td style="text-align: left; font-style: italic; text-decoration: underline;">Number formatting:</td><td></td><td></td><td></td><td></td><td></td></tr>
<tr>
<td class="tooltip"><code>#,##0_);[red](#,##0);-_)</code><span class="tooltiptext">For financial numbers: format with thousands separator, negative numbers in brackets and in red, hyphen for zero values, gap the size of a closing bracket for non-negative numbers to align all numbers on the right</span></td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<td class="tooltip"><code>$0.0,,"m"_);[red]($0.0,,"m");-_)</code><span class="tooltiptext">Same as above, but shown number in millions of dollars with one decimal digit, e.g. 1500000 will be shown as $1.5m</span></td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="red tooltip">Doesn't display correctly<span class="tooltiptext">Displayed as $1,500,000m instead of $1.5m</span></td>
<td class="green">Yes</td>
</tr>
<tr>
<td class="tooltip"><code>[=1]"Yes";"No"</code><span class="tooltiptext">Display value 1 as "Yes" and everything else as "No"</span></td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="red tooltip">Doesn't display correctly<span class="tooltiptext">1 = Yes is displayed, but need to define number format as <code>[=1]"Yes";"No";"No"</code> for the No to appear correctly</span></td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td class="tooltip"><code>;;;</code><span class="tooltiptext">number is not displayed at all</span></td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td class="tooltip">Date formatting, e.g. <code>dddd</code>, <code>dd mmm yyyy</code>, <code>yyyy-mm-dd</code><span class="tooltiptext">displayed as e.g. "Monday", "31 Dec 2024", "2024-12-31"</span></td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr><td class="semititle"><br />Object features and compatibility</td><td></td><td></td><td></td><td></td><td></td></tr>
<tr>
<td>Insert shapes, arrows, textboxes, and images</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>SmartArt</td>
<td class="green">Yes</td>
<td class="lred">Can't be edited</td>
<td class="yellow tooltip">Limited editing<span class="tooltiptext">Existing text can be edited as a textbox, but there is no SmartArt input dialogue like in Excel and e.g. the number of bullet points cannot be changed</span></td>
<td class="red">Displayed with errors and can't be edited</td>
<td class="lred">Can't be edited</td>
</tr>
<tr>
<td>Mathematical formulas</td>
<td class="green">Yes</td>
<td class="lred tooltip">Yes, but Excel formulas not displayed<span class="tooltiptext">Characters in mathematical formulas created in Excel as displayed as <code>[?]</code></td>
<td class="green">Yes</td>
<td class="lred">Excel formulas can't be edited</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Group multiple objects</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Align and distribute objects</td>
<td class="green">Yes</td>
<td class="yellow">Align only, not distribute</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Save objects as picture</td>
<td class="green">Yes</td>
<td class="yellow">Only charts, not shapes</td>
<td class="green">Yes</td>
<td class="yellow">Only charts, not shapes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td class="tooltip">Apply effects on objects<span class="tooltiptext">such a shadow, reflection, glow, soft edges, 3D format, and 3D rotation</span></td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="lred">No, only very basic shadows</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr><td style="text-align: left; font-style: italic; text-decoration: underline;">Line formatting (for shapes, arrows, textboxes & charts):</td><td></td><td></td><td></td><td></td><td></td></tr>
<tr>
<td>Basic options (colour, width, dash type, arrow type)</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Gradient colour and transparency</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="red">No</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Compound style</td>
<td class="green">Yes</td>
<td class="red">No</td>
<td class="red">No</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<td>Sketched style</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="red">No</td>
<td class="green">Yes</td>
</tr>
<tr><td style="text-align: left; font-style: italic; text-decoration: underline;">Fill formatting (for shapes, textboxes & charts):</td><td></td><td></td><td></td><td></td><td></td></tr>
<tr>
<td>Colour, including gradient fill and transparency</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Pattern, picture or texture fill</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr><td style="text-align: left; font-style: italic; text-decoration: underline;">Image effects:</td><td></td><td></td><td></td><td></td><td></td></tr>
<tr>
<td>Brightness, contrast, recolour, saturation, sharpness, ...</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="yellow">Partially supported</td>
<td class="yellow">Partially supported</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Transparency</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="red">No</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Set transparent colour</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="red">No</td>
<td class="lred">Displayed with errors</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Apply object effects and picture styles</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="lred">Displayed with errors</td>
<td class="lred">Displayed with errors</td>
<td class="lred">Displayed with errors</td>
</tr>
<tr><td class="semititle"><br />Chart types</td><td></td><td></td><td></td><td></td><td></td></tr>
<tr>
<td>Line charts and area charts (normal/stacked/100%)</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Bar and column charts (clustered or stacked)</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Clustered AND stacked bar/column charts</td>
<td class="red">No</td>
<td class="red">No</td>
<td class="red">No</td>
<td class="red">No</td>
<td class="red">No</td>
</tr>
<td>Pie charts (incl. doughnut and pie of pie)</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Scatterplots (XY)</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<td>Bubble charts</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="red">Bubble size is ignored</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Radar charts</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
</tr>
<tr>
<td>Surface charts</td>
<td class="green">Yes</td>
<td class="red">Shown as column chart</td>
<td class="green">Yes</td>
<td class="green">Yes</td>
<td class="red">Shown as column chart</td>
</tr>
<tr>
<td>Treemap and sunburst charts</td>
<td class="green">Yes</td>
<td class="red">No (error notice shown instead)</td>
<td class="red">No (doesn't display at all)</td>
<td class="red">No (error notice shown instead)</td>
<td class="red">No (error notice shown instead)</td>
</tr>
<tr>
<td>Others: histogram, funnel, waterfall, stock, box & whisker</td>
<td class="green">Yes</td>
<td class="red">No (error notice shown instead)</td>
<td class="lred tooltip">Partially supported, with errors<span class="tooltiptext">Waterfall and funnel display with formatting errors, Histogram appears but without content, others doesn't display at all and without any error notice</span></td>
<td class="red">No (error notice shown instead)</td>
<td class="red">No (error notice shown instead)</td>
</tr>
<!--
<tr>
<td>Treemap charts</td>
<td class="green">Yes</td>
<td class="red">No (error notice shown instead)</td>
<td class="red">No (doesn't display at all)</td>
<td class="red">No (error notice shown instead)</td>
<td class="red">No (error notice shown instead)</td>
</tr>
<tr>
<td>Sunburst charts</td>
<td class="green">Yes</td>
<td class="red">No (error notice shown instead)</td>
<td class="red">No (doesn't display at all)</td>
<td class="red">No (error notice shown instead)</td>
<td class="red">No (error notice shown instead)</td>
</tr>
<tr>
<td>Histograms</td>
<td class="green">Yes</td>
<td class="red">No (error notice shown instead)</td>
<td class="red">No (doesn't display at all)</td>
<td class="red">No (error notice shown instead)</td>
<td class="red">No (error notice shown instead)</td>
</tr>
<tr>
<td>Funnel charts</td>
<td class="green">Yes</td>
<td class="red">No (error notice shown instead)</td>
<td class="red">No (doesn't display at all)</td>
<td class="red">No (error notice shown instead)</td>
<td class="red">No (error notice shown instead)</td>
</tr>
<tr>
<td>Waterfall charts</td>
<td class="green">Yes</td>
<td class="red">No (error notice shown instead)</td>
<td class="red">No (doesn't display at all)</td>
<td class="red">No (error notice shown instead)</td>
<td class="red">No (error notice shown instead)</td>
</tr>
<tr>