https://issues.apache.org/ooo/show_bug.cgi?id=111808
--- Comment #4 from [email protected] --- regina, rob, I took this task and was looking at the code to find out why RANDBETWEEN is not updated automatically; and another thing is that I couldn’t understand what the user is trying to do. With AOO calc multiple operations, you can input only two sets of data a row and a column for a formula. Can you explain more about this or generate test data, please? In my system, when I press F9 key, it increases the sound, but doesn’t update RAND. However, Ctrl+shift+F9 updates both RAND and RANDBETWEEN() cells. These are the things I got from code: RAND is an OO or built-in function with an opcode defined in compiler.hrc file, which has opcodes for all spreadsheet functions. On the other hand, RANDBETWEEN() is an add-in function and they are not assigned any specific opcodes. As far as I analysed the code, Add-in functions have an opcode of "opexternal". In main/sc/source/core/tool/odffmap.cxx, there is a collection which holds the list of add-in functions in analysis, including RANDBETWEEN; when i searched the code to find out where this collection has been used but not anywhere. The implementation of this function is in main/scaddins/source/analysis - analysis.hxx, analysis.cxx files. In /aoo-trunk/main/formula/source/core/api/FormulaCompiler.cxx, certain functions, including ocRandom-RAND, are set to have to be always recalculated, using the code pArr->SetRecalcModeAlways(); Like ocRandom-RAND, RANDBETWEEN or other add-in functions don’t have any opcode and so they can’t be set to SetRecalcModeAlways and updated automatically; This RecalcModeAlways is not set for Add-in functions, instead like all formula cells it is set to recalconload or recalconloadonce. I have already spent days in this task analyzing the code; can you please tell me your suggestions on this issue? -- You are receiving this mail because: You are on the CC list for the issue. You are watching all issue changes.
