Search results
Feb 23, 2024 · Mokarano February 23, 2024, 7:45pm #1. The sum function is not working in any spreadsheet. Typing the sum function as “=SUM (B1:B12)”, for example does not return a number after the Enter key is pressed. The formula is shown instead. Thank you for your help!
Aug 12, 2012 · Doctor_Pi March 1, 2016, 9:56pm #15. You might want to check this answer: [Calc] - Alternative to "Format As Table" feature in Excel 2007/2010/2013 English. At the moment you need to do this step by step: create named ranges, add autofilter and use autoformat for style.
May 10, 2018 · Afterwards this spreadsheet should then be exported into an iCalendar (*.ics)-file for importing it into Thunderbird's usual Lightning calendar add-on. Does LibreOffice Calc provide any export possibility to convert a table into the mentioned *.ics-file without much efforts? If not, maybe someone has a nice macro for this?
Apr 18, 2014 · Check “Connect to an existing database” and select “Spreadsheet” from the drop-down list. Next. Select your spreadsheet file. Next. Check “Yes, register”. Finish. Save the .odb file, for example beside the spreadsheet file. Make sure, your spreadsheet has columns labels. They will become the database field names.
Sep 20, 2012 · In LibreOffice 6.0.6.2 I had to use Ctrl+Shift+F4, not F4 as the referenced OpenOffice tutorial says as does Data Sources - LibreOffice Help. However, Menu->View Data Sources does work as the latter says. Thanks! Rod1 September 20, 2012, 11:10pm #2. I think it is from Insert → Link to external data.
Jun 29, 2021 · EarnestAl June 29, 2021, 1:19am #2. Click File > Print Preview, you can adjust margins from there by clicking the icon. If you need to get everything on a single page width, you can also adjust the scale with the slider. WildChick June 29, 2021, 1:26am #3. Seriously that smple?
Feb 15, 2016 · I would like to know if there is an option where you can keep the first row in the spreadsheet to remain on top even when scrolling downwards or upwards. Because I am creating a Price List for our company and we have a lot of brands with many SKUs, so filtering is a must. However, if I am in the bottom of the spreadsheet and I need to filter a product brand quickly, I will have to keep scrolling back up to the top in order to click on the arrow and filter. I hope you consider this feature in ...
Feb 24, 2024 · Hi there. I’m a complete beginner to using LibreOffice Calc and generally a beginner to using spreadsheet programs in general. I want to create an auto-updating spreadsheet that will log weather data. So ideally, I should have a number of cities and have the following information in different columns: [CITY NAME] - Average high temperature - Amount of rainfall - Amount of snowfall Each would be updated daily. Namely, it would input data from a web API call to a website like OpenWeather or ...
Feb 4, 2023 · Please, before creating any how-to, call the thing by its correct name: LibreOffice Calc. A bit more detail: Spreadsheets allow calculations in tables, so you may use Calc as tool for calculations of video-length, or tables of contents etc etc. But special software to produce video may even include this.
Jun 16, 2020 · I’m trying to use the following code to save a file as a calc file (extension “.ods”). It uses a sub to save it (save File sub) but it does as a Write file no matter the properties set in the dialog box. I know how to do it without a dialog, but I need it. All attempts failed, so I’m asking for help. sub SalvaComBox Dim FPType(0) as integer FPType(0) = 10 oFilePicker = CreateUnoService("com.sun.star.ui.dialogs.OfficeFilePicker") oFilePicker.appendFilter("Planilha ODF (*.ods)","*...
