search

Daaaav / TranslationEditor

Excel-based editor for VVVVVV language files
1 stars 1 forks source link

Version compatible with Linux (LibreOffice) or Google Docs? #1

Open egormanga opened 2 years ago

egormanga commented 2 years ago

LibreOffice on Linux, when "Set path" clicked:

BASIC runtime error.
'323'
Module cannot be loaded; invalid format.

At line:

Set objShell = CreateObject("Shell.Application")

Google Spreadsheets simply ignore VB macros.

Daaaav commented 1 year ago

I answered this in the pull request for the localization branch back when it was asked there, but for reference and for completeness, lemme post the link to that here: https://github.com/TerryCavanagh/VVVVVV/pull/272#issuecomment-1063523724

As for completely supporting the macros in LibreOffice, Terry asked me about it as well today, but the macros depend on the (as it turns out, not that great!) MSXML library, which LibreOffice can't really emulate. Maybe it's possible to make just the export function not rely on it (since outputting XML is way easier than parsing it, and since translators will get sheets with the data already loaded) but the question is whether it'd be worth the hassle to completely replace all the exporting VBA. Either way, LibreOffice should not break the macros, so all the work could be done in LibreOffice and then exported at the end using Excel.