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

« November 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	1154
Hypersearch results analysis	1.0	2239
German Language Pack for jEdit 5 (up-to-date)	5.3	4148
Goal column macros	1.0	4035
Hyper-search all .txt files in home dir	1	3291
Select line	1.0	3451
Open_Copied_Path.bsh	1.0	8505
Select_All_or_Lines.bsh	1.0	3416
A BeanShell macro script to search and open a recent file or a file in the current directory.	1.0	5639
Select contents in between parentheses (excluding parentheses)	1.0	3546

file	ver	dls
German Localization light	4.4.2.1	101634
Context Free Art (*.cfdg)	0.31	46062
BBEdit scheme	1.0	18601
JBuilder scheme	.001	18502
ColdFusion scheme	1.0	18031
R Edit Mode - extensive version	0.1	17481
Advanced HTML edit mode	1.0	16213
Matlab Edit Mode	1.0	16075
jEdit XP icons	1.0	15236
XP icons for jEdit	1.1	14300

RSS

XML

HTML