https://bugs.freedesktop.org/show_bug.cgi?id=72417
--- Comment #4 from Petr Neudek <[email protected]> --- Thank you very much for the warning. It was not a mistake. but the intention. - I tested brute force what happens when someone makes a similar mistake when manually copying. - Also, I wonder how it will behave Calc new concept. -------------------------------------------------- -------------------------- - Current computer can not handle a million rows and 11 columns with formulas. It can reduce the load so that the intermediate operations using the formula changed to mere numbers. The formulas are quite different handling than the classic script. Therefore, there is a built copy clipboard and pasted back values without formulas. The first block patterns will remain active and are easy to copy, and then paste in the end - and repeats it. When the response decreases (it slows down). This time, they (the essence of the test). Also it is the principle of "wrap" if a million rows is not enough. - Out of curiosity, I have not set the end - test all the way down when the computer stops responding. Then he must throw LO and restarting recovery begins. -------------------------------------------------- -------------------------- That's what I did with differently sized blocks (estimate optimization). I noticed a strange behavior (edit line should show instead of formula number - and I've seen). So I have this operation done by hand and appeared just described error. Calc refused to insert a value, even for relatively small blocks. Restart LO did not help - the one I made repeatedly and for an extended period of 30 minutes. That's why I made this error message. I was convinced that it is the fault of the program. I was aware of one's mistakes. The first time I forgot that I can not press the dialogue "Expand all". Then I just used instead of dialogue test macro. -------------------------------------------------- -------------------------- Today I continued to test other macros, and I found a strange behavior of others. About an hour ago I found out that apparently behaves differently GeneralFunction.COUNT function. Originally behaved as a function of the workbook COUNTA. Now he acts really as COUNT - text does not. Actually I do not know what is right. -------------------------------------------------- -------------------------- So I returned to the matrix patterns. There is not text, but for sure. And suddenly learns that Calc is working as it should. I wanted to restart the computer. So it's just a mistake in my test. Like you but I think that the bug has survived several restarts LO in long intervals. It probably is not right. So probably not a bug LO. Even better wait until tomorrow and then I mark as resolved. Array formulas I and other macros and still being tested. Thank you and again I apologize 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
