<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Enhancement request: Currently no way to insert (TXT/CSV) data from file INTO CURRENT sheet (row/column/cell)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123087">123087</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Enhancement request: Currently no way to insert (TXT/CSV) data from file INTO CURRENT sheet (row/column/cell)
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.1.6.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>enhancement
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>jlvdbc@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
In Excel you can insert data in several types (CSV / TXT) directly into the
current sheet, to be more precisely, to the current selected cell, and the data
will be added in the cells. No extra steps needed, like opening a separate
document and copy the data from there.
In LibreOffice I seriously studied how to get this done, but it seems the data
will not be added to the currently open sheet. Insert Sheet from file sounds as
A) 'data from file' + B) will be inserted (insert into what?), however it does
not insert, like you insert text, but it opens a new sheet. This is correct,
but can be confusing if you read it from the users perspective who thinks
'let´s go to the option to add external TXT/CSV data into my sheet, it must be
possible'.
How do I really add text data (from a txt file / csv file) to the current
spreadsheet? The direct way? Without opening the TXT / CSV file in another
window, select from begin to end, copy to clipboard, go to target document,
select position, paste data.
Those are much to much steps compared to Excel, in which it´s 1 click that does
this all (insert from TXT file / insert from CSV file).
NOTE: In Excel the added data from a file, is placed in the cells of the
current sheet. Inserting an OLE object in Libreoffice is not the same function:
It does not add data into the cells of the sheet, but it adds it as a separate
object, which behaves as separate data. So, you can not (easily) calculate that
data together with the data of the rest of the sheet.
CONCLUSION:
On the forum the answer was: There is no such built-in function in LO.
Actual Results:
missing option
Expected Results:
apart from how good or bad it might work, you at least expect it is a present
option!
Reproducible: Always
User Profile Reset: No
Additional Info:</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>