• 63 Posts
  • 1.74K Comments
Joined 1 year ago
cake
Cake day: June 22nd, 2023

help-circle




  • There’s some data that comes in CSV, other are database files, in the SQL server, excel or web apis. From some of them I need to combine multiple sources with different formags even.

    I guess I could have a database with everything more tidy, easier to use, secure and with less failure ratio. I’m still going to prepare the databases (I’m thinking on dataframe objects on a pickle, but I want to experiment with parquetd) so they don’t have to be processed every time, but I wanted something I could just write the name of the database and get the update version.





  • Can’t test now but ChatGPT said this:

    Creating a drop-down list in LibreOffice Calc involves using the Data Validity feature. Here are the steps to create a drop-down list:

    1. Open LibreOffice Calc: Open your spreadsheet in LibreOffice Calc.

    2. Select the Cells: Click on the cell or select the range of cells where you want the drop-down list to appear.

    3. Open Data Validity: Go to the menu and click on Data > Validity....

    4. Set Criteria: In the Validity dialog box, go to the Criteria tab.

      • From the Allow drop-down menu, select List.
      • In the Entries field, type the values you want to appear in the drop-down list. Separate each value with a comma. For example, type Option 1, Option 2, Option 3.
    5. Optional Settings:

      • Go to the Input Help tab to provide users with instructions or help text when they select the cell.
      • Use the Error Alert tab to define how Calc should behave if an invalid value is entered.
    6. Click OK: Once you’ve configured the settings, click OK.

    Now, the selected cells will have a drop-down arrow, and users can choose from the list of values you defined.

    If your list of values is long, you might want to reference a range of cells instead of typing each value manually. Here’s how:

    1. List Values in a Range: List your values in a separate column or sheet.

    2. Name the Range: Select the range of cells with your values. Go to Sheet > Named Ranges and Expressions > Define. Name your range (e.g., MyRange).

    3. Data Validity: Follow steps 3-4 above, but instead of typing values in the Entries field, type =$MyRange.

    4. Click OK: Once you’ve configured the settings, click OK.

    This method makes it easier to update your list of values without modifying the Data Validity settings.