Ask Your Question
0

import csv to writer table

asked 2017-07-29 11:53:33 +0200

duncan_roe gravatar image

Why is this so hard? I have a 2-column CSV with titles in row 1 and I want to import it to a Writer 2-column table of the same length. Best I can do is cell-by-cell copy paste from an xterm. This should be a doddle.

edit retag flag offensive close merge delete

Comments

2

It's not hard to me. I seem to do it another way. But as you don't describe what you tried and why it didn't fit you, I'd rather not tell what I do.

Mike Kaganski gravatar imageMike Kaganski ( 2017-07-29 12:03:03 +0200 )edit

@Mike: +1

Grantler gravatar imageGrantler ( 2017-07-29 19:27:38 +0200 )edit

A Writer file is a text document. A CSV file is a spreadsheet or a database file. Thus, I can only second Mike’s comment.

gabix gravatar imagegabix ( 2017-07-29 23:57:29 +0200 )edit

3 Answers

Sort by » oldest newest most voted
1

answered 2019-04-01 07:35:05 +0200

Divad gravatar image

updated 2019-05-24 21:19:34 +0200

David gravatar image

Librebel is half correct. It doesn't work as he\she described (but yes, it should in ideal world :) ) . If works though as follows:

  1. Open a .csv file in Libreoffice Calc
  2. Select all the sheet or the part you need to insert into a Writer table
  3. Press Ctrl+C
  4. Click on the place in the LibreOffice Writer document you want to paste the info into
  5. Press Ctrl+Shift+V to activate the "Paste as..." menu
  6. When the "Paste as..." menu shows up, click on the bottom option "Formatted text(RTF)".

I did that a lot of times, it worked. Libreoffice 6.0.2.1 (x64) version.

edit flag offensive delete link more
0

answered 2019-08-01 16:04:57 +0200

kkivi gravatar image

Looks like nobody understands what the task is.

The task is to transfer calc sheet ( after column hiding, sorting and filtering ) to the final report in wrter.

Instead of understanding this task and the fact it is next to impossible every adviser states that this task has no sense. PS Paste special as RTF ignores filtering and shows traces of hidden colums.

edit flag offensive delete link more

Comments

Looks like nobody has described what the task is (until now) ;-) - and even now, you didn't follow the site's rules, and wrote as "Answer"/"Solution" what should have been edited into the question itself...

Mike Kaganski gravatar imageMike Kaganski ( 2019-08-01 16:15:11 +0200 )edit

I understand your sarcasm and admit that I have used the wrong style. However, I have an excuse

1) I was looking for the way to copy a table from calc to writer, and read plenty of stupid advice. 2) I have found the solution and can share it with the audience - PASTE AS HTML. This preserves the appearence and data.

kkivi gravatar imagekkivi ( 2019-08-03 01:14:17 +0200 )edit
0

answered 2017-07-30 04:54:18 +0200

librebel gravatar image

Hello @duncan_roe,

You could try to open the .csv file in Calc, then select all cells and copy-paste the result into Writer.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-07-29 11:53:33 +0200

Seen: 1,293 times

Last updated: Aug 01