Calc does not recognize tab separators in dropped or pasted

[kklare]

I'm having drag-and-drop Text Import problems with new defaults. Mostly annoyance. It does not set Tab delimiter and it sets "Quoted field as text." Different action from before.

The real problems is they reset on every drop with no memory.

-Ken

[pluby]

[kklare]

DOW JONES -376.36 10068.01
NASDAQ -94.36 2204.01
S&P 500 -43.46 1071.59

Highlight the above 3 lines and drop in the include SS at cell A2.
I have replace multiple spaces with a tab using BBEdit.

You will get a dialog not easily copied so shown schematically:
...
Separator options------
O Fixed width
* Separated by
O Tab O Comma O Other ______
O Semicolon...
Other options ------
* Quoted field as text
O Detect special numbers
...
Where O is circle or box unchecked and * is checked.

I checked tab and unchecked quoted field. That is bad enough but if you try dropping it again, you get the original dialog again with nothing being remembered, so you do it all again. Might also try in 3.0.2 if you still have it.
-Ken

--------
Regarding the width being adjusted without consent to some previous SS, why does it not adjust the height, too?
-Ken

[pluby]

I can reproduce this behavior also by replacing the spaces with tabs in the TextEdit application, copying the text, and then using Edit :: Paste Special and pasting as "Unformatted Text".

There is definitely a bug there as I can reproduce this behavior in my Go-oo installation but not in OpenOffice.org 3.1.1. That means that one or more of the OpenOffice.org code modications made by Novell's Go-oo engineers is causing this bug.

What you describe as "not remembering" is actually a symptom of the real bug: the Go-oo modifications thinks tab characters are arrows. If you look at the grid at the bottom of the dialog, you will see arrow characters where there are tabs in the original document.

What should happen is that when the dialog appears (and it should always appear), the "Tab" checkbox in the "Separator options" section should always be checked and the grid at the bottom of dialog should have 3 columns so that you only need to press the Return key or click the OK button to import the data correctly.

I will investigate this bug and see if I can determine which Go-oo modication is the cause. Once I find which modification is the cause, I will remove it from the NeoOffice code and post a test patch for you to try.

FYI. I have split this new bug into its own separate topic to more easily track it.

Patrick

[kklare]

[narf]

FYI: I have created bug 3606 to track this issue.

Fran

[pluby]

I think that I have fixed this bug. Can you install the following test patch and tell us if the bug is fixed for you?:

Intel:
http://joe.neooffice.org/test/NeoOffice-3.1.1-Patch-0-Test-4-Intel.dmg

PowerPC:
http://joe.neooffice.org/test/NeoOffice-3.1.1-Patch-0-Test-4-PowerPC.dmg

Patrick

[kklare]

Thanks, seems to work for the drag-and-drop/tab-paste case I use each business day. No change to memory for the "Quoted field as text" although it probably doesn't matter for my case anyway--no quotes needed.

Memory does work for paste special (cmd-shift-V) so it can be done. Took a couple hours out for TV, away from the MacBook and doing the daily stock update, always in hope.
Again thanks, -Ken

[pluby]

I found that Novell's Go-oo engineers explicitly disabled remembering the various checkbox settings in that dialog when you are pasting or dragging date.

That seems odd to me so enabled that code in all cases in the following test patch. Can you install the following test patch and tell us if the dialog now remembers the various option checkbox settings? Hopefully enabling this feature does not cause any new bugs to appear:

Intel:
http://joe.neooffice.org/test/NeoOffice-3.1.1-Patch-0-Test-5-Intel.dmg

PowerPC:
http://joe.neooffice.org/test/NeoOffice-3.1.1-Patch-0-Test-5-PowerPC.dmg

Patrick

[kklare]

Sorry Patrick, I don't see any difference from test 4 (Intel). I checked a whole bunch of delimiters (apparently all apply) and uncheck quoted--still not sure what it does. OK'ed and did it again with only the tab and quoted check coming up. So no memory within the session on even one sheet. Tried pasting too.
-Ken

[pluby]

You are right, it does not work for me either. I had thought it was working when I did some light testing this morning but apparently I did not test is thoroughly.

I will look at the code again tomorrow and see if there is anything else in the OpenOffice.org code that I can change.

Patrick

[pluby]

OK. I think I found the right Go-oo code to disable and now in the following test patch all of the checkbox settings in that dialog are remembered when I paste or drag CSV data. Does the test patch work for you?:

Intel:
http://joe.neooffice.org/test/NeoOffice-3.1.1-Patch-0-Test-6-Intel.dmg

PowerPC:
http://joe.neooffice.org/test/NeoOffice-3.1.1-Patch-0-Test-6-PowerPC.dmg

Patrick

[kklare]

I think you've done it, I think you've done it...or whatever it was in the movie.
-Ken

The only thing I have to watch is if I do a text scroll (two fingers on the trackpad) I change the language and that could be trouble, forgetting it is unicode, I guess. Or better System?
-K

[pluby]

[kklare]

I've just got to be careful and not drag another finger while moving around. My problem, although maybe if "nothing" was selected instead of the first box it might be safer (from me.) I hadn't caught that it was reset each time. Thanks for your patience.
-Ken