Combinatorics formulas - 2.0.0

Extension contains macros to generate formulas: Combining Variations without repetition Variations with repetition Factorial After generating these formulas can be used in other spreadsheets such as Gnumeric, Excel spreadsheets, and all of which are compatible with the ECMA International. It is also the purpose of this release. It is also the reason for limiting classes. Minimum class "k" is 2 and maximum 10th Maximum possible "n" limited to 32766 (INTEGER data type - a combination, variation etc.). Only because otherwise factorial factorial for the "n" = "k" = 10. Another purpose is to introduce Factorial differently than we used to. Therefore factorial equipped substitution set and also because extension includes three examples of applications for faktiriál. Custom values are entered directly into macros, but in the context of use in other spreadsheets requires manual modification of potential. This is done through dialogue, "Find and Replace". How to proceed is done mainly through video tutorials on YouTube and theoretical issues are linked to the home page of the author.

Release Details

Formulas combination variations with repetition, repetition and variation without factorial for use in spreadsheets. Combinatorics formulas 1.0.0 is the first version and deals only with combinations for spreadsheets LibreOffice and Apache OpenOffice. Outside macro that generates a formula combining up Combin(n = 32766; k = 1024), there is also a fast DEMO generator combination with limited functionality and 5 template files. Combinatorics formulas 2.0.0 is the second version which is focused mainly on factorial to which are added 3 examples. But enlargement also fulfills another task. It contains a formula combinations, variations with repetition, variation without repetition and factorial that can shape formulas of use in all different spreadsheets such as Gnumeric or Excel, etc.


CC-by-sa-v3 (Creative Commons Attribution-ShareAlike 3.0),


LibreOffice 5.1,


Available Downloads

Legal Disclaimer and Limitations for Downloads

The Document Foundation has not reviewed, and cannot review, all of the material, including computer software, available on or by means of The Document Foundation's
websites, and cannot therefore be responsible for that material's content, use or effects. By operating its websites, The Document Foundation does not represent or imply that it endorses the material there available, or that it believes such material to be accurate, useful or nonharmful. You are responsible for taking precautions as necessary to protect yourself and your computer systems from viruses, worms, Trojan horses and other harmful or destructive content. The Document Foundation's websites may contain content that is offensive, indecent or otherwise objectionable, as well as content containing technical inaccuracies, typographical mistakes and other errors. The Document Foundation's websites may also contain material that violates the privacy or publicity rights, or infringes the proprietary rights, of third parties, or the downloading, copying or use of which is subject to additional terms and conditions, stated or unstated. The Document Foundation disclaims any responsibility for any harm resulting from the use by The Document Foundation's visitors of The Document Foundation's websites, or from any downloading by those visitors of content available on or by means of The Document Foundation's websites.


Content contained on The Document Foundation's websites, including these Legal Disclaimers and Limitations, may be changed at the sole discretion of The Document Foundation and without notice. You are bound by any such updates or changes, and so should periodically review these Legal Disclaimers and Limitations.

If you believe any file is present on the site contrary to any TDF rule or applicable law, please supply full details to for impartial consideration.