Description: There are many discussion on Active Cell.(for example: https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=89911#:~:text=Loop%20through%20the%20cells%20of%20the%20range%20and,mean%20the%20cell%20currently%20having%20the%20input%20focus.) I try to use the Excel xlsm approach. It works in Calc, however, only single time. After Calc saves the file and reopen it, it will never function any more. Steps to Reproduce: 1.making the xlsm file in Excel 2.open the xlsm file in Calc, click different cell and check the response in the cells of A2, A3 and A4 3.save the file in Calc, close the file and reopen the file in Calc or Excel, the cell, neither A2 nor A3 nor A4, does not response to mouse click any more. Actual Results: Function related with Active Cell lost when reopen the Calc saved file. Expected Results: Function work as the first open the xlsm file. Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Linux (All) OS is 64bit: yes
Created attachment 178560 [details] xlsm file for ActiveCell function generated using Excel From the point of security, macro is not a good choice. I hope Calc can give a function, something like getValueinNameBox() to access the Active Cell easily.
Reproducible in: Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: b965efc0ab5d6996417c92b5588e9d1ff79e0572 CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded