Which spreadsheet editor?

This would be the forum for questions about how to work with mod making tools which can be a problem of its own.

Moderator: Paul Siramy

Post Reply
Kiahdaj
Junior Member
Champion of the Light
Posts: 357
Joined: Sun Mar 07, 2010 9:58 pm

Which spreadsheet editor?

Post by Kiahdaj » Sun Oct 16, 2011 3:41 pm

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.

User avatar
Drac0
Retired staff
Angel
Posts: 589
Joined: Tue Sep 24, 2002 2:24 am
Location: Nowra NSW, Australia
Contact:
Australia

Re: Which spreadsheet editor?

Post by Drac0 » Sun Oct 16, 2011 4:11 pm

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

User avatar
Grayloch
Junior Member
Paladin
Posts: 114
Joined: Tue Nov 22, 2005 6:03 am
Location: The Edge of Forever

Re: Which spreadsheet editor?

Post by Grayloch » Sun Oct 16, 2011 4:12 pm

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.
Even the mountains
Last not forever:
Someday they, too, shall
Crumble to dust.

User avatar
PureRage
Forum Regular
Angel
Posts: 570
Joined: Fri Jan 08, 2010 9:02 am
Location: Newcastle, England
Great Britain

Re: Which spreadsheet editor?

Post by PureRage » Sun Oct 16, 2011 4:44 pm

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?
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

Kiahdaj
Junior Member
Champion of the Light
Posts: 357
Joined: Sun Mar 07, 2010 9:58 pm

Re: Which spreadsheet editor?

Post by Kiahdaj » Sun Oct 16, 2011 7:17 pm

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.

User avatar
Necrolis
Senior Admin
Throne
Posts: 9125
Joined: Sat Mar 25, 2006 1:22 pm
Location: The Land of the Dead
Contact:
South Africa

Hand-picked

Re: Which spreadsheet editor?

Post by Necrolis » Sun Oct 16, 2011 7:18 pm

Its not tabbed and it makes it hellva easy to overwrite the wrong files
Image
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

Kiahdaj
Junior Member
Champion of the Light
Posts: 357
Joined: Sun Mar 07, 2010 9:58 pm

Re: Which spreadsheet editor?

Post by Kiahdaj » Sun Oct 16, 2011 9:34 pm

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

User avatar
PureRage
Forum Regular
Angel
Posts: 570
Joined: Fri Jan 08, 2010 9:02 am
Location: Newcastle, England
Great Britain

Re: Which spreadsheet editor?

Post by PureRage » Sun Oct 16, 2011 9:57 pm

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

User avatar
Drac0
Retired staff
Angel
Posts: 589
Joined: Tue Sep 24, 2002 2:24 am
Location: Nowra NSW, Australia
Contact:
Australia

Re: Which spreadsheet editor?

Post by Drac0 » Mon Oct 17, 2011 2:47 am

Kiahdaj" 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+1 locks the top row
ALT+2 locks the first column

You can set this in options as well so it does it with all files (Edit -> Options).

Kiahdaj
Junior Member
Champion of the Light
Posts: 357
Joined: Sun Mar 07, 2010 9:58 pm

Re: Which spreadsheet editor?

Post by Kiahdaj » Mon Oct 17, 2011 12:52 pm

Oh, you're awesome!
Thank you, that's exactly what I was looking for :D

User avatar
Lurix
Dark Alliance Beta Test
Champion of the Light
Posts: 496
Joined: Tue Aug 31, 2010 9:30 am
Location: Birmingham, UK
Bulgaria

Re: Which spreadsheet editor?

Post by Lurix » Mon Oct 17, 2011 4:50 pm

I personally prefer Microsof Office Excell ;)

User avatar
TrueMage
Hosted Forum Moderator
Principality
Posts: 2072
Joined: Thu Jun 24, 2004 7:58 am
Location: Elemental Conflux
Contact:
Russia

Re: Which spreadsheet editor?

Post by TrueMage » Tue Oct 18, 2011 2:30 am

Lurix" wrote:I personally prefer Microsof Office Excell ;)
Yes, this is most functional editor. :) And most comfortable, of course.

Kiahdaj
Junior Member
Champion of the Light
Posts: 357
Joined: Sun Mar 07, 2010 9:58 pm

Re: Which spreadsheet editor?

Post by Kiahdaj » Tue Oct 18, 2011 2:35 am

Just curious - as I'd like to be using the most efficient program-, what makes excel any better than AFJ?

User avatar
Necrolis
Senior Admin
Throne
Posts: 9125
Joined: Sat Mar 25, 2006 1:22 pm
Location: The Land of the Dead
Contact:
South Africa

Hand-picked

Re: Which spreadsheet editor?

Post by Necrolis » Tue Oct 18, 2011 10:08 am

Lurix" wrote:I personally prefer Microsof Office Excell ;)
thats when once you've paid for it, AFJ's is free :)
Image
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

User avatar
Jeewdew
Junior Member
Paladin
Posts: 132
Joined: Thu Sep 15, 2011 1:18 am
Contact:

Re: Which spreadsheet editor?

Post by Jeewdew » Tue Oct 18, 2011 3:54 pm

I prefer AFJ. MS Excel can corrupt the files.
And they even do the same. =)

User avatar
Drac0
Retired staff
Angel
Posts: 589
Joined: Tue Sep 24, 2002 2:24 am
Location: Nowra NSW, Australia
Contact:
Australia

Re: Which spreadsheet editor?

Post by Drac0 » Wed Oct 19, 2011 1:12 am

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.

Kiahdaj
Junior Member
Champion of the Light
Posts: 357
Joined: Sun Mar 07, 2010 9:58 pm

Re: Which spreadsheet editor?

Post by Kiahdaj » Wed Oct 19, 2011 1:18 am

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.

User avatar
Lurix
Dark Alliance Beta Test
Champion of the Light
Posts: 496
Joined: Tue Aug 31, 2010 9:30 am
Location: Birmingham, UK
Bulgaria

Re: Which spreadsheet editor?

Post by Lurix » Thu Oct 20, 2011 6:42 am

MS Excell can't corupt anything, if you know how to use it the best.

User avatar
TrueMage
Hosted Forum Moderator
Principality
Posts: 2072
Joined: Thu Jun 24, 2004 7:58 am
Location: Elemental Conflux
Contact:
Russia

Re: Which spreadsheet editor?

Post by TrueMage » Sat Oct 22, 2011 2:59 pm

Yes, MS Excel can corrupt files only if you don't know what you do actually.

User avatar
Drac0
Retired staff
Angel
Posts: 589
Joined: Tue Sep 24, 2002 2:24 am
Location: Nowra NSW, Australia
Contact:
Australia

Re: Which spreadsheet editor?

Post by Drac0 » Sun Oct 23, 2011 5:19 am

TrueMage" wrote:Yes, MS Excel can corrupt files only if you don't know what you do actually.
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. :D

Cheers

User avatar
Paul Siramy
Retired staff
Principality
Posts: 2828
Joined: Sat May 25, 2002 2:39 pm
Location: La Garenne Colombes (near Paris)
Contact:
France

Hand-picked

Re: Which spreadsheet editor?

Post by Paul Siramy » Sun Oct 23, 2011 6:21 pm

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.

User avatar
TrueMage
Hosted Forum Moderator
Principality
Posts: 2072
Joined: Thu Jun 24, 2004 7:58 am
Location: Elemental Conflux
Contact:
Russia

Re: Which spreadsheet editor?

Post by TrueMage » Sun Oct 23, 2011 6:38 pm

Paul Siramy" wrote:I surely forgot something, but I don't remember what.
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.

User avatar
Drac0
Retired staff
Angel
Posts: 589
Joined: Tue Sep 24, 2002 2:24 am
Location: Nowra NSW, Australia
Contact:
Australia

Re: Which spreadsheet editor?

Post by Drac0 » Mon Oct 24, 2011 2:53 am

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

Post Reply

Return to “Tools”