Which spreadsheet editor?
Moderator: Paul Siramy
Which spreadsheet editor?
I was wondering which spreadsheet editor would be better to use...
D2Excel has a lot of issues, I know. I've experienced them.
And I've heard that AFJ's is just so much better.
But I tried it out once, and it didn't have the names of each column! (Like name, ID, etc.)
Is there any way to change that?
Because I would love to get away from D2Excel, but I couldn't stand it if it didn't have the column names...
Thanks a lot.
D2Excel has a lot of issues, I know. I've experienced them.
And I've heard that AFJ's is just so much better.
But I tried it out once, and it didn't have the names of each column! (Like name, ID, etc.)
Is there any way to change that?
Because I would love to get away from D2Excel, but I couldn't stand it if it didn't have the column names...
Thanks a lot.
Re: Which spreadsheet editor?
AFJ's has the column names????
I use it for all my txt file editing and I do a lot! This is the version I use with no problems.
Cheers
I use it for all my txt file editing and I do a lot! This is the version I use with no problems.
Cheers
-Drac0-
My Guides & Extra's
File Guides
Shrines.txt File Guide [v1.1x]
Sounds.txt File Guide [v1.1x]
LvlWarp.txt File Guide [v1.1x]
LvlTypes.txt File Guide [v1.1x]
Mapping
[DOWNLOAD] Act 2/4/5 town map plugins with automaps.
A Simple Mans Guide to Adding a New Preset Level
General
A Simple Mans Guide to Calculating Item Drop Quality
My Guides & Extra's
File Guides
Shrines.txt File Guide [v1.1x]
Sounds.txt File Guide [v1.1x]
LvlWarp.txt File Guide [v1.1x]
LvlTypes.txt File Guide [v1.1x]
Mapping
[DOWNLOAD] Act 2/4/5 town map plugins with automaps.
A Simple Mans Guide to Adding a New Preset Level
General
A Simple Mans Guide to Calculating Item Drop Quality
Re: Which spreadsheet editor?
I use AFJ's and it displays the names of the columns just fine.
It does have an option to lock or unlock the first row. If the first row is unlocked, then the column names will (of course) disappear as you scroll down--perhaps this was what you were experiencing?
-G.
It does have an option to lock or unlock the first row. If the first row is unlocked, then the column names will (of course) disappear as you scroll down--perhaps this was what you were experiencing?
-G.
Even the mountains
Last not forever:
Someday they, too, shall
Crumble to dust.
Last not forever:
Someday they, too, shall
Crumble to dust.
Re: Which spreadsheet editor?
What are the problems with D2Excel?
I've never been big on computer stuff so D2Excel is the first spreadsheet editor I've used.
What am I missing?
I've never been big on computer stuff so D2Excel is the first spreadsheet editor I've used.
What am I missing?
In the beginning the Universe was created. This has made a lot of people very angry and has been widely regarded as "A bad move".
Douglas Adams
Douglas Adams
Re: Which spreadsheet editor?
Hmm...
I remember it not showing the names.
Guess I'll try it again
Thanks
@PureRage
I think I've HEARD about more problems than I've experienced, but I have had D2Excel overwrite far too many files, just because of some ... weird way it saves things.
Also, from my experience, if you've done a lot of work in a file, and you go to save it, but accidentally press the "load .txt" button, it will undo all that you've done in the file, since the last time you saved.
That has screwed me over several times, as well.
I remember it not showing the names.
Guess I'll try it again
Thanks
@PureRage
I think I've HEARD about more problems than I've experienced, but I have had D2Excel overwrite far too many files, just because of some ... weird way it saves things.
Also, from my experience, if you've done a lot of work in a file, and you go to save it, but accidentally press the "load .txt" button, it will undo all that you've done in the file, since the last time you saved.
That has screwed me over several times, as well.
- Necrolis
- Throne
- Posts: 9125
- Joined: Sat Mar 25, 2006 1:22 pm
- Location: The Land of the Dead
- Contact:
Re: Which spreadsheet editor?
Its not tabbed and it makes it hellva easy to overwrite the wrong files
Netiquette, Do you USE it?!?! | Nefarius' Fixed TXT Files | Terms Of Service
Blackened | Day of Death | D2GFEx
"What was yours is mine. Your land, your people, and now your life." - Lim-Dul, the Necromancer
Judgement is Final, Death is Eternal
Re: Which spreadsheet editor?
What do you mean by it's not tabbed?
Edit: Okay, so I've tried AFJ again, and I remember now that it is that the column names don't remain at the top, even when you scroll down...
Is there any way to change that?
To lock that line into place at the top?
Thanks
Edit: Okay, so I've tried AFJ again, and I remember now that it is that the column names don't remain at the top, even when you scroll down...
Is there any way to change that?
To lock that line into place at the top?
Thanks
Re: Which spreadsheet editor?
Necrolis" wrote:Its not tabbed and it makes it hellva easy to overwrite the wrong files
Aah yes, now you mention it I've overwritten files a few times when i had multiple files open at the same time. Seriously frustrating when you havent backed up for few days!
In the beginning the Universe was created. This has made a lot of people very angry and has been widely regarded as "A bad move".
Douglas Adams
Douglas Adams
Re: Which spreadsheet editor?
ALT+1 locks the top rowKiahdaj" wrote:What do you mean by it's not tabbed?
Edit: Okay, so I've tried AFJ again, and I remember now that it is that the column names don't remain at the top, even when you scroll down...
Is there any way to change that?
To lock that line into place at the top?
Thanks
ALT+2 locks the first column
You can set this in options as well so it does it with all files (Edit -> Options).
-Drac0-
My Guides & Extra's
File Guides
Shrines.txt File Guide [v1.1x]
Sounds.txt File Guide [v1.1x]
LvlWarp.txt File Guide [v1.1x]
LvlTypes.txt File Guide [v1.1x]
Mapping
[DOWNLOAD] Act 2/4/5 town map plugins with automaps.
A Simple Mans Guide to Adding a New Preset Level
General
A Simple Mans Guide to Calculating Item Drop Quality
My Guides & Extra's
File Guides
Shrines.txt File Guide [v1.1x]
Sounds.txt File Guide [v1.1x]
LvlWarp.txt File Guide [v1.1x]
LvlTypes.txt File Guide [v1.1x]
Mapping
[DOWNLOAD] Act 2/4/5 town map plugins with automaps.
A Simple Mans Guide to Adding a New Preset Level
General
A Simple Mans Guide to Calculating Item Drop Quality
Re: Which spreadsheet editor?
Oh, you're awesome!
Thank you, that's exactly what I was looking for
Thank you, that's exactly what I was looking for
Re: Which spreadsheet editor?
I personally prefer Microsof Office Excell
- TrueMage
- Principality
- Posts: 2072
- Joined: Thu Jun 24, 2004 7:58 am
- Location: Elemental Conflux
- Contact:
Re: Which spreadsheet editor?
Yes, this is most functional editor. And most comfortable, of course.Lurix" wrote:I personally prefer Microsof Office Excell
Re: Which spreadsheet editor?
Just curious - as I'd like to be using the most efficient program-, what makes excel any better than AFJ?
- Necrolis
- Throne
- Posts: 9125
- Joined: Sat Mar 25, 2006 1:22 pm
- Location: The Land of the Dead
- Contact:
Re: Which spreadsheet editor?
thats when once you've paid for it, AFJ's is freeLurix" wrote:I personally prefer Microsof Office Excell
Netiquette, Do you USE it?!?! | Nefarius' Fixed TXT Files | Terms Of Service
Blackened | Day of Death | D2GFEx
"What was yours is mine. Your land, your people, and now your life." - Lim-Dul, the Necromancer
Judgement is Final, Death is Eternal
Re: Which spreadsheet editor?
I prefer AFJ. MS Excel can corrupt the files.
And they even do the same. =)
And they even do the same. =)
Re: Which spreadsheet editor?
I don't use M$ excel either, due to how easy it is to corrupt files. It loves trying to convert cell contents to what they shouldn't be, especially formula & calculations. I use it for some stuff but that is usually a copy & paste from/to afj anyway.
-Drac0-
My Guides & Extra's
File Guides
Shrines.txt File Guide [v1.1x]
Sounds.txt File Guide [v1.1x]
LvlWarp.txt File Guide [v1.1x]
LvlTypes.txt File Guide [v1.1x]
Mapping
[DOWNLOAD] Act 2/4/5 town map plugins with automaps.
A Simple Mans Guide to Adding a New Preset Level
General
A Simple Mans Guide to Calculating Item Drop Quality
My Guides & Extra's
File Guides
Shrines.txt File Guide [v1.1x]
Sounds.txt File Guide [v1.1x]
LvlWarp.txt File Guide [v1.1x]
LvlTypes.txt File Guide [v1.1x]
Mapping
[DOWNLOAD] Act 2/4/5 town map plugins with automaps.
A Simple Mans Guide to Adding a New Preset Level
General
A Simple Mans Guide to Calculating Item Drop Quality
Re: Which spreadsheet editor?
OH YEAAHHH!
I do remember it messing formulas up...
And large numbers...
In Experience.txt, it converted all of the larger entries to formulas, which made it difficult to tweak.
Or read for that matter.
I do remember it messing formulas up...
And large numbers...
In Experience.txt, it converted all of the larger entries to formulas, which made it difficult to tweak.
Or read for that matter.
Re: Which spreadsheet editor?
MS Excell can't corupt anything, if you know how to use it the best.
- TrueMage
- Principality
- Posts: 2072
- Joined: Thu Jun 24, 2004 7:58 am
- Location: Elemental Conflux
- Contact:
Re: Which spreadsheet editor?
Yes, MS Excel can corrupt files only if you don't know what you do actually.
Re: Which spreadsheet editor?
Ok, would be nice to have an explanation of what to do so M$ Excel doesn't corrupt the files at all. More than happy to learn.TrueMage" wrote:Yes, MS Excel can corrupt files only if you don't know what you do actually.
Cheers
-Drac0-
My Guides & Extra's
File Guides
Shrines.txt File Guide [v1.1x]
Sounds.txt File Guide [v1.1x]
LvlWarp.txt File Guide [v1.1x]
LvlTypes.txt File Guide [v1.1x]
Mapping
[DOWNLOAD] Act 2/4/5 town map plugins with automaps.
A Simple Mans Guide to Adding a New Preset Level
General
A Simple Mans Guide to Calculating Item Drop Quality
My Guides & Extra's
File Guides
Shrines.txt File Guide [v1.1x]
Sounds.txt File Guide [v1.1x]
LvlWarp.txt File Guide [v1.1x]
LvlTypes.txt File Guide [v1.1x]
Mapping
[DOWNLOAD] Act 2/4/5 town map plugins with automaps.
A Simple Mans Guide to Adding a New Preset Level
General
A Simple Mans Guide to Calculating Item Drop Quality
- Paul Siramy
- Principality
- Posts: 2828
- Joined: Sat May 25, 2002 2:39 pm
- Location: La Garenne Colombes (near Paris)
- Contact:
Re: Which spreadsheet editor?
I'd say to *import* the .txt. Especially do NOT just simply drag'n drop the txt into excel. Then for each colum you can change its type. Choose "Text" format for the columns with formulas, that'll force Ms Excel to don't change anything in that column.
Also, in one of the first importing dialogs, there's a field where you can choose if the quote ( " ) character is used to delimits a string. I recomand to choose nothing, that way if there's a cell with a " in it, Excel won't change anything again.
I surely forgot something, but I don't remember what.
Also, in one of the first importing dialogs, there's a field where you can choose if the quote ( " ) character is used to delimits a string. I recomand to choose nothing, that way if there's a cell with a " in it, Excel won't change anything again.
I surely forgot something, but I don't remember what.
DT1 Tools - DS1 Editor - MPQ list file - Extracting D2 Animation - Adding ANY Monsters and ANY Objects to a DS1 - New monster color variations from scratch
In development since 16 Feb 2012 : MergeDCC v2
In development since 16 Feb 2012 : MergeDCC v2
- TrueMage
- Principality
- Posts: 2072
- Joined: Thu Jun 24, 2004 7:58 am
- Location: Elemental Conflux
- Contact:
Re: Which spreadsheet editor?
I think it is complete enough. I'd add there is alternative to importing way. The only problem with ms excel I encountered is replacing formulae which begin with "-" (for example "-edmn" or "-par5"). So to eliminate the necessity in "importing" we can just use brackets around expression ("(-edmn)" and "(-par5)" respectively) in skills.txt and skilldesc.txt when we open these files first time. This is only 5-minutes task I made ten years ago and now I can open files without importing, just as usual we open files with any program.Paul Siramy" wrote:I surely forgot something, but I don't remember what.
Re: Which spreadsheet editor?
Thanks, will give it a go. AFJ's is good, but does lack a lot of the functionality of a full-blown spreadsheet program. Will also look at OpenOffice & see if I can get results with that too, as a free alternative.
Cheers
Cheers
-Drac0-
My Guides & Extra's
File Guides
Shrines.txt File Guide [v1.1x]
Sounds.txt File Guide [v1.1x]
LvlWarp.txt File Guide [v1.1x]
LvlTypes.txt File Guide [v1.1x]
Mapping
[DOWNLOAD] Act 2/4/5 town map plugins with automaps.
A Simple Mans Guide to Adding a New Preset Level
General
A Simple Mans Guide to Calculating Item Drop Quality
My Guides & Extra's
File Guides
Shrines.txt File Guide [v1.1x]
Sounds.txt File Guide [v1.1x]
LvlWarp.txt File Guide [v1.1x]
LvlTypes.txt File Guide [v1.1x]
Mapping
[DOWNLOAD] Act 2/4/5 town map plugins with automaps.
A Simple Mans Guide to Adding a New Preset Level
General
A Simple Mans Guide to Calculating Item Drop Quality