anon73440385 January 6, 2020, 3:56pm #2. Hello, Format -> Page -> Tab: Page -> Category: Margins. Hope that helps. If the answer helped you to solve your problem, please click the check mark () next to the answer. purrdy January 6, 2020, 10:06pm #3. Thank you for that, easy when you know how ! Home. Categories.
Share, comment, bookmark or report
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.
Share, comment, bookmark or report
The assumption in your comment is correct. From the HELP: AVERAGE. Returns the average of the arguments. Syntax ...
Share, comment, bookmark or report
AlexKemp closed April 20, 2021, 5:02pm #10. Hello, libreoffice 5.3.0.3 - calc all of sudden, when I use the arrow keys in the spreadsheet I cannot move in the cells and the scrollbars are moving. Probably I’ve inadvertently set a wrong setting with.
Share, comment, bookmark or report
Works the same in Calc. Alternatively right click on a column header and from context menu choose Optimal Width. Strange, for whatever reason it does not perform it when simply double clicking the divider bar, but it does if I use the right-click and choose Optimal Width method. Anyway, I was able to get the desired result, so thank you!
Share, comment, bookmark or report
I see no practical way to handle this in a cell. However you can create a cell style that adds automatically the bullet and apply that style to the cells containing the text concerned. My advice would be to enter each item of the list in a different cell as in the Bullet.ods attached. The format of the Bullet" cell style:""@.
Share, comment, bookmark or report
EDIT: OS: Linux Mint 19.2 Cinnamon LibreOffice version: 6.0.7.3 File format being used: ODS === Hello, I have around 5 Calc files (or documents) with a couple of cells in each that link to another file. I want all links updated every time I open files. Just to be clear, a link is made when, in one cell, I type = and then click another cell in another file. (I’m not aware of any other ...
Share, comment, bookmark or report
Here is how I was able to remove the hyperlink: Right click on the cell, but ensure you’re -not- right-clicking the actual hyperlink. (If you right-click on the hyperlink, the “Clear Direct Formatting” doesn’t work for some reason.) Select “Clear Direct Formatting”. This will remove all formatting from the cell, including the ...
Share, comment, bookmark or report
I want to print gridlines on my final printout of a calc spreadsheet. Found it! Select “format”, “page”, “sheet”, “grid”. Hi coop02, That is correct. However, I find that usually I want borders around some of the cells and no gridlines in other areas. For this use: Format, cells, borders. Then make a choice under “line ...
Share, comment, bookmark or report
5) Press Ctrl + N (The window “database wizard” is opened) 6) Select the radio button “ Connect to an existing database ” and select “ ODBC ”. 6a) Press the button “ Next ”. A new window is opened (Name on the ODBC-Data source) 7) Press the button “Browse”. A new window is opened .:
Share, comment, bookmark or report
Comments