First time here? Check out the FAQ!
|2017-02-24 23:27:22 +0100||received badge||● Nice Answer (source)|
|2017-02-24 23:20:30 +0100||commented question|| What's causes partially loaded tiling issue with LibreOffice online? |
I suppose you should ask developers at #libreoffice at FreeNode
|2017-02-24 23:12:13 +0100||commented answer||Globalscope.BasicLibraries.LoadLibrary(<lib name>) etc. not working|
|2017-02-24 18:38:30 +0100||answered a question|| how to preserve formatting across save and reopen |
You don't tell which is the format you use to save your document. If that's not LO native format (ODF), then it may happen that round-trip is not prefect, and also it may be that you need to change your formatting a little. E.g., you may specify different first page format in several different ways: you may define different header for first page in the style; or you may define different styles and define their sequence; or you may insert page break with style. They may have different support on round-trip.
|2017-02-24 15:51:06 +0100||answered a question|| I'm so frustrated i'm about to quit my friggen JOB, AHH.. HEADERS. What is the deal with seting up a header? Somebody please |
When I format page (
If you need header, it is controlled on the same dialog. Margin (on
|2017-02-24 07:16:18 +0100||answered a question|| Globalscope.BasicLibraries.LoadLibrary(<lib name>) etc. not working |
You may find this useful: https://wiki.openoffice.org/wiki/Docu...
GlobalScope doesn't relate to open documents' libraries. If you use a library from current document, you need to use
|2017-02-24 07:06:02 +0100||answered a question|| Creating a table of contents with chapter and sub-chapter numbering |
ToC isn't intended to be writable (although you may make it so). Its purpose is to get the outline information from your chapters' headers.
You need to use multiple levels of headings to achieve what you need. Use Heading 2 for your sub-chapters. And use Outline Numbering feature to establish proper multi-level numbering. Only then will you have proper ToC.
|2017-02-24 06:25:21 +0100||commented answer|| Unable to record macro |
JRE is definitely not required to be enabled to macro recording to work. I explicitly disabled it in advanced settings of LO 188.8.131.52 x64 on Win10 (I have only 184.108.40.206 installed), reloaded LO, and successfully recorded a sample macro.
|2017-02-24 06:18:48 +0100||answered a question|| Will Excel add-in works with Calc? |
Excel add-ins will definitely not work with LibreOffice Calc. An add-in developer may decide to develop a Calc version of the add-in, however. You should contact developer of the add-in to get actual information.
|2017-02-23 20:59:53 +0100||answered a question|| How to remove ALL formatting in LibreOffice Writer? |
There's no one button for this in LO.
However, it's not difficult to do what you want. Any text has only few kind of formatting applied: Character formatting, Paragraph formatting, and List formatting. Each of them may be direct or using styles.
So, you need four actions when you pressed Enter and are in the newly created paragraph:
Of course, you may apply other styles instead, that fit you best. What I described is just the closest to "remove all formatting" that you asked for.
|2017-02-23 18:11:28 +0100||answered a question|| Header issues starting from page 3 |
Just tested with OpenOffice.org 3.3, as well as with Apache OpenOffice 3.4 and 4.1.3. All these programs don't show any logos are displayed on pages 3+ in the document you provided (I attach it here for reference: PPAWP.102.E541A.75896734.odt). And they can't: the styles of third and following pages don't specify any picture (you may see it if you open the ODT as ZIP archive and look into styles.xml).
Header in first style looks like this:
And for third, it is like this:
|2017-02-23 10:18:34 +0100||answered a question|| Which version of LibreOffice fixed the SAXParseException error? |
These errors mean that LO generated somehow wrong file. These errors are sometimes introduced, and then fixed in some later version.
If your LO always generates the files broken (e.g., if you just create new blank document and save it as DOCX, and it's already broken), then I can assure you that it's fixed long ago. But if that's some documents that get broken when re-saved to DOCX, then you need at least share one (ODT), so that others could test and answer.
|2017-02-22 14:19:05 +0100||received badge||● Student (source)|
|2017-02-22 14:18:39 +0100||received badge||● Good Answer (source)|
|2017-02-22 07:30:44 +0100||commented answer|| Hatching for cells not found in Calc 5.0.4 |
@Ratslinger: one more nitpick: the root extension's page still tells that "current" is 1.0, although shows 1.1 available. Is some action required to mark newer as current?
|2017-02-21 12:57:15 +0100||commented question|| Why can't I insert a photograph or scan into Writer. |
You would possibly like to describe your OS, and your LO version.
|2017-02-21 12:24:41 +0100||answered a question|| Set interaction through API |
Well, this blog post (and the whole series) describes how to write a LibreOffice unit test (in Python) for UI interactions. Possibly it may be of some help. You may also contact the author (Markus Mohrhard, one of LibreOffice lead Calc developers) on #libreoffice channel on FreeNode (IRC nick moggi).
|2017-02-21 11:06:24 +0100||received badge||● Nice Answer (source)|
|2017-02-21 08:04:04 +0100||commented answer|| How do I resgister Libre Office? |
LibreOffice definitely doesn't have any registration from day one. I suppose that OP has some malware in system - either LO itself was modified where it was taken from, of some virus.
|2017-02-21 07:59:51 +0100||commented answer|| Hatching for cells not found in Calc 5.0.4 |
Current URL for the extension is https://extensions.libreoffice.org/ex...
|2017-02-21 06:45:49 +0100||answered a question|| How to turn off paste popup for calc? |
This question is a bright example of how to not ask questions from fellow users that compose this community-driven project. Anyone would easily see frustration, anger etc, but will have hard time understanding what exactly the asker actually wants. And if that is some psychological help that is required, then this is a wrong forum to get it.
If, however, a solution of use issue is wanted, then the best is to strip emotions from your words, and give clear information to readers: what you are trying to do (I assume, this will be "I'm trying to paste plain text from clipboard"), what problem do you see (maybe it's "I can't find a way to do it without additional step - either two clicks with mouse to choose from drop-down menu, or selecting from Paste Special dialog"), and what you've tried so far ("I tried to customize keyboard shortcuts, but didn't find "Paste as Plain Text" action; I tried to write a macro, but this is what doesn't work for me: it gives .... <here is="" my="" macro="">") etc.
Trying to answer your question, I recorded a macro, and it seems to just do the job:
I don't know it you tried this, and if it somehow doesn't suite your needs. But I would save this macro to "My Macros"->"Standard", and assign a keyboard shortcut to it to give a try.
|2017-02-20 16:04:08 +0100||answered a question|| All functions return result of ### |
Looks like your columns are too narrow for the output. Try to make them wider, or choose smaller font.
|2017-02-20 15:47:01 +0100||answered a question|| How to open an ods file in excel |
I suppose that you have an older MS Office version, otherwise @Lupp's advise is the best.
However, you mention that
I suppose it means that you do have LO installed. If so, then you may use it to batch-convert files to XLS, if you want, and not one-by-one as you mention. You may look here for an example. Feel free to add a comment below if you need further assistance.
|2017-02-20 15:43:06 +0100||commented question|| How to open an ods file in excel |
Well, that's not an MS program. I suppose that you came across it on some MS forum, where other people share their experience, and are free to offer any solution, not necessary from MS.
This is the official download page for the program you mentioned; and it claims to support both Word and Excel to open their respective ODF counterparts.
|2017-02-20 13:50:17 +0100||commented answer|| Autoformat - writer/calc - missing something? |
Autoformat predates table styles. It was there ~forever (in OOo times).
|2017-02-20 11:03:11 +0100||answered a question|| Where's the next/previous-page button for custom toolbar? |
I see it in "All Categories" and in "Navigate" as "To Begin Of Next Page"/"To Begin Of Previous Page" (at least in 220.127.116.11).
|2017-02-20 09:02:41 +0100||answered a question|| Apply Results of Conditional Formatting to Other Cells |
Just use formula in conditional formattings in Upper Correlation Table (UCT). E.g., if UCT is A1:B2, and Lower Table of p-Values is A4:B5, then first select A1:B2, go to
|2017-02-20 08:38:10 +0100||answered a question|| Remote Desktop Server Environment? |
Yes it can.
|2017-02-20 07:11:47 +0100||answered a question|| How can I fix the headers in a spreadsheet so, that they will be printed on each page? |
If your "headers" are rows to repeat, then you need to define print range and edit it (using
|2017-02-20 05:41:12 +0100||answered a question|| How do I get empty cells to print in Calc. |
You need to select the whole printing range (including your calculations) and use
|2017-02-20 00:11:44 +0100||commented answer|| write - how to create a template |
Why? The same as with pages: you need to go to the new place (either by inserting column break, or e.g. with
|2017-02-20 00:08:44 +0100||answered a question|| .Docx has a different page count in LibreOffice |
This is a bug. I filed it for you a couple of days ago.
|2017-02-19 21:51:57 +0100||commented answer|| Option to embed images in generated html file |
The Oliver's patch made it comparatively easy (in code) to select either embedded or linked variant. You may want to file a feature request for an option, with a link to the mentioned bug report as See Also.
|2017-02-19 21:31:12 +0100||answered a question|| Is it possible to modify placeholders in a .odt file using python? |
ODT files are zipped archives with XML files and binary embeddings. You may unzip/modify/zip.
You also may like to look at FODT which is plain XML without compression (for a price of size).
Another option is to use Python-UNO bridge to control LibreOffice itself. But that may be overkill in some simple scenarios.
|2017-02-19 21:22:29 +0100||answered a question||Option to embed images in generated html file|
|2017-02-19 20:46:16 +0100||answered a question|| write - how to create a template |
Use columns, like here: notebook.ott
However, a better approach would be to use half-size pages with page border, and simply print two pages on one.
|2017-02-19 20:32:16 +0100||commented question|| How to Move files to other folders & to Delete unwanted files & folders |
A suppose an answer would be to replace a computer with another one with more free space?
|2017-02-19 16:16:11 +0100||commented question|| How to open an ods file in excel |
It's funny that you ask for a "similar patch" and at the same time don't provide information about which original "patch that helps open odf files in MS Word" are you talking about. For one, I would be very curious about that.
|2017-02-19 16:09:25 +0100||commented answer|| convert-to command line parameter |
Headless is now implied for --convert-to, and it's completely not necessary to use it explicitly here.
|2017-02-19 16:09:19 +0100||commented answer|| convert-to command line parameter |
Since long time, under Windows correct syntax is also --convert-to (with two dashes). Headless is now implied for --convert-to, and it's completely not necessary to use it explicitly here.
|2017-02-19 08:56:58 +0100||answered a question|| how fill down with dates with blank rows |
You just need to use date formula instead of direct dates. E.g., put
|2017-02-19 08:38:52 +0100||commented answer|| Text from other app used to be formatted |
It also has a patch for 5.3.1. It is still unclear if the patch is complete, though. A comment there suggests that more fixes may be required.