zaterdag 28 december 2024

Xrandr screen dimensions

 xrandr
lspci -k | grep -iEA5 'vga|display|3d'

 

Working with notion

 Create links of the list of hotels, linking to the webpages of these hotels on the site booking.com. First mention the names of the hotels and next to it the links, also presented in the form of a list in the form of a text file.

 

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.

Enlarging Libreoffice window completely with command

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