Bug 152392 - [wish] paste spreadsheet data into a latex table
Summary: [wish] paste spreadsheet data into a latex table
Status: CONFIRMED
Alias: None
Product: kile
Classification: Applications
Component: general (show other bugs)
Version: trunk-kde4
Platform: Compiled Sources Linux
: NOR wishlist
Target Milestone: ---
Assignee: Michel Ludwig
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-11-15 22:07 UTC by FiNeX
Modified: 2023-01-08 20:29 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description FiNeX 2007-11-15 22:07:15 UTC
Version:           Revision 737231 (using KDE Devel)
Installed from:    Compiled sources
OS:                Linux

It should be useful in the insert table wizard, to paste data directly from a kcalc spreadsheet.
Comment 1 albert 2008-02-05 12:25:48 UTC
And from OpenCalc too...
Comment 2 Daniel Tiemann 2008-05-04 02:06:54 UTC
Hi albert
if you mean OpenOffice.org Calc... are you aware of the calc2latex macro, which is available at calc2latex.sourceforge.net ?

Regards,
Dan
Comment 3 FiNeX 2008-05-05 11:22:08 UTC
Moreover data tables would come from different sources like:
- OpenOffice Calc
- Koffice Spreadsheet
- Gnumeric
- MS Excel
- Simple text file like a matlab/octave matrix

The "create table" wizard could implement a way to import data from files
OR
it could be smart enough to managed "copied" data from different sources and let to paste in.
Comment 4 Daniel Tiemann 2008-05-05 12:42:16 UTC
Yep the source package independence is a good point FINeX,


The import from file may be more difficult to implement as eg one excel file or calc file may contain several tables and images - so you need a preview in order to select what you want.

How does the table content look like when it's copied into memory? For easy copy and paste the entries are always separated by tabs and newlines, right? What happens with the formatting when using copy and paste?

I think I would like (additionally) a paste feature to be implemented into the pop-up menu (right mouse button click) in form of a "paste as LaTeX table" entry joining the already present "paste as LaTeX". So you can easily paste the previously copied table at the point where you wish.
Comment 5 Michel Ludwig 2011-04-23 11:27:18 UTC
Git commit 08fde16d3e64e936867fee37cd8b179e47286300 by Michel Ludwig.
Committed on 23/04/2011 at 11:33.
Pushed by mludwig into branch 'master'.

Add the possibility to copy tables from the clipboard into the tabular wizard.

Patch by Felix Mauch, committed with some small modifications.

CCBUG: 152392

M  +9    -1    doc/index.docbook     
M  +20   -3    src/dialogs/tabular/newtabulardialog.cpp     
M  +5    -2    src/dialogs/tabular/newtabulardialog.h     
M  +71   -13   src/dialogs/tabular/tabulartable.cpp     
M  +4    -0    src/dialogs/tabular/tabulartable.h     

http://commits.kde.org/kile/08fde16d3e64e936867fee37cd8b179e47286300