In Calc, how do I adjust margins - English - Ask LibreOffice
2020年1月6日 · I have created a calc project, but the margins are too wide to print on one page, how can I change the margins? anon73440385 January 6, 2020, 3:56pm #2
Calc: Way to join/merge multiple data ranges to one - Ask …
2018年6月9日 · Hi there! Assume we have defined multiple data ranges in Calc document. Data sources are LO Base queries against multiple Base databases, all ranges have identical structure - column headers, data types and so on, see image attached. Is there a pure Calc way to combine these multiple ranges into one new range? I have Macro and SQL based solutions for it, but I …
How to connect Calc to ODBC tables? - English - Ask LibreOffice
2019年4月4日 · The first wish is to be able to read the database tables with Calc, but if it works well, other wishes may arise. Think I have done right (have followed the instructions in the manual). Right now, I think the problem is that LibreOffice is 64-bit and I …
How do I get real time stock quotes in calc? - Ask LibreOffice
2012年12月16日 · It appears that this question does not currently have a solution, and yet, this would be a very useful thing to have in calc. So I have re-opened it in hopes that one or more people can someday post an answer here to solve this issue.
Calc does not open anymore - English - Ask LibreOffice
2023年1月7日 · I recently installed Ubuntu 20.045 and after a a few days LibreOffice Calc ‘crashed’ and I cannot open a spreadsheet anymore , my syslog said Java missing, so I tried to fix this using I could start Word word and checked JRE, I now have JRE installed, vendor=Ubuntu version 11.0.17. When I try open a spreadsheet my LibreOffice-session reduces to a small …
Does Calc has any feature similar to POWER QUERY in excel?
2019年7月14日 · If you want to try the latest version and see if it works for you, it is available here: GitHub - balthier82/queryconnector: QueryConnector - Attach queries on OpenOffice/LibreOffice Calc spreadsheet documents. (the version on the extension website is older)
How to structure data for bookkeeping in calc? - Ask LibreOffice
2024年1月7日 · I need to do bookkeeping for multiple accounts (several bank and cash accounts). I would like to be able to record transactions “Bought stuff -100$”, “Got paid +1000$” but also states “Checked wallet: =35.50$”. My idea was to structure it like this: but I’m not sure if this is a good idea and how to handle several accounts in this way. I could do a separate sheet for …
How do I insert line breaks in Calc with Find & Replace?
2013年9月20日 · If your text is in cell A1, then you can copy the contents to another cell and replace \ with line breaks with the substitute function, i.e. =SUBSTITUTE(A1,"\",CHAR(10)).
Is a lambda function in Calc possible? - Ask LibreOffice
2022年3月30日 · I’d like that I could have a cell with a function, and I could call the function in the cell elsewhere. Is it possible? This is how I imagine that it could be: A1: =LAMBDA(x, 2*x*x + x + 2) A2: =A1(3) → 23 A1 has a function in it, and A2 has it called with 3 as the parameter, and it evaluates to 23. Is something like that possible? I didn’t find it in the documentation; I might …
LibreOffice Calc: How do I re-name the row and column labels?
2015年6月24日 · I need to re-name the row and column labels with meaningful names. Simply assigning the first row and first column for this purpose, to hold meaningful names for the rows and columns isn’t good enough, because those no longer display when one scrolls away from row one and column one. Answer: Spreadsheets do not allow renaming the row and column …