[libreoffice-l10n] comparison list functions Calc and Excel

classic Classic list List threaded Threaded
5 messages Options
kees538-2 kees538-2
Reply | Threaded
Open this post in threaded view
|

[libreoffice-l10n] comparison list functions Calc and Excel

Hi All

The Calc Guide, chapter "Formulas and functons", refers to a list for
comparison of functions in Calc and Excel.
Op page 19 it says:

However, the majority of functions can be used in both Calc and Excel
without any change. A comparison list may be found on the LibreOffice
wiki, linked from the Documentation/Publications page.

I can't find a reference on the wiki though. Can there be added a
hyperlink in this Calc guide?
If anyone can tell me where this list can be found, I can add the
reference in the Guide, if wanted.

King regards,
Kees

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/l10n/
Privacy Policy: https://www.documentfoundation.org/privacy

Dennis Roczek Dennis Roczek
Reply | Threaded
Open this post in threaded view
|

Re: [libreoffice-l10n] comparison list functions Calc and Excel

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256


Hi Kees,

On 12.07.2019 11:23, [hidden email] wrote:
> Hi All
>
> The Calc Guide, chapter "Formulas and functons", refers to a list for
> comparison of functions in Calc and Excel.
> Op page 19 it says:
>
> However, the majority of functions can be used in both Calc and Excel
> without any change. A comparison list may be found on the LibreOffice
> wiki, linked from the Documentation/Publications page.
Uff, that's the old outdated comparison...

> I can't find a reference on the wiki though. Can there be added a
> hyperlink in this Calc guide?> If anyone can tell me where this list c
an be found, I can add the
> reference in the Guide, if wanted.
Please see:
https://wiki.documentfoundation.org/Functions_comparison_of_LibreOffice_
Calc_and_Excel

which links to two documents:
https://wiki.documentfoundation.org/index.php?title=Documentation/Public
ations&diff=next&oldid=148497
(archived version, which was moved to third party resources but never
made it to that new page; @Kenneth Hanson: any reason for that?)

So basically we are talking about MSO2013 vs. Calc 4(?) comparison liste
d at
https://wiki.documentfoundation.org/File:Excel2013_Calc_Functions_Compar
ison.ods

Before updating the Calc Guide: I guess we finally should get these
comparison up-to-date and in a useful visual way.

A few years(!) ago I started a similar page for Apple Numbers - and it
is still on my todo-list - but well...
https://wiki.documentfoundation.org/Functions_comparison_of_LibreOffice_
Calc_and_Numbers
If you look at CONVERT_ADD for example, you see why I do need much time
as I was analyzing the stuff in-depth.

> King regards,
> Kees

Best regards,
Dennis Roczek
-----BEGIN PGP SIGNATURE-----
Comment: Using GnuPG with Thunderbird - https://www.enigmail.net/

iQIzBAEBCAAdFiEEhYmMfFabYko4V91Tzj5B/c4qttkFAl0ohpoACgkQzj5B/c4q
ttnTSg/+Is8IfCJxak8QuyQsE9gRRAMItABU5bTCmpQqOmQa+szEdV9e/bLxbQCM
a36T6QC8jIe8J5k36vpkQc8Eiq7k0xkjB43yC6aYZbXJ77mar1Rnu+b4hZNm6BAK
4Hb7U6AwclLXKIRpMToZfqHw9GzVxg97c4H4ngqbx2MroxBCKKqHebnaU99grnk7
5KcRp7W5r1UBZua4dp21r4AvXOrKawIekst6lAHQgrvgl0nl8vrPUqvXNcVDxMKZ
DSF5VG9XnvYyOjg+P1CIDp25UzEVaQ/YCYBwj/vRU3X6hx1aHpjeMr0rjcM9vTSO
XfGi/DwpcjG2M422GyBpzmpJjEhGil1l/csl/lEwZXFSSKEIUMiVUcOAazj7re2R
uQSet8MG8SDOW5ZtDG/ASf+6Ks0kX+1QBOyrEjUXwn1VgYdtsoDKhLi/Ve63HmhW
XeoCboIFu6C8+dn7CVgKzO5tcCpvCPNxK7hrOOLf8NOJ282OBpYFF7M6sJqXef/B
h2UzREOkvUnxiAI3r5RsJIwx+ApoH06G3KSFuNF4RnMWpK9MGlTfhsUYmgH4MaeG
VKHuokHp+aN24nflGpdL6wi2aDZVztLn7fPN8Tg5xYt8UEah2PeHoD8N+iYkgPMi
K7MDB1W8rSFdDqAWGe1/keRtHqXNUbapvn/u8sWTCSQk3K52PvU=
=fUFP
-----END PGP SIGNATURE-----

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/l10n/
Privacy Policy: https://www.documentfoundation.org/privacy
Dennis Roczek Dennis Roczek
Reply | Threaded
Open this post in threaded view
|

Re: [libreoffice-l10n] comparison list functions Calc and Excel

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256


Hi Kees,

On 13.07.2019 07:06, [hidden email] wrote:
> Hi Dennis
>
> Thanks for answering my question.
> I understand that the list is very outdated and need to be updated.
> Maybe it is best to leave te referring out of the Guide?
> At least until the list is updated.
well basically neither MSO nor LibreOffice added thousands new
functions, so basically all the functions are still the same and still
correct; so only a "few" are missing. And I guess most users do not use
these.



> Kind regards, Kees

Dennis Roczek
-----BEGIN PGP SIGNATURE-----
Comment: Using GnuPG with Thunderbird - https://www.enigmail.net/

iQIzBAEBCAAdFiEEhYmMfFabYko4V91Tzj5B/c4qttkFAl0qB34ACgkQzj5B/c4q
ttnkrA/+MRkMLc4yJNSc1i1LCzHyqZCwBaNkmeQigKJhfPD7eLS3rrAj3E4LhsbR
+rwZvQ0FdZcnNzMo4Cr+knb892wNHdfVjPcq1GhLxyI48F2aUYilrqFFd55qHf88
GhHM6c/3kE3iprpjzyp830xWFT8kpxVpXdSSA4o7LGIqNg5CNq+O+qUBVV/fN9NN
vjwBn9DMM4OUuLi+b40pFw8fmki7v1inwNq176xICHhGTcy2Q0n5KRRtW8iCnpvL
GYGhGLKGoZSiOBvVhFu6fUlAlZ7jaqwb4zgtl4+AuRhNbRwoRhmEK1+B7/DNm2sp
IgTSH6cEcWwxX0KD8juqY0cQAkU9kSXOPhza8h0AXmSNrijSflahn6AltAxW0Bj0
JWoHEScTOhQFb/LMGHAv+uOEEIkwhKcO4w+AomxWp+hnK3DJtWxbITdHmRMH7ovd
yEgvRyJr9AcVyBHPvfh3YMXwZyUCzkfLwrKCYHq3Dnp4sh1/7nptxgB5Uuldx4Jt
Ayfn0DQafdlppwJs9+BcguN1dxdUgFAdL0BnO67yQiyAcOktbpI/ZO6MIw70u5kQ
RsoflzWNpuHUp0HbX3D8nPewPAnC3vDTKleAusgT5AG+gnehmL3wJY8eTuUU+t8q
Iu460OXOLSlFAbcmxdAJLeliwztNPqhRW+gDey6wFQFh6jY5k/w=
=22Nh
-----END PGP SIGNATURE-----

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/l10n/
Privacy Policy: https://www.documentfoundation.org/privacy
Dennis Roczek Dennis Roczek
Reply | Threaded
Open this post in threaded view
|

Re: [libreoffice-l10n] comparison list functions Calc and Excel

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256


Hi,

On 14.07.2019 07:56, [hidden email] wrote:
> Great. I will add a link to the file in the Guide.
better use some hub/tdf.io-Link, so that are able to modify the link in
the background when somebody is finally able to update the table.

Best,

Dennis Roczek
-----BEGIN PGP SIGNATURE-----
Comment: Using GnuPG with Thunderbird - https://www.enigmail.net/

iQIzBAEBCAAdFiEEhYmMfFabYko4V91Tzj5B/c4qttkFAl0rHskACgkQzj5B/c4q
ttk/mg/+Jy+/CQxEnfDu5TU+8yXEFXNLCwE0x67Kj/V5kxcGCv8ZGuaq0vfdPsuA
XSzVzDdVj2LSBRJVADQ4V8prIXPsBubSkRuP7/mib57joMlGBWullqTHbuezIAJ8
+qU/sF4nBGMqdypaGmoY+1DGs95CAQnDrl0IqRS0gyM98d2m7mXafOGO3vA1y4Q6
SUM8H0Xrcj8Oka45lFsluOjXFsKMo7pBmgLdC1LHVV3bmZumUFVMzJNct1apc3TW
2Em2znSkFu5aq6xQrI+eX9gV16EeP88Jol41AyMJmqBmpeM7HI8so0zgNV6lANEa
OSpVT72SLggK1nbEyfBiLx4/kzPyHw4TEyatnLtlbtHKTSWKM1DY2CpTzyt9CN7i
U8Op04NO07hnLXzDJU2cgGSvRQLA4qoAV3m3r6r5Mnu5vOanJ+KrFL0wIUejiOnQ
yEyLeLR6nH/zpdmZf86wM4Ya4bc9L0pX426qk/7UsP3FbnaFXUQK+r5xOqQkluR/
OLSda3itE6KU/Vic+Dq7LlA068s3qMr9ChJINqgPZxcwIyL/0yLSCPl9No7v2RXo
sXTMahpALbQrAtzbWSohkRK67u7f6vtvVOnbT2+sbQNG8yts1AVHWMCPm+AC81GF
YLSFexvUN2sAFezCOoXlOvOtBk/bp3mYUAFP1YfWLyIk6KlG1r8=
=d8C+
-----END PGP SIGNATURE-----

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/l10n/
Privacy Policy: https://www.documentfoundation.org/privacy
Dennis Roczek Dennis Roczek
Reply | Threaded
Open this post in threaded view
|

Re: [libreoffice-l10n] comparison list functions Calc and Excel

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256


Hi Kees,

> Hi,
>
> On 14.07.2019 07:56, [hidden email] wrote:
>>>> Great. I will add a link to the file in the Guide.
> better use some hub/tdf.io-Link, so that are able to modify the link in
> the background when somebody is finally able to update the table.
>
>> Sorry, I don't know what that is.
I have created one:
https://tdf.io/calcexcelfunctioncomparison

Use that link. We are able to change the tdf.io-Link in the background
if we finally update the comparison.

If you have any questions, don't hesitate to ask me.

Best Regards,

Dennis Roczek
-----BEGIN PGP SIGNATURE-----
Comment: Using GnuPG with Thunderbird - https://www.enigmail.net/

iQIzBAEBCAAdFiEEhYmMfFabYko4V91Tzj5B/c4qttkFAl0tl3EACgkQzj5B/c4q
ttnH0BAAwD/C5W/UWz+Nu0wXWQOjs6+SXR317w5mlFcPK1oamUVR7hjtXVLqYle3
AdS62rQwcQKXsjf1Gg1bV5dBLjcigZD5PdsTvofphA51+R8IeCObtfAJtlM71ik9
/lzKbWqKnU0zM3yqvp+s74hLhiiE07P6dLaJQJoEbKCdurB/ZYeeh+cCHpXsEhQS
rCb+qDdIhPB9886kp6GeTo+2EpN5fOeB3xtdEkrdWJrD6aH138jsa+hSu+b/UgJa
uvIXVq1+IXnzkF/1nqZMCG0kNUya1iV4hZR42I/Na5Ub64beQwP0uzVHqS/0/5Sc
zO5sMg3fYc5a62v/70kXnHv8pYlENOMo2iGTrYPLPRJg2Ac98nY9AbXYHAMJo8WZ
80F2iAMURD8Sm0xBJxwnGuUJSG6jWeIXLBCoDVHh6IuuNwOM9jkXyxkVawMpOex4
0sVSzKfBvuwGu7BUoHnqfAe5re+vCpjF/99EjQTvnZJeNk3dt1Xogf8COhA6EQm3
ibWivrDAA5CZyaXUM3VHDDGEaUvWKzQfjPnEvan1LZX84LdaPxW5RjdaqZzU3Znt
Tkn9Q0ggmAZuynfyHGFWUY9MyqH9uEOa8bc/eYnzqRvnNLqo9omE7oMoiZBnsh1H
0/eLwF+ujFaFtVb8+ekSOhSH8SQAq2T1mVCB/7uLBrh0pVM8Hyw=
=QJpf
-----END PGP SIGNATURE-----

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/l10n/
Privacy Policy: https://www.documentfoundation.org/privacy