Litcube's Excel TShip Editor 0.64b

fallenwizard · Post by **fallenwizard** » Sat, 12. Mar 11, 19:48

TrixX wrote:
fallenwizard wrote:@Litcube

0.60b doesn't import SRM. Error message:

Runtime Error '6':
Overflow
"Debug" leads me to this line:

NextPos = InStr(Pos, WholeLine, Sep)
It loaded fine with the older version.
Was that a stock SRM TShips? Also what version?

I just loaded up 0.88b 0.84 and the current SRM without incident. Did you make any alterations?

Nope. It loaded fine with the older version of the Excel file.

Litcube · Post by **Litcube** » Sat, 12. Mar 11, 23:38

Update!

0.62b:
- Added version info to the exported header.
- Fixed a small bug in name writes that caused multiple variant entries in the XML file to not write properly. An example of the bug is two Super Freighter variants, and the Super Freighter XL not showing up. This has been fixed.

TrixX · Post by **TrixX** » Sun, 13. Mar 11, 05:45

fallenwizard wrote:
TrixX wrote:
fallenwizard wrote:@Litcube

0.60b doesn't import SRM. Error message:

Runtime Error '6':
Overflow
"Debug" leads me to this line:

NextPos = InStr(Pos, WholeLine, Sep)
It loaded fine with the older version.
Was that a stock SRM TShips? Also what version?

I just loaded up 0.88b 0.84 and the current SRM without incident. Did you make any alterations?
Nope. It loaded fine with the older version of the Excel file.

Nice you managed to not answer any questions. Can't help ya without info.

fallenwizard · Post by **fallenwizard** » Sun, 13. Mar 11, 06:02

No, I did not make any alterations. I tried both, the "standard" SRM Tships and hull-med pack. No SRM Tships file worked.

Seems that it is a problem with my Excel installation or the decimal conversion code in the macro. I use the german version and use , as the decimal separator.

I also tried several other TShip files without a problem, including Vanilla, Imp's Cockpit Mod, PSCO1 Cockpit Mod, Lucike's Mod Collection, X-Tra Ship Pack and Naval Shuffle. Everything loaded fine.

TrixX · Post by **TrixX** » Sun, 13. Mar 11, 06:34

Odd if it's the decimal converter. But yes we use English versions so decimal is point and not comma. Might also be a slight mistype in the SRM TShips as well.

Either way it's an odd issue.

Litcube · Post by **Litcube** » Sun, 13. Mar 11, 06:40

That's weird that its not working for you, when those other tships are. Can yopu send me all the files in your directory where LETE is? Ill take a look at it tommorow morning. Right now I'm getting hammered.

fallenwizard · Post by **fallenwizard** » Sun, 13. Mar 11, 07:36

After a complete reinstall of Excel SRM loads fine. I don't know why this happened.

Sorry to annoy you like this.

Litcube · Post by **Litcube** » Sun, 13. Mar 11, 22:17

Well, thanks for being honest.

Litcube · Post by **Litcube** » Fri, 18. Mar 11, 07:53

Update!

0.64b:
- Filters are now cleared when hitting the edit buttons before the edit changes take place. The filters were causing only some of the cells to be updated. I'll remedy this in the future with a solution that applies to all appropriate cells without undoing your filters. For now, just take note, and reapply your filters after changing the edit toggles.
- Cockpit weapon usage pips weren't updating when changing the cockpit weapon on ships. This has now been fixed/implemented.
- Minor bug fixes

daemon1129 · Post by **daemon1129** » Tue, 28. Jun 11, 09:49

"This workbook has lost its VBA project, ActiveX controls and any other programmability-related features."

I can't do anything with this. Wipe or import or anything doesn't work at all.

Edit: Ok i enabled VBA (I think), now it says

"Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))"

creidiki · Post by **creidiki** » Wed, 6. Jul 11, 22:03

I think I'm doing something wrong.

I'm actually editing just fine (this is awesome!) I just don't understand which .xml file I'm supposed to import to get the right names - I'm no modder myself, so I don't know which is the right one

I'm trying to edit the SRM TShips here, but I need names, heh

edit: Also, how I do set the race to 0? Gives me an "Unknown Value"

Post by **X2-Illuminatus** » Fri, 15. Jul 11, 18:24

creidiki wrote:I just don't understand which .xml file I'm supposed to import to get the right names -

The t-file of the current mod you want to change its tships.

creidiki wrote:edit: Also, how I do set the race to 0?

Well, 0 is no race. If you click on the ship's race in the 'race'-column, you can select the available races via a dropdown-list.

creidiki · Post by **creidiki** » Fri, 15. Jul 11, 19:36

Yes .... but Race 0 is a valid race, separate from the Unknown Race, useful for disabling ships added by mods that you do not like for some reason. Give an added ship Race 0 and it will be ignore by everything, without giving you the same issues adding or removing stuff from a TFile does ...

LETE will not accept it as an input however, although the race filter (obviously, as its auto-generated) does.

Post by **Ketraar** » Fri, 22. Jul 11, 19:05

Here my congrats too for a very useful Tool. Using it now for mass extraction of information from TShips using Class filter which comes very handy as I need the info per class, rather than scattered like it is in the TShips. Making it possible to c&p whole columns, thus saving me lots of time, thanks.

Just a small note, when I filtered the class per M3 I noticed that the Goner Ranger does not get listed (noticed its a separate filter), this is not really an issue once you know but the Ranger should be listed in the M3 class type of ships.

Great work

MFG

Ketraar

hlking · Post by **hlking** » Fri, 31. Oct 14, 08:08

Hi, I was trying to import the T files from Litcubes Universe but I get an error message saying "Run-time error '13': Type mismatch". I put all the required Tfiles from Cat 07 in the same folder as the excel file. I'm running Excel 2013 with macros enabled.

This is the code that the debugger highlights:

Code: Select all

Current = Sheets("Edit").Cells(1, Names("Edit.Missiles_Start").RefersToRange.Column + GSIndex).Value

Any idea how to fix it?

egosoft.com

egosoft.com

Litcube's Excel TShip Editor 0.64b