Help L2Fileedit Edit With Excel Problem On Save

[Alianza]

Hello guys, me again.

This time I'm trying to save some edited system lines back into the system, but everytime I try to save the new file I've edited, I get an error in the fileedit:

===========================================
|-======= Save & Encode {14/07/2017 - 1:03:21} =======-
|   Сохранение файла: skillgrp.txt
|  Создание файла: decskillgrp.dat
|-  Не удалось создать файл: dec-skillgrp.dat
===========================================

What I did was that I've copied the whole fileedit text into excel for editing an specific column. After editing that column, I've copied all the columns again with the new info, pasted it into the Fileedit but when I click "save", that error appears.

Someone knows how to fix that or how should I copy/paste info?

Thanks!

[Sinister Smile]

Did you put in the end empty line?

['Hater]

Just add the missing tabs in the end each line

 

 *not in excel but just before you save it in file edit.

[Alianza]

Did you put in the end empty line?

 

Yup.

 

Just add the missing tabs in the end each line

 

 *not in excel but just before you save it in file edit.

 

How's that?

 

EDIT: I have discovered that if I just copy paste the clean code from Fileedit to Excel and then from Excel WITHOUT any modifications back to Fileedit, the code is broken somehow and I cant save it. Maybe it has something to do with the version of Excel?

Edited July 14, 2017 by Alianza

[IpotoniC]

the excel will put dots "." after 3 digits or something

 

example: skillgrp got the column hit_time, and it has plenty of digits

-original: 1.08000004

-after excel: 108.000.001

 

So be careful with that.

 

Also there's no point to c/p all data from .dat just to change 1 row, plus if you had something else with more columns and c/p a line it will get extra tabs and it will end up in error.

 

And no, excel got no problem if u do it right.

[Alianza]

the excel will put dots "." after 3 digits or something

 

example: skillgrp got the column hit_time, and it has plenty of digits

-original: 1.08000004

-after excel: 108.000.001

 

So be careful with that.

 

Also there's no point to c/p all data from .dat just to change 1 row, plus if you had something else with more columns and c/p a line it will get extra tabs and it will end up in error.

 

And no, excel got no problem if u do it right.

 

This!. Just found out this and I was coming here to post it haha.

Excel is changing my format. Do you know how to stop it from changing it?

 

EDIT: Solved!. Just put Text as format and also put 0. in the first cell and then paste the whole document onto it. That way it will keep the format you pasted it with.

 

Thanks Sinister Smile, 'Hater and you, IpnotiC!

Edited July 14, 2017 by Alianza

[Reborn12]

Solved and locked