New answers tagged

1

I did not test your setup, but this worked for me from a terminal: xdotool search --name Untitled key ctrl+s xdotool search --name Untitled key ctrl+q "Untitled 1" was the name of the document in my test. Ctrl+s saves, and Ctrl+q quits. See http://unix.stackexchange.com/questions/87831/how-to-send-keystrokes-f5-from-terminal-to-a-process. Alternatively,...


0

To show the encoding options dialog, go to Save As... and check Edit filter settings. In order to avoid the slowness of Save As..., you could use a macro like this: Sub SaveAsUtf8 dim aUrl() dim fileProps(1) as new com.sun.star.beans.PropertyValue fileProps(0).Name = "FilterName" fileProps(0).Name = "Text (encoded)" fileProps(1).Name = "...


0

I just found the answer to my own question. If you add a single character of text on the line just before the table itself, then select that line and the table, Open Office will correctly allow you to cut both of them without leaving the table structure behind. You can then paste the single character and the table to the desired location, and both the ...


0

Tables require a following paragraph. To make it fit on one page, change the paragraph's font to size 2. Also resize the table or bottom margin if necessary. Alternatively, Table -> Convert -> Table to Text makes it so that no extra paragraph is required. See https://ask.libreoffice.org/en/question/7412/how-i-can-delete-empty-line-after-table-in-...


1

The default currency can be set using the global language options. Go to Menu Tools -> Options -> Language Settings -> Languages, and select the appropriate currency from the default currency combobox:


1

How can I get my Elapsed Time column to come out in and Hour and Minutes format? Right click the "Elapsed Time" cell (C2) in my example Select "Format cells..." Select "Numbers" tab Set the "Category" to "Time" Set the "Format code" to "HH:MM" Press "OK"


1

If you ask Calc to save a file as CSV as defined in RFC4180, it will do so. If you want Calc to use a different format, you'll have to tell Calc explicitly to do so. The way to do this is using the CSV filter settings. To access the filter settings, tick the checkbox in the "Save" dialog (it's active only after selecting a format that requires a filter): ...


0

When you open with Calc, does it ask you stuff about the file (like encoding, column separators, text separators)? If it does make sure you uncheck all separators save for tabs. I often open CSV files with semicolons as separators, unchecking all separators but semicolons, and Calc never turned them into commas.


3

Converting a simple table (as your table 1) to a contingency table (as your table 2) is a standard task for a pivot table. Depending on your data, it may be useful to prepare the contents before creating the pivot table: it's useful to have column names, which facilitates the pivot table definition; the month names should be DATE values, otherwise LO Calc ...


3

This should be a good starting point: First, you need a formula that would repeat a number N times before changing to the next number (To use in our indexes later). This is where QUOTIENT comes to use: it returns whole part of division operation. So we divide current row index by N, 3 in my example: QUOTIENT(ROW(B1),3)) Which returns 0,0,1,1,1,2,2,2.....


3

You can solve this using two small macros (to determine the name of the last sheet) in combination with the range operator and the INDIRECT() function. First, create the following macro (Tools -> Macros -> LibreOffice Basic, create a new module or use the default module; paste the following code): Function LastSheetName() Dim nSheetCount As Integer ...



Top 50 recent answers are included