Ask Your Question
0

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

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

this post is marked as community wiki

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

Hello,

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:

http://blogs.msdn.com/b/gabhan_berry/archive/2008/06/12/net-refedit-control.aspx

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
0

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

m.a.riosv gravatar image

Maybe you can find help in this web page.

https://help.libreoffice.org/Common/Data#Linked_cell

edit flag offensive delete link more

Comments

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:

http://support.microsoft.com/kb/213776

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 +0200 )edit

Sorry, but I can't help with it.

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

that's OK, thank you for trying

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

Maybe a good place to find information is https://wiki.documentfoundation.org/Macros

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

Question Tools

1 follower

Stats

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

Seen: 590 times

Last updated: Dec 26 '13