copy/paste from Excel on MacOSX

Submitted by evaristo2k on Wednesday, 23 March, 2011 - 11:38

When I copy/paste a selection of cells from Excel into Jedit, I get rows incorrectly separated and they appear as concatenated in one line.
Closing and reopening the file, the rows become correctly separated into different lines. It seems a problem related to how Jedit is rendering cells pasted from Excel.

This happens with the latest Jedit release (stable or daily RC) and working on MacOSX only (the same release on Windows behaves correctly).

Which is the problem?

Thanks,
Eva

Workaround

by Robert Schwenn on Thu, 24/03/2011 - 19:29

Don't know a solution. But I guess that You don't have to close and re-open the file. It should be sufficient to save the file and maybe to reload it (File -> Reload).

Robert

by evaristo2k on Wed, 30/03/2011 - 17:59

Yes, thanks just saving and reloading it works.

But there's a more general problem maybe related to this. The default saving option in Unix format (\n as new line) doesn't work. The file is saved in an incorrect format. I don't understand if it is Mac format (\r\n) or a different one.

Bye,

Ale

Buffer Options

by Robert Schwenn on Wed, 30/03/2011 - 19:31

I think that the default line separator only applies to new buffers. Existing files are opened and saved without changing the line separator format.

Goto "Utilities -> Buffer Options". The "Line Separator" dropdown shows the current separator type AND lets You change it...

See User's Guide

Robert

yes

by evaristo2k on Wed, 30/03/2011 - 23:28

New buffers, with Unix (\n) default character, are saved with an incorrect line separator when I copy/paste from Word or Excel.

Eva

« April 2024
Mo	Tu	We	Th	Fr	Sa	Su
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30

file	ver	dls
GdbPlugin for jEdit 4.5+	0.5	1147
Hypersearch results analysis	1.0	2231
German Language Pack for jEdit 5 (up-to-date)	5.3	4140
Goal column macros	1.0	4028
Hyper-search all .txt files in home dir	1	3283
Select line	1.0	3444
Open_Copied_Path.bsh	1.0	8497
Select_All_or_Lines.bsh	1.0	3409
A BeanShell macro script to search and open a recent file or a file in the current directory.	1.0	5629
Select contents in between parentheses (excluding parentheses)	1.0	3539

file	ver	dls
German Localization light	4.4.2.1	82347
Context Free Art (*.cfdg)	0.31	46055
JBuilder scheme	.001	18494
BBEdit scheme	1.0	18115
ColdFusion scheme	1.0	18023
R Edit Mode - extensive version	0.1	17472
Advanced HTML edit mode	1.0	16205
Matlab Edit Mode	1.0	16067
jEdit XP icons	1.0	15229
XP icons for jEdit	1.1	14292

RSS

XML

HTML