Ask Your Question

vandenoever's profile - activity

2016-02-05 14:48:14 +0200 answered a question Conversion to odt from html: no desidered output

The html file needs to start with <!DOCTYPE html or <html. Your filename contains xml so perhaps it starts with an XML declaration.

You can save to ODT in two ways:

  soffice --headless --convert-to odt:writerweb8_writer cleanedHtml.xml.html
  soffice --headless --convert-to odt:writer8 cleanedHtml.xml.html
2016-02-05 14:48:11 +0200 answered a question Will LibreOffice install on ubuntu server

Yes, LibreOffice is available in all versions of Ubuntu Server.

2016-01-31 14:08:11 +0200 answered a question how do you draw schematics in draw
2016-01-26 15:48:22 +0200 answered a question How to remove border from inserted gif into writer (

Right-click on the image and choose 'Crop image'. Now you can drag the red cubes on the corners to change what parts of the image are visible.

2016-01-26 15:46:54 +0200 answered a question How to jump page by page in writer.

You can press Ctrl-Shift-F5 which brings you to the page spin box. There you can type a page number. If you click with your mouse to focus in that box, you can use arrow up and arrow down to move between pages.

Or you can tie keyboard shortcuts to the navigator actions 'To Begin Of Next Page' and 'To Begin Of Previous Page'. (Tools -> Customize, select Category 'Navigate').

2016-01-25 13:51:17 +0200 commented question why does text not show colour on screen?

Can you add a document that has this problem to the question? If your karma is too low, can you add a link to the document hosted elsewhere?

2016-01-25 13:50:51 +0200 answered a question Display impress slides randomly

Shuffling the slides is not a standard function. You could write a bit of code to create it.

Each presentation can have multiple lists of slides. These are called 'Custom Slide Shows'. See the menu item 'Slide shows -> Custom Slide Show'.

If you look inside the content.xml file of your .odp file (unzip it), you can see the simple way in which a custom slide show is created:

<presentation:settings presentation:show="MyRandomPresentation" presentation:mouse-visible="false">
    <presentation:show presentation:name="MyRandomPresentation" presentation:pages="page2,page1"/>

The attribute presentation:pages points to the slides by name.

Perhaps it is possible to create macro to make a random presentation.

2016-01-25 13:50:45 +0200 answered a question How can I use cells in Calc as password fields?

I can see number of reasons why you would want to write passwords in a spreadsheet. I have to guess because you do not explain the reason why you want passwords in the spreadsheet. Obfuscating the passwords or hiding them is not a good idea. Someone with a bit of technical skill will be able to read them anyway.

Here is an _insecure_ solution: hide the sheet that contains the password by clicking on the sheet tab and pressing 'hide'.

A more secure solution is to store only salts and hashes of the passwords in the spreadsheet. Make sure both salt and hash are sufficiently long so that they cannot be cracked. See the documentation in this code for a good explanation.

2016-01-25 13:49:35 +0200 answered a question Move a column from one sheet to another and keep the same data

I replayed your scenario or a similar one.

  1. Start a new .ods file and add one more sheet. (Sheet1, Sheet2)
  2. Write 1 in Sheet1.A1 and drag down with the small black square to fill 20 cells (Sheet1.A1:Sheet1.A20) with numbers 1–20.
  3. Write a formula in Sheet2.A1, =2*Sheet1.A1, and drag to fill cells Sheet2.A1:Sheet2.A20.
  4. Add a new column left of Sheet2.A by clicking the header of Sheet2.A and choosing 'Insert column left' from the context menu.
  5. Cut column Sheet1.A by clicking the column header and typing ctrl-x.
  6. Paste the data back by clicking on the header of Sheet2.A and typing ctrl-v to paste.

With these steps, the references are kept intact.

2016-01-25 13:46:40 +0200 answered a question How can I cross-reference a table

If you add a caption to a table, it will show up in the dialog for creating a reference under the category 'tables'. Make sure to choose

You can add a caption to tables that are placed in frames. Such tables will show up in the 'Index of Tables' that you can add to your document.

Complete list of steps:

  1. Insert -> Frame ...
  2. Place cursor in frame
  3. Insert -> Table
  4. Select frame and choose Insert -> Caption ...; Choose category 'Table'.
  5. Place cursur where you want the reference
  6. Insert -> Cross-reference; select type 'table', select the table you would like to reference
2016-01-25 13:45:37 +0200 answered a question How can save a Libre spread sheet so it can be opened as an attachment by someone using Microsoft Office? I am finding the last few attachments I sent the receiver was unable to open.

You can save the document as a PDF with an ODS embedded by choosing the option 'File -> Export as PDF'. That way the receiver does not even need to have an office suite to view the file.

In the PDF export view, you can choose 'Hybrid PDF (embed ODF file)' to add the spreadsheet inside the PDF file.

If the receiver has MS Office 2010 or newer, sending an ODS file is fine. Those are supported by Microsoft Office.

2016-01-25 11:02:54 +0200 received badge  Enthusiast