RE: [PATCH] improving ses-jump for accepting cell names as lowercase

["Vincent Belaïche" <vincent.b.1@hotmail.fr>]

[-- Attachment #1: Type: text/plain, Size: 2393 bytes --]

Hello,

Please note that cells can be renamed and you have auto-completion on renamed cells.

Concerning the letters case, maybe it would be even more flexible if the user had some sort of hook function to pre-process cell names that are not in the renamed cell list, then you could set this function to upcase, but some other setting could allow to enter some coordinate.

Rahter than applying your patch, I can update the code in this way.
   V.
________________________________
De : Vincent Belaïche <vincent.belaiche@gmail.com>
Envoyé : jeudi 10 mars 2022 13:26
À : Vincent Belaïche <vincent.b.1@hotmail.fr>
Objet : Re: [PATCH] improving ses-jump for accepting cell names as lowercase

Le mer. 9 mars 2022 à 16:20, andrés ramírez <rrandresf@gmail.com> a écrit :
>
> Hi. Lars. My comments below.
>
> >>>>> "Lars" == Lars Ingebrigtsen <larsi@gnus.org> writes:
>
>     Lars> andres.ramirez <rrandresf@gmail.com> writes:
>     >> This patch improves ses-jump a little bit.
>
>     Lars> [...]
>
>     >> - (user-error "Invalid cell name") - (list (intern s))))) + (user-error "Empty cell name") +
>     >> (list (intern (upcase s))))))
>
>     Lars> I've never used ses before -- do cells have only upper-case names?
>
> This is my gut feeling. I started using ses a couple of year ago. It
> is really handy having a networked spreadsheet software :). Org-mode
> tables are handy for simple things But for a little bit complex
> calculations ses-mode is paramount.
>
> This code comes from 2002. I think It should be around emacs19 or
> emacs20. At that time it was just the TUI for emacs. Probably at that
> time ses-jump was not so useful as it could be today. I could be
> wrong. But nowadays We have 'display-line-numbers'. So When activating
> display-line-numbers it is simpler to use ses-jump as we have a
> line-number indicator at the left of the frame.
>
> Back to your question. In the past lotus-1-2-3 used to have just
> upper-case names on rows. So probably the answer is Yes.
>
> JIC I am going to Cc the author and the maintainer. Perhaps They could
> tell us about it. I have skimmed the code and have not found the answer.
>
> Also I am sharing a couple of images for giving You a better idea:
> ,---- [ cli ]
> | http://0x0.st/oPDb.png
> `----
>
> ,---- [ lucid ]
> | http://0x0.st/oPDc.png
> `----
>
> Best Regards

[-- Attachment #2: Type: text/html, Size: 3789 bytes --]