New answers tagged

0

If you are an Excel user, you could try xNumbers. This is a freeware add in you can get at Xnumbers for Excel


0

There are several ideas at https://ask.libreoffice.org/en/question/1035/paste-unformatted-text-default-option/, but the only one that worked for me is a macro: Sub paste_unformatted Dim document As Object Dim dispatcher As Object document = ThisComponent.CurrentController.Frame dispatcher = ...


2

I can't find a way to select the entire table Place the cursor in a table cell To select the entire table do one of the following: Menu > "Table" > "Select" > "Table", or alt+a, s, t, or Right-click "Select" > "Table" ctrl+c to copy the table ctrl+v to paste the table elsewhere in your document


2

In LibreOffice, go to Tools -> Outline Numbering. For Number, select "I, II, III, ..." For the Before separator, enter "Act" plus a space. Then select level 2. For Number, select "1, 2, 3, ..." For the Before separator, enter "Scene" plus a space. Change Show sublevels to 1. Press OK to close. Now to enter an act heading, on a blank line, choose ...


1

The Preview in Windows Explorer is handled by add-ons, which are little programs that declare themselves to Explorer so it knows to load them when encountering a matching file-type. Unfortunately, Microsoft supplies add-ons for only a few most-used file-types, leaving the work for other file-types to the companies that invented them. LibreOffice has not ...


1

I'm afraid, it isn't possible at the moment, because there is no extension developed yet. You can keep track of the development here: https://bz.apache.org/ooo/show_bug.cgi?id=107602 (and vote on the issue, to receive more attention) However, there is a possibility, that may seams a little odd. It is, in my eyes, an overkill, but could be worth a shot, if ...


0

Put in the top row of a helper column in Spreadsheet A (for example, column D if your data is in columns A to C) this formula: =ISERROR(MATCH(A1,Sheet2.A$1:A$3,0)) Change A1 to the top row of your column with the IDs. Change the reference to Sheet2 to Spreadsheet B (I'm not clear if this is a separate workbook or a separate sheet). Change the range ...


0

I have installed an Older version of LibreOffice 4.X and Hebrew text (RTL) works flawlessly. The fresh install 5.X doesn't yet work very well with Hebrew (RTL). This was tested only on MAC OSX EL Capitan


0

Perhaps the cursor is actually in the correct place but is just getting displayed in the wrong place. I have experienced this with right-to-left scripts on some systems. To test this: In a new document, type one word, press space, then type another word. Save as PDF. Are the words rendered correctly in the PDF file? You may find that the stable ...


1

The macro language does not have access to spreadsheet functions unless you spend several lines loading up the one you want. For the purpose here, it would be much simpler to just use the Basic concatenate operator of &. Like so: Case "0" binOut = binOut & "0000"


0

In LibreOffice Impress, right-click on the text frame and go to Text.... Under Spacing to Borders, increase Left, Top, Right and Bottom. Then press OK.


0

Is there a way to increase the background size, as in making it wider? Place the text in a text box: "Insert" > "Text Box" Add text "Format" > "Alignment" > "Centered" and "Center" Right click "Area...", select "Area" tab, select "Fill" colour Result:


1

Press Releases – The Document Foundation Blog feed announces new releases of LibreOffice, LibreOffice development news, LibreOffice conference news, and other topics related to LibreOffice. If you are using Firefox you can subscribe to the RSS feed by clicking the Subscribe Now button on the webpage or subscribe to the feed by copying the link into an RSS ...



Top 50 recent answers are included