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

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

Re: OpenOffice

Post by Stu Austin » Wed, 9. Mar 11, 18: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: 560
Joined: Thu, 1. Jun 06, 12:17
x4

Post by qwizzie » Wed, 9. Mar 11, 23: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: 4245
Joined: Fri, 20. Oct 06, 19:02
xr

Post by Litcube » Wed, 9. Mar 11, 23:27

Hm... Do you have European decimals? In other worlds, instead of 0.45 do you use 0,45?

qwizzie
Posts: 560
Joined: Thu, 1. Jun 06, 12:17
x4

Post by qwizzie » Wed, 9. Mar 11, 23: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, 23:42, edited 1 time in total.

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

Post by Litcube » Wed, 9. Mar 11, 23:37

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

qwizzie
Posts: 560
Joined: Thu, 1. Jun 06, 12:17
x4

Post by qwizzie » Wed, 9. Mar 11, 23:43

:)

Thanks.. appreciate it.

User avatar
TrixX
Posts: 2022
Joined: Wed, 18. Aug 10, 14:28
x3tc

Re: OpenOffice

Post by TrixX » Thu, 10. Mar 11, 05:59

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: 4245
Joined: Fri, 20. Oct 06, 19:02
xr

Post by Litcube » Thu, 10. Mar 11, 06:12

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: 604
Joined: Tue, 13. Apr 10, 20:03
x4

Post by fallenwizard » Fri, 11. Mar 11, 04:22

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: 4245
Joined: Fri, 20. Oct 06, 19:02
xr

Post by Litcube » Fri, 11. Mar 11, 04:58

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.

fallenwizard
Posts: 604
Joined: Tue, 13. Apr 10, 20:03
x4

Post by fallenwizard » Fri, 11. Mar 11, 05:13

Excel 1: Opened a custom TShips file (vanilla + imp's cockpit mod)
Excel 2: Opened the SRM Tships file

Excel 2: Marked all "Max Transport Class" entries down to line 374 and copied them into the clipboard
Excel 1: Pasted them in the same column

Then this error showed up:

Runtime Error '1004':
Application or object defined error.

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

Post by Litcube » Fri, 11. Mar 11, 05:17

I just did what you described. No error.

I am opening two sheets within the same instance of excel. You'll have to rename one sheet to do so.

fallenwizard
Posts: 604
Joined: Tue, 13. Apr 10, 20:03
x4

Post by fallenwizard » Fri, 11. Mar 11, 05:21

I tried to open both files in the same excel instance, same error.

Maybe Excel just hates me. I will send you a link to both TShip files.

EDIT: PM sent.

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

Post by Litcube » Fri, 11. Mar 11, 05:27

You sent me the TShips. Where are the rest of the files?

fallenwizard
Posts: 604
Joined: Tue, 13. Apr 10, 20:03
x4

Post by fallenwizard » Fri, 11. Mar 11, 05:28

I didn't send you any of the other files because they are not modified.

Post Reply

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