Ask Your Question

Mike Kaganski's profile - activity

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

As for second question - oDoc.BasicLibraries works for any opened oDoc.



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 (Format->Page) and set all margins to 0 (on Page tab), and also have both Header on and Footer on unchecked (on respective tabs), I have no space at top (or anywhere else) in my LO (and on any previous that I used). What you describe seems to be severe misunderstanding what you do, and incorrect description.

If you need header, it is controlled on the same dialog. Margin (on Page tab) is space from page edge to header; when you turn header on, you have to setup two values: Height and Spacing. Height is vertical size of header's writable area, and spacing is size between the writable area and page body. So, if you have top margin 20 mm, header height 10 mm, and spacing 5 mm, then from top the page will be organized this way: 20 mm margin + 10 mm header text + 5 mm spacing + page body. Two checkboxes (on Header tab) further control this: Use dynamic spacing and AutoFit height. If AutoFit height is set, then Height defines minimal size (instead of exact size). If both AutoFit height and Use dynamic spacing are set, then when header will grow, it will take the space from spacing (spacing will decrease -> thus, page body will not move) until spacing is exhausted.

2017-02-24 07:16:18 +0100 answered a question Globalscope.BasicLibraries.LoadLibrary(<lib name>) etc. not working

You may find this useful:

GlobalScope doesn't relate to open documents' libraries. If you use a library from current document, you need to use BasicLibraries instead of Globalscope.BasicLibraries.

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 x64 on Win10 (I have only 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:

  1. Clear direct formatting (Ctrl+M).
  2. Apply Default paragraph style from Styles and Formatting sidebar (Paragraph Styles pane)
  3. Apply Default character style from Styles and Formatting sidebar (Character Styles pane)
  4. Turn off numbering (using e.g. F12 or Shift+F12, or toggle buttons on Formatting toolbar).

That's it.

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 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:

<text:p text:style-name="Header">
    <draw:frame draw:style-name="Mfr1" draw:name="Afbeeldingen1" text:anchor-type="paragraph" svg:x="2.574cm" svg:y="1cm" svg:width="2.101cm" svg:height="1.441cm" draw:z-index="0">
        <draw:image xlink:href="Pictures/100000000000053D00000399E6E6D1B066377228.png" xlink:type="simple" xlink:show="embed" xlink:actuate="onLoad"/>

And for third, it is like this:

<text:p text:style-name="Header">
    <draw:frame draw:style-name="Mfr3" draw:name="Image5" text:anchor-type="paragraph" svg:width="0.566cm" svg:height="0.566cm" draw:z-index="0">
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

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:

sub PasteText
rem ----------------------------------------------------------------------
rem define variables
dim document   as object
dim dispatcher as object
rem ----------------------------------------------------------------------
rem get access to the document
document   = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("")

rem ----------------------------------------------------------------------
dim args1(0) as new
args1(0).Name = "Format"
args1(0).Value = 1

dispatcher.executeDispatch(document, ".uno:PasteSpecial", "", 0, args1())

end sub

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 don't like the idea of opening each ods file manually and saving it as xls

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

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 Format->Conditional Formatting->Condition..., and define condition as Formula is - A4<0.01. I.e., you define condition for first (top-left) cell in range. As you don't use absolute addressing ($), you will get this formula changed appropriately (like "if value of cell three rows below in the same column is less than 0.01") when applied to other cells in range.

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 Format->Print Ranges->Edit...) to define repeating rows (and columns, if required) there.

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 Format->Print Ranges->Define, not only those those empty sells you want to add (because initially there's no printing range defined, so if you only select empty range and use Format->Print Ranges->Add, you are adding to an empty range).

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 Tools->Options->LibreOffice Writer->Formatting Aids->Direct Cursor).

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:

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 =C46+7 into C48 - that means "date in C46 plus 7 full days". Then select two cells: C48 and C49 (i.e., the repeating pattern), and drag-copy it (using small rectangle at the bottom right of selection) to wherever you need.

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.