Request for comment: Adding feature to calculate Org table reference from selected text region

Request for comment: Adding feature to calculate Org table reference from selected text region

[Charles Choi]

Hello folks!

I recently made a blog post describing a means of calculating an Org table reference from a selected text region or rectangle. I think this feature is compelling enough to put into Org itself and as such I am raising this idea with this group to gauge interest.

This idea and its implementation are detailed in http://yummymelon.com/devnull/referencing-org-table-cells-with-text-regions.html

I'm happy to respond to any feedback on this idea here. Also to clarify, I'm much more interested in feedback for the idea and less so on its current implementation. It is my hope that if the idea of it is appealing enough, an optimal implementation can be made by this group.

Thanks and best regards -

Charles

—
Charles Y. Choi, Ph.D.
kickingvegas@gmail.com

[RFC] Insert reference to Org table cell or cell range from region selection (w/without mouse)

[Ihor Radchenko]

[ Changing subject line, so that the thread is registered as a proper request for comments ]

Charles Choi <kickingvegas@gmail.com> writes:

> I recently made a blog post describing a means of calculating an Org table reference from a selected text region or rectangle. I think this feature is compelling enough to put into Org itself and as such I am raising this idea with this group to gauge interest.
>
> This idea and its implementation are detailed in http://yummymelon.com/devnull/referencing-org-table-cells-with-text-regions.html

It would be nice if you summarized the feature request in a few
sentences in the email. The link may or may not be available for future
readers in 10+ years from now.

AFAIR, the idea is roughly the following:

1. Currently, users need to type table cell references manually in table
   formulas:
   #+tblfm: @1$2+@5$4

2. Manually counting cells is not fun
3. We do have M-x org-table-edit-formulas where you can use S-<arrow> to
   change the existing cell reference, but it still requires having a
   reference to start with

4. The proposed feature is inserting a cell/range reference from mouse
   click/drag, as it is done in GUI spreadsheet apps (like Libreoffice calc)
        
> I'm happy to respond to any feedback on this idea here. Also to
> clarify, I'm much more interested in feedback for the idea and less so
> on its current implementation. It is my hope that if the idea of it is
> appealing enough, an optimal implementation can be made by this group.

As we briefly discussed during the meetup, I believe that we can
integrate mouse support into M-x org-table-edit-formulas:
- when in fedit buffer, clicking/dragging on the original table should
  insert reference into the formula buffer

Your idea about a command to copy reference to cell/region at point also
makes sense (be it a context menu entry to a simple key binding/M-x command)

> ... an optimal implementation can be made by this group

I was hoping that you will be the person sending patches ;)
At the end, you were interested enough in the feature to write the blog
post. So, you are probably the most motivated as well.

-- 
Ihor Radchenko // yantar92,
Org mode contributor,
Learn more about Org mode at <https://orgmode.org/>.
Support Org development at <https://liberapay.com/org-mode>,
or support my work at <https://liberapay.com/yantar92>