Tuesday, March 25, 2014

Re: Vim Spreadsheets

On Tuesday, 25 March 2014 11:47:42 UTC, Pierre Masci wrote:
> Hi there, 
>
>
> I'm thinking using Vim for spreadsheets, for a few reasons:
>
>
>  - you can diff it ! (For me, that's the main reason)
>
>  - vim key mappings
>  - vimscript, so I can easily program it myself
>
>
>
>  - easy to add my own key mappings
>  - faster to open and save than Libreoffice
>
>
> I've done a bit of research and found these so far:
>
>
>
> - csv.vim:      
>
>
>       http://www.256bit.org/~chrisbra/csv.gif
>       https://github.com/chrisbra/csv.vim
>
> inspired by this advice for CSV files:
>        http://vim.wikia.com/wiki/Working_with_CSV_files
>
>
> seems to be maybe the best one at the moment... I haven't had the time to try it out yet


I just use the code from the "Working_with_CSV_files" page (although I think there were a couple of updates to it recently I haven't tried) and it works well for my simple CSV needs - highlight a given column, copy or delete or search it.

Out of curiosity some time ago I tried replacing it with csv.vim, I didn't really need the extra functionality and for fairly trivial reasons I went back to the previous code. (I couldn't get the cosmetics of the colourscheme to match what I already had, and didn't have too much time to tweak it properly to work as I wanted.)

If I was starting from scratch or starting to do more complicated work on CSV files I would go for csv.vim and learn how to use it.

> - spreadsheet.vim:
> http://www.vim.org/scripts/script.php?script_id=558
>seems dead (not updated for 11 years now). But might do the job anyway?

Don't use Libreoffice myself but from Wikipedia it "is capable of opening and saving most spreadsheets in Microsoft Excel file format". If that includes the newer XML file format, and that's what you might use - presumably this plugin was developed long before that and wouldn't suit.

<snip other options>

>
> Has anyone used any of these? How was it?
>
> Cheers =)
>
> -- Pierre Masci

regards,
Geoff

--
--
You received this message from the "vim_use" maillist.
Do not top-post! Type your reply below the text you are replying to.
For more information, visit http://www.vim.org/maillist.php

---
You received this message because you are subscribed to the Google Groups "vim_use" group.
To unsubscribe from this group and stop receiving emails from it, send an email to vim_use+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments: