InfoQube IM - Community

Submitted by Tom on 2015/11/24 16:29

Pasting multiple lines and choosing the option to 'Paste each line into a separate item etc.'

=> if your lines start with the '#' symbol, they will not paste.

(I create a new blank line and paste in that -- the new lines are created as appropriate, but they are blank.)

Reproduced in Sample file with and without WYSIWYG setting.

Thanks Pierre! Apologies for 'bugging' you

(my only excuse for that bad pun is that I'm still working @ 10:30 PM...)

Comments

More trouble with pasting multiple lines:

I'm trying to paste the following into a column :

It's plain text
I select the first relevant cell
Ctrl+V and select the option to "paste each line in a separate item etc."

I expect the following lines to be pasted in the sibling items below the selected item.

Here's the text:

Firstly *nothing* is getting pasted (see #4 though)
Secondly, new items are being created when AFAICS there is no need
the are 13 lines in the text - yet only 10 new items are being created
I just tried again and it pasted lines 3 through to 13, again creating new items instead of using available siblings

# 4 is reproducible in sample file:

_______________________________________________________

Win.7 64bit ~ IQ 0.9.26Pre-Rel62

I dont think I'm misunderstanding how paste in multiple lines works. Read on:

When I paste text with multiple lines in a selected cell, and choose "Paste each line into a separate item, creating new items if necessary" --

it creates new items when this is unnecessary.

items 1.6 to 1.13 were created on pasting - there were another nine sibling items below 1.5, but IQ ignored these for some reason.

[quote=Tom]

I dont think I'm misunderstanding how paste in multiple lines works. Read on:

When I paste text with multiple lines in a selected cell, and choose "Paste each line into a separate item, creating new items if necessary" --

it creates new items when this is unnecessary.

items 1.6 to 1.13 were created on pasting - there were another nine sibling items below 1.5, but IQ ignored these for some reason.

[/quote]

Are there empty lines/ines with tabs in there? What you're showing happens here when I'm copying some text with carriage returns + tabs. (I paste quite a bit and don't think I've seen that recently)

Disclaimer: "Testing IQ with the most advanced/complicated IQBase in the world". I.e. slower than average.

Windows 8.1

CPU: Intel i5 2.6ghz

[quote=Armando]

Are there empty lines/ines with tabs in there? What you're showing happens here when I'm copying some text with carriage returns + tabs. (I paste quite a bit and don't think I've seen that recently)

[/quote]

I dont think so but I'm not sure -- it was copied from an excel file.

Looked like this on mouser's CHS clipboard extender:

Note:

I typed a simple list of words with carriage returns in a text editor:

dog
frog
tick
cat
fox
lox
dox
frig
dig

and got exactly the same result - there was definitely no tab in this text.

So, very reproducible here *and* I am unable to produce the expected behaviour.

IQ Version: 0.9.70a build 2016-02-11 20:57:28 [portable]

Win.7 x64

Hi Tom,

Can you zip a text file and attach it here or by private mail ? I'll look into it. v71 is coming soon and I'd like to include this fix

Pierre_Admin

IQ Designer

^ I can reproduce it if I simply copy the list of words in my previous post and paste them in IQ.

Text file attached with the same list.

Sorry Tom, but I fail to understand what you mean here. Please provide the steps to reproduce the issue. The text file you supplied in another post works fine does it not ?

Pierre_Admin

IQ Designer

[quote=Pierre_Admin]

Sorry Tom, but I fail to understand what you mean here. Please provide the steps to reproduce the issue. The text file you supplied in another post works fine does it not ?[/quote]

no, nothing works here -- I mean that new items are always created when I paste multi-line text into a cell - even if there are a bunch of siblings below said cell.

I'll repeat what I said above and try make it clearer (but I think the problem here is simply that it is working for ye, but not for me).

Copy multi-line text
Paste into cell: in screenshot below, I pasted into Item 1.5 (second column). Item 1.5 has multiple siblings below it. On paste, I selected "Paste each line into a separate item, creating new items if necessary"
Instead of pasting said text into item 1.5 and the many siblings below it, IQ created new items (1.6 - 1.13 in screenshot) -- one per carriage-return in the text

this is fully reproducible here

What happens there when you follow these steps?

OK I get it. I bet that you did not select cells before pasting...

The way it works is as follows

IQ checks the number of line in the clipboard
For each of the selected cells, it pastes 1 line
If there are more lines in the clipboard than selected, it creates items

HTH !

Pierre_Admin

IQ Designer

[quote=Pierre_Admin]

OK I get it. I bet that you did not select cells before pasting...

The way it works is as follows

IQ checks the number of line in the clipboard
For each of the selected cells, it pastes 1 line
If there are more lines in the clipboard than selected, it creates items[/quote]

okay, I never knew that.... or if I did, I forgot it again.

Been using spreadsheets a lot lately and thought it worked like in Excel / spreadsheet programmes.

EDIT// thanks for the dialogue improvement Pierre

In v71, I've improved the Paste options dialog:

HTH !

Pierre_Admin

IQ Designer

Fixed in v63

thanks Pierre :up: