Ask Your Question

What is the equivalent of Excel's RefEdit in Libre's Dialog form? [closed]

asked 2013-11-24 22:18:13 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.


I was trying to recreate in Libre Calc a UserForm I made in Excel. Everything seems to be fine except I cannot find any control to get cell references, i.e. functionality provided by RefEdit control in Excel. Is there anything like that? If not, can any other control be twigged into accepting cell references in a similar way? For those not familiar with the RefEdit, the control allows inputting cell addresses by selecting the ranges while the UserForm is open.

P.S. I found a webpage describing coding a RefEdit-like control:

Can this be adopted for LibreOffice?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-16 18:26:09.429946

1 Answer

Sort by » oldest newest most voted

answered 2013-11-26 22:40:20 +0100

m.a.riosv gravatar image

Maybe you can find help in this web page.

edit flag offensive delete link more


Unless I'm missing something, the info on that page is unrelated to my question. Just to make it a little clearer, here are the link to the RefEdit page:

Here is the discussion for RefEdit control in .NET.

I could probably adopt this code but if there is a cleaner solution I'd rather use that.

sargdavid gravatar imagesargdavid ( 2013-11-27 18:08:48 +0100 )edit

Sorry, but I can't help with it.

m.a.riosv gravatar imagem.a.riosv ( 2013-11-27 19:36:19 +0100 )edit

that's OK, thank you for trying

sargdavid gravatar imagesargdavid ( 2013-11-27 20:27:00 +0100 )edit

Maybe a good place to find information is

m.a.riosv gravatar imagem.a.riosv ( 2013-11-27 23:47:51 +0100 )edit

Question Tools

1 follower


Asked: 2013-11-24 22:18:13 +0100

Seen: 621 times

Last updated: Dec 26 '13