zondag 17 november 2024

Google Sheets & Google Translate for translations

 1. Using Google Sheets for Text Translation

This method works well for translating text in a simple format, such as a CSV, spreadsheet, or plain text file.

Steps:

    Step 1: Open Google Sheets.
    Step 2: Paste the original foreign text into column A.
    Step 3: In column B, use the GOOGLETRANSLATE function to translate each entry.
        For example, if the foreign text is in cell A1, in cell B1, enter:

    =GOOGLETRANSLATE(A1, "language_code_of_original_text", "language_code_of_target_language")

    Example: =GOOGLETRANSLATE(A1, "es", "en") (for Spanish to English).

Step 4: Copy the formula down the column to apply it to all rows.
Step 5: Once all text is translated, you can export the sheet as a CSV or Excel file to keep both the original and translated text in your preferred format.

 

 

donderdag 19 september 2024

zondag 8 oktober 2023

Disable touchpad

To disable touchpad on laptop:

xinput list

xinput disable [number]

zondag 28 mei 2023

Excel: maand afschriften van de bank

Maand afschriften van de bank:
1. Komma's vervangen door punten
2. Het sorteren van de namen (met de bedragen erbij)
3. Een rij toevoegen zodat je AF en BIJ scheidt
4. Het gebruik maken van filter en refilter om bedragen naar naam te berekenen


vrijdag 6 januari 2023

How to import data tables from an Internet site and have them automatically updated

 https://wiki.documentfoundation.org/Faq/Calc/113

  1. Create a new LibreOffice Calc document.
  2. Click on a cell in the table (A1 for example)
  3. Go to Sheet ▸ Link to external data.
  4. After a few seconds (sometimes a bit longer) a new window appears:
  5. Check the Detect special numbers box.
  6. Click OK.

zaterdag 10 december 2022

What is a mountpoint?

A mount point is a directory on a file system that is logically linked to another file system. Mount points are used to make the data on a different physical storage drive easily available in a folder structure. Mount points are fundamental to Unix, Linux and macOS. Windows can use mount points, but it is not common.

https://www.techtarget.com/whatis/definition/mount-point

 

zaterdag 3 december 2022

Enlarging Libreoffice window completely with command

 You can open the LibreOffice window completely by pressing the CTRL+Shift+J keys together.