InfoQube IM - Community

Submitted by gregory on 2014/05/09 23:22

I have a long list of items stored in Microsoft Word. The list has been numbered using the built-in Word numbering facility.

When I try to paste the list into IQ, I am asked whether I wish to create separate items, which I do. The result is strange. Items in the list which start with a number are recorded in IQ as a new item whose text contains only the number. The text which follows the number is lost, it does not appear in IQ.

Some of the text from Word contains lines which do not start with a number. These lines are correctly recorded in IQ - the text is visible.

It's easy to work round this problem: copy the text into a new Word page and remove the numbering before the copy from Word and paste to IQ.

Best regards

Mark Gregory

Comments

Hi Mark

The problem is that numbered lists in Word contain tabs and IQ interprets tabs as column separators. This behavior is very useful in general, as it allows to paste the content of a table (from the web or whatever) directly into IQ. I do that frequently.

However, with text containing tabs (e.g. numbered lists) it can be annoying, as you noticed.

To workaround this you can do as you suggested, or

1- first copy the list in a text editor and convert tabs to spaces, then copy/paste in IQ

2- or copy your list in a text document and import it to IQ using the "hierarchical data" option.

That said, maybe IQ could ask the user how tabs should be interpreted when stuff is pasted to the grid? Is this the typical behavior in other apps ?

-------------------------------------------------------

Windows 8.1

Sony Vaio S Series 13 (SVS131E21L)

Ram:8gb, CPU: Intel i5-3230M, 2.6ghz

Hi Armando.

As always, your reply makes sense.

Excel gives you the option to decide how to interpret tabs - but like IQ, Excel does rather assume that you know that you're doing. Software needs increasingly to be forgiving / understanding, n'est-ce pas ?

Mark Gregory, Rennes, France - GMT +1/+2; EST +6