https://bugs.freedesktop.org/show_bug.cgi?id=72417
--- Comment #2 from Petr Neudek <[email protected]> --- Created attachment 90395 --> https://bugs.freedesktop.org/attachment.cgi?id=90395&action=edit Basic Library Sorry about that. I tested the load Calc. Preparing extensions "Combinatorial formulas". Macro generates a formula combining, Variations without repetitions and variations with repetition and Factorial (it can also Variations without repetitions, but the reason it has). - When developing patterns easily overload occurs machine - I tested what happens when you type "Expad all" formula for the factorial (10) = 3,628,800 rows. - The development should report the impossibility of operations. This will prevent the fall of LO (AOO) - The formulas but do not test capabilities of the machine and the fall is often overload. - The error showed me sometime after the 3rd a system crash or not work "smaller factorials that fit easily". - Matrix syntax to use only the factorial and variations without repetition. -------------------------------------------------- ---------------------------- I enclose my library for factorial n = 10th There are 2 types of patterns. Hence follows the story of manipulation. ------------------------------------------------------------------------------- After running the macros are generated two lines: 1 the lines are just starting numbers (this is for all the different patterns of the same) Second line are custom formulas that are copied normally (array is just in line) ------------------------- Patterns in the final version offers more options dialogue (No expand, expand automatically keep the formula, leaving only numbers and "associative table" - a system of reference in which it is possible to read anything - such as disordered alphabetic character, a word, and the like - the ability to encrypt a huge compression ...). Offers in the library is not complete and solves the problem of how to overload using the On Error GoTo ... But the patterns are functional for manual copying. ------------------------- The library is a macro GetFactorial10_i plus "normal" = GetFactorial10. Both works "well", but the formula "normal" (without the "i" at the end) depending on which line starts. These formulas must be correct for the start line MOD (FACT (x)) = 1 This defect removed in version GetFactorial10_i. This version creates its own order (yellow background). ------------------------- The problem up long tables of formulas in other columns (sheets and workbooks) I have almost solved, but only for version numbers alone (formulas and associative table not) -------------------------------------------------- The purpose of the formula, GetFactorial10_i the user (start at the cursor) The purpose of the formula, GetFactorial10 the preparation of user functions similar to the functions ROT13. Sorry about that. It could have causes other than the fault LO Calc. I'll check and write. Thank you Petr -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
