Ask Your Question

Andrew_P's profile - activity

2019-05-22 01:20:17 +0200 commented answer Basic Macro - Date NumberFormat

This question/answer is a prime example of how the LibreOffice Forum "karma" system is counterproductive. I would very

2018-03-15 07:27:55 +0200 commented question looking for last row used programmatically

The MRI extension doesn't appear to work and isn't even installable in LibreOffice 4.3. When I tried to install it, the

2018-03-15 07:27:04 +0200 commented question looking for last row used programmatically

The MRI extension doesn't appear to work or is even installable in LibreOffice 4.3. When I tried to install it, the Ext

2015-11-11 15:37:42 +0200 commented answer All cell comments have disappeared in calc

To view the earlier bug report, see https://bugs.documentfoundation.org/show_bug.cgi?id=77383.

2015-11-11 15:36:09 +0200 commented answer All cell comments have disappeared in calc

Your bug 77383 was closed as "invalid" due to "lack of activity", but the bug persists in LibreOffice Calc 4.3.5.2. It can be demonstrated very easily. Open a new sheet and enter a number or some text in a cell. Add a comment. Click on another cell, then go back to the cell in which you entered data. Press the delete key while the cell is selected or move the cursor to the Input Line and backspace to remove all the characters. The comment disappears. This is unexpected behavior.

2015-01-27 19:16:36 +0200 commented answer How do I insert special characters in LibreOffice on Ubuntu if Alt+188 or other key combinations don't work?

As you enter the Unicode, it will display the numeric value temporarily. For example, for Unicode character (U+2009), when you press Ctrl+Shift+u, you will first see an underlined lowercase "U", then the digits of the code you are entering. Press Enter or to complete the sequence; the u2009 code will be replaced by the Unicode character, if the font you are using supports it. You can omit the leading zeros for codes that have them and the result is the same.

2014-11-29 20:58:52 +0200 answered a question Save a chart/graph as image in Calc?

As of November 2014, I am still running LibreOffice 3 on Linux and do not have direct chart graphics export capability, but there is a fairly easy workaround. With Inkscape installed on the computer, I export the chart from Calc to a PDF file, then extract the chart from the PDF using Inkscape. This allows one full freedom to manipulate the graphics in vector format, then export as PNG or save as SVG for use in other applications.

  1. Click on the chart in LibreOffice Calc to select it; eight small, green squares appear around the edges.
  2. In the menu bar, click File > Export as PDF...
  3. In the PDF Options dialog, select Range: "Selection", then click on the Export button and save the PDF file.
  4. Start up Inkscape and import the PDF file thus generated. It should contain only the chart, not the spreadsheet, with all graphics in a single group.
  5. Ungroup everything and delete the page header and footer text, if it is there, plus any objects not needed for your target application.
  6. Some objects, such as grid lines and tick marks on the axes, may not be visible, because they have no fill or stroke assigned to them, but this can be corrected in Inkscape with the Fill and Stroke toolbox.

Once the fix-ups are done, save the image in SVG format, and if desired, export a copy in PNG format at the desired scale. Using vector graphics allows the chart image to be scaled practically without limit, yet preserving smooth, clear appearance at all scale factors.

Free Inkscape binaries are available for most popular operating systems, including Linux, Mac OS X, and Microsoft Windows.

2013-07-05 20:15:29 +0200 answered a question normal.ott does not exist

I'm seeing the same problem with LibreOffice 3.4.5 on Ubuntu Linux 10.04. Unless I put a normal.ott file in ~/Templates, LibreOffice Writer complains and defaults to its built-in page settings, even though I've completely removed ~/Templates from the LibreOffice "Paths" options. This is definitely a bug: LibreOffice should be looking at my ~/Templates directory at all. Has a bug report been filed on this issue?

(Sorry about posting this comment as an "answer": There is no "comment tool" visible on my browser screen -- another bug.)