Is there RefEdit control equivalent in Libre Calc?

Question

Does anyone know what is Libre Calc’s equivalent for Excel’s RefEdit control? All other Excel UserForm controls seem to have corresponding controls for Libre Dialog forms. If there isn’t one, is it possible to tweak some other control (like Combo Box) into behaving like reference input box?

For those who don’t know RefEdit, it is the control that lets the user specify range address. More detailed explanation is e.g. in How to code a .NET RefEdit Control on Gabhan Berry’s Excel Programming blog or in KB213776.

score 1 · Answer 1 · answered Oct 19 '20 at 13:30

1

Yes, there is such a possibility - you must use XRangeSelectionListener

By setting different RangeSelectionArguments you will get different picker behavior.

An example of a macro that is shown in this animation is here RefEdit_Demo.ods

answered Oct 19 '20 at 13:30

JohnSUN

2,268
2
5
12

Thank you @JohnSUN. I'll update this tread once I test this solution but it seems to be what I needed. – Davit Sargsyan Oct 20 '20 at 14:23

Is there RefEdit control equivalent in Libre Calc?

1 Answers1