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

User avatar
Litcube
Posts: 4254
Joined: Fri, 20. Oct 06, 19:02
xr

Post by Litcube » Sat, 5. Mar 11, 23:21

Osiris454 wrote:Lit, when I try to import a Tships file, I get a "Compile Error: Procedure Too Large".
Send me the TShips.

Edit: If that's the only changed file. If you're using other files, send those.

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

Post by Osiris454 » Sat, 5. Mar 11, 23:59

Litcube wrote:
Osiris454 wrote:Lit, when I try to import a Tships file, I get a "Compile Error: Procedure Too Large".
Send me the TShips.

Edit: If that's the only changed file. If you're using other files, send those.
It's the Tships file from SRM. Sorry, I don't have any online storage location.
That was the only file I was trying to edit.

User avatar
Litcube
Posts: 4254
Joined: Fri, 20. Oct 06, 19:02
xr

Post by Litcube » Sun, 6. Mar 11, 00:03

I just tried it with SRM. Works for me.

What version of Excel are you using?

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

Post by Osiris454 » Sun, 6. Mar 11, 00:17

Litcube wrote:I just tried it with SRM. Works for me.

What version of Excel are you using?
2010. I also have Visual Studio 2010 Ultimate installed too if that's a problem.

User avatar
Litcube
Posts: 4254
Joined: Fri, 20. Oct 06, 19:02
xr

Post by Litcube » Sun, 6. Mar 11, 00:19

You have 7 files in the same directory as LETE (including LETE)?

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

Post by Osiris454 » Sun, 6. Mar 11, 00:21

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 » Mon, 7. Mar 11, 11:09

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: 2034
Joined: Wed, 18. Aug 10, 14:28
x3tc

Post by TrixX » Mon, 7. Mar 11, 12:03

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 » Tue, 8. Mar 11, 04:43

Osiris454 is using 2010

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

Post by Jack08 » Tue, 8. Mar 11, 06:18

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 » Tue, 8. Mar 11, 06:58

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 » Tue, 8. Mar 11, 18:29

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 » Wed, 9. Mar 11, 04:01

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 » Wed, 9. Mar 11, 04:40

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 » Wed, 9. Mar 11, 14:45

Someone has tryed with OpenOffice? it works?
thanks
lp
lp

Stu Austin
Posts: 2262
Joined: Tue, 23. Dec 03, 22:32
x4

Re: OpenOffice

Post by Stu Austin » Wed, 9. Mar 11, 17:10

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 » Wed, 9. Mar 11, 22:07

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 » Wed, 9. Mar 11, 22:27

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 » Wed, 9. Mar 11, 22:36

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 » Wed, 9. Mar 11, 22:37

Let me see if I can write a filter for the backward way you Europeans do things.

Post Reply

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