repository·master·Indexed 25 days ago
https://github.com/aardappel/treesheetsAn Open Source Free Form Data Organizer using hierarchical spreadsheets for complex data organization, project management, and brainstorming. Documentation covers installation via binaries or Flatpak, building from source with CMake, data import/export (XML, HTML, CSV, PDF, SVG), grid manipulation tools like Hierarchy Swap and Flatten, and internal API constants for actions and text styles.
Translation involves filling the msgstr field with the translated text for every msgid found in the .po file.
Manual Example:
msgid "Switch to &next file/tab"
msgstr "Перейти к следующей вкладке"Recommended Tool:
Poedit is a free, open-source cross-platform editor for gettext localization catalogs. It automatically recompiles the .mo file when you save the .po file.
To preview translation changes immediately in a Flatpak installation, you can link your working translation directory or file to the Flatpak locale path.
Note: You must first rename the existing file or link to avoid conflicts.
Option 1: Link the specific ts.mo file
Target path: /var/lib/flatpak/runtime/com.strlen.TreeSheets.Locale/x86_64/stable/active/files/ru/share/ru_RU/LC_MESSAGES/ts.mo
Option 2: Link the entire ru_RU directory
Target path: /var/lib/flatpak/app/com.strlen.TreeSheets/current/active/files/share/locale/ru_RU
TreeSheets can be installed via pre-built binaries or Flatpak:
flatpak install flathub com.strlen.TreeSheets (or via your preferred Flatpak client).To work on translations for TreeSheets, you need the gettext library, which provides the necessary tools for internationalization (i18n) and localization (L10n).
gettext package to obtain xgettext, msginit, msgmerge, and msgfmt.To initialize a translation for a new language, navigate to the TS/translations directory and use msginit. Use either a 2-letter ISO 639-1 code (e.g., it) or a 5-letter combination of the ISO 639 code and ISO 3166 country code (e.g., pt_BR) for the lang placeholder.
msginit --input ts.pot --locale=lang --output=lang/ts.polang/compile.bat script, replacing lang with the appropriate language code (e.g., it or pt_BR).lang/compile.bat.pot template is updated with new strings, you must merge these changes into your existing .po translation file. Run this command from within the specific language directory (e.g., ru_RU/).The .pot (Portable Object Template) file contains all strings extracted from the source code. This file is typically managed by developers.
To create a new template (/TS/translations/ts.pot) from the src/ directory:
Run genpot.bat or use the xgettext command.
To update an existing template after source code changes from the src/ directory:
Run ./pot_update.sh or use the xgettext command with the -j flag.
To create a translation for a new language, use the msginit command inside the TS/translations directory. You must first create the target language subdirectory.
Use an ISO 639-1 two-letter code (e.g., it) or a 5-character combination of ISO 639-1 and ISO 3166-1 (e.g., ru_RU, ru_UA). The encoding is typically UTF-8.
# Example for Russian (ru_RU)
mkdir ru_RU
msginit --input ts.pot --locale=ru_RU.UTF-8 --output=ru_RU/ts.polang/merge.bat script, replacing lang with the appropriate language code (e.g., it or pt_BR).lang/merge.batThe Hierarchy Swap command (triggered by pressing F8) promotes a selected cell to its grandparent grid. This is used to reorganize hierarchical data by moving a specific tag or item higher up the tree and merging branches that share the same tag name.
F8 presses to reach the common ancestor where merging occurs.F8xgettext, msginit, and msgfmt commands installed on your system. These are standard on Linux and macOS. On Windows, you can obtain them from tools like the gettext-iconv collection.