Litcube's Excel TShip Editor 0.64b

The place to discuss scripting and game modifications for X³: Terran Conflict and X³: Albion Prelude.

Moderators: Moderators for English X Forum, Scripting / Modding Moderators

Osiris454
Posts: 741
Joined: Tue, 4. Jan 11, 22:03
x3tc

Post by Osiris454 »

Litcube wrote:You have 7 files in the same directory as LETE (including LETE)?
Yup. All 7 that were in the zip file.
justabloke
Posts: 5
Joined: Sat, 27. Dec 08, 04:28
x3tc

Post by justabloke »

also getting the Procedure to Large error on trying to import the files that came with the download.

Excel 2007, tried it on both an XP and Vista machine.
User avatar
TrixX
Posts: 2035
Joined: Wed, 18. Aug 10, 14:28
x4

Post by TrixX »

Seems to be related to Excel 2007, as 2010 seems to have no problems with it.
"If you’re not prepared to be wrong, you’ll never come up with anything original."
Sir Ken Robinson
justabloke
Posts: 5
Joined: Sat, 27. Dec 08, 04:28
x3tc

Post by justabloke »

Osiris454 is using 2010
User avatar
Jack08
Posts: 2993
Joined: Sun, 25. Dec 05, 10:42
x3tc

Post by Jack08 »

justabloke, Osiris454
You two wouldn't happen to be using 32bit windows would you? or 32 bit exell
Last edited by Jack08 on Tue, 8. Mar 11, 07:14, edited 1 time in total.
[ external image ]
"One sure mark of a fool is to dismiss anything that falls outside his experience as being impossible."
―Farengar Secret-Fire
User avatar
Litcube
Posts: 4254
Joined: Fri, 20. Oct 06, 19:02
xr

Post by Litcube »

Jack08 wrote:justabloke, Osiris454
You two wouldn't happen to be using 32bit windows would you?
Excellent question, I was just thinking that today.

Edit: I have a 32-bit laptop I'll be testing on.
User avatar
Litcube
Posts: 4254
Joined: Fri, 20. Oct 06, 19:02
xr

Post by Litcube »

I was able to reproduce the "Procedure too large" with 32 bit office 2010.

Will be releasing a fix.
User avatar
Litcube
Posts: 4254
Joined: Fri, 20. Oct 06, 19:02
xr

Post by Litcube »

Added to OP: Explanation of the new "Edit" buttons.

Update!

0.58b:
- "Procedure too large" error has been fixed. This was a bug only found in 32-bit versions of Excel 2010. It'll work now in both versions.
- Added "Edit" buttons. See screen shot 3. Using these, swaps formulas in case you'd like to edit certain things from a different angle. For example, instead of always editing minimum speed, and adding engine tunings until you get your desired max speed, now you can just hit "edit" above the max speed column, set a max speed, and the minimum speed will be calculated off of the engine tunings, and vice versa. Speed, weapon recharge, and variant ID, are all supported in this manner.
- Added the ability to resize columns, if you add your own
- Removed cell locks, as it was preventing you from sorting or filtering using the table functions, and I know you were probably unprotecting the sheet to do so. Now you don't have to. As a result, locks are now hard coded. Filter and sort to your heart's content. The export function *can* handle your sorts, filters, etc. It just removes them before exporting.
- Fixed a few nameless bugs.
Osiris454
Posts: 741
Joined: Tue, 4. Jan 11, 22:03
x3tc

Post by Osiris454 »

Thanks Litecube!

I'll test it when I can this weekend.

Yeah, I have the 32-bit version of Office 2010 running on a Windows 7 64-bit install.
lp
Posts: 16
Joined: Tue, 24. Feb 09, 09:12
x4

OpenOffice

Post by lp »

Someone has tryed with OpenOffice? it works?
thanks
lp
lp
Stu Austin
Posts: 2287
Joined: Tue, 23. Dec 03, 22:32
x4

Re: OpenOffice

Post by Stu Austin »

lp wrote:Someone has tryed with OpenOffice? it works?
thanks
lp
I tried yesterday with Open Office and all I can get to come up is the stuff in the "Names" tag.
stu
Transcend Mod Team - AP, TC, Reunion
qwizzie
Posts: 562
Joined: Thu, 1. Jun 06, 12:17
x4

Post by qwizzie »

i cant seem to get my export tship file which is getting saved as a normal textfile to open in X3 Editor 2 with its T file editor. Is yr exportfile incompatable with the T file editor part of X3 Editor 2 ?
Trying to open with T file editor gives me error ''Line 3 col 5 : rotation .x - exspected floatvalue , got 0,005814''
User avatar
Litcube
Posts: 4254
Joined: Fri, 20. Oct 06, 19:02
xr

Post by Litcube »

Hm... Do you have European decimals? In other worlds, instead of 0.45 do you use 0,45?
qwizzie
Posts: 562
Joined: Thu, 1. Jun 06, 12:17
x4

Post by qwizzie »

i'm afraid so .. i'm from Europe. I think i installed my windows 7 64bit with European settings.

It also causes my save games to not load / corruption warning and with new game i get weird starting ship (TL)..

edit : just verified .. my windows 7 is indeed using '','' any chance you can make an european version of this excellent xcel tool too?
Last edited by qwizzie on Wed, 9. Mar 11, 22:42, edited 1 time in total.
User avatar
Litcube
Posts: 4254
Joined: Fri, 20. Oct 06, 19:02
xr

Post by Litcube »

Let me see if I can write a filter for the backward way you Europeans do things.
qwizzie
Posts: 562
Joined: Thu, 1. Jun 06, 12:17
x4

Post by qwizzie »

:)

Thanks.. appreciate it.
User avatar
TrixX
Posts: 2035
Joined: Wed, 18. Aug 10, 14:28
x4

Re: OpenOffice

Post by TrixX »

Stu Austin wrote:
lp wrote:Someone has tryed with OpenOffice? it works?
thanks
lp
I tried yesterday with Open Office and all I can get to come up is the stuff in the "Names" tag.
stu
It won't work with Open Office as it's using macro's made in VB which are MS Office specific.
"If you’re not prepared to be wrong, you’ll never come up with anything original."
Sir Ken Robinson
User avatar
Litcube
Posts: 4254
Joined: Fri, 20. Oct 06, 19:02
xr

Post by Litcube »

Update!

0.59b:
- Fixed regional settings incompatibility for backward regions (decimal, comma thing).
- Added WareLists ID view function. Again, double click it. It'll popup the ware lists.
- Due to the above, all ware files have now been included.
fallenwizard
Posts: 634
Joined: Tue, 13. Apr 10, 20:03
x4

Post by fallenwizard »

Bug report:

I opened 2 excel instances, made a copy of the tship editor folder and replaced the TShips file of the folder copy.

Now to my problem: I can't copy/paste multiple choice entries. For example the cargo type. Every time I try to copy the entry from one file to another I get a message about "object defined error". After I pressed "debug", excel points me to this piece of code:
Set after = Sheets(Name(ValidateName).RefersToRange.Parent.Name).Cell(Names(ValidateName).RefersToRange.Row, Name(ValidateName).RefersToRange.Column)
in the function: CheckValidation
User avatar
Litcube
Posts: 4254
Joined: Fri, 20. Oct 06, 19:02
xr

Post by Litcube »

I tried to reproduce what you're talking about and cannot.

I don't have enough information.

I'm copying and pasting fine from two sheets.

Return to “X³: Terran Conflict / Albion Prelude - Scripts and Modding”