Nope. It loaded fine with the older version of the Excel file.TrixX wrote:Was that a stock SRM TShips? Also what version?fallenwizard wrote:@Litcube
0.60b doesn't import SRM. Error message:
"Debug" leads me to this line:Runtime Error '6':
Overflow
It loaded fine with the older version.NextPos = InStr(Pos, WholeLine, Sep)
I just loaded up 0.88b 0.84 and the current SRM without incident. Did you make any alterations?
Litcube's Excel TShip Editor 0.64b
Moderators: Moderators for English X Forum, Scripting / Modding Moderators
-
- Posts: 628
- Joined: Tue, 13. Apr 10, 20:03
Nice you managed to not answer any questions. Can't help ya without info.fallenwizard wrote:Nope. It loaded fine with the older version of the Excel file.TrixX wrote:Was that a stock SRM TShips? Also what version?fallenwizard wrote:@Litcube
0.60b doesn't import SRM. Error message:
"Debug" leads me to this line:Runtime Error '6':
Overflow
It loaded fine with the older version.NextPos = InStr(Pos, WholeLine, Sep)
I just loaded up 0.88b 0.84 and the current SRM without incident. Did you make any alterations?
"If you’re not prepared to be wrong, you’ll never come up with anything original."
Sir Ken Robinson
Sir Ken Robinson
-
- Posts: 628
- Joined: Tue, 13. Apr 10, 20:03
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.
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.
Last edited by fallenwizard on Sun, 13. Mar 11, 06:28, edited 1 time in total.
-
- Posts: 628
- Joined: Tue, 13. Apr 10, 20:03
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
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
-
- Posts: 35
- Joined: Mon, 27. Nov 06, 00:04
"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))"
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))"
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"
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"
I am not as think as you drunk I am.
- X2-Illuminatus
- Moderator (Deutsch)
- Posts: 24961
- Joined: Sun, 2. Apr 06, 16:38
The t-file of the current mod you want to change its tships.creidiki wrote:I just don't understand which .xml file I'm supposed to import to get the right names -
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 wrote:edit: Also, how I do set the race to 0?
Nun verfügbar! X3: Farnham's Legacy - Ein neues Kapitel für einen alten Favoriten
Die komplette X-Roman-Reihe jetzt als Kindle E-Books! (Farnhams Legende, Nopileos, X3: Yoshiko, X3: Hüter der Tore, X3: Wächter der Erde)
Neuauflage der fünf X-Romane als Taschenbuch
The official X-novels Farnham's Legend, Nopileos, X3: Yoshiko as Kindle e-books!
Die komplette X-Roman-Reihe jetzt als Kindle E-Books! (Farnhams Legende, Nopileos, X3: Yoshiko, X3: Hüter der Tore, X3: Wächter der Erde)
Neuauflage der fünf X-Romane als Taschenbuch
The official X-novels Farnham's Legend, Nopileos, X3: Yoshiko as Kindle e-books!
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.
LETE will not accept it as an input however, although the race filter (obviously, as its auto-generated) does.
I am not as think as you drunk I am.
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
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
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:
Any idea how to fix it?
This is the code that the debugger highlights:
Code: Select all
Current = Sheets("Edit").Cells(1, Names("Edit.Missiles_Start").RefersToRange.Column + GSIndex).Value
- jack775544
- Posts: 1277
- Joined: Tue, 13. Dec 11, 08:27
For LU use the editors found here: https://code.google.com/p/litcubesunive ... structions
The types files in LU have had some changes to their structure making non-LU editors incompatible.
The types files in LU have had some changes to their structure making non-LU editors incompatible.
1940s - Various "computers" are "programmed" using direct wiring and switches. Engineers do this in order to avoid the tabs vs spaces debate.
Sweet! Thank you, mate.jack775544 wrote:For LU use the editors found here: https://code.google.com/p/litcubesunive ... structions
The types files in LU have had some changes to their structure making non-LU editors incompatible.