Tag Info

New answers tagged

0

Use your favorite ZIP utility to unZip a copy of the file. Use you favorite XML editor to open the file content.xml. Look at position 2,604924 and try to figure out what is wrong. Once you’ve found the error (a misspelling, a duplicate property, that kind of thing), fix it. If the problem isn’t obvious, maybe post the XML code from this region as part of ...


0

I think there's currently no way of doing this cleanly, here's a workaround: Assuming you have entered e.g. http://test.com into a cell, and it got auto-formatted as a hyperlink. Click the cell so that it becomes active (make sure it has indeed become active, because clicking the hyperlink itself will do nothing) Select the text in the formula bar Cut it ...


0

1) Record a macro for merging a set of selected cells, or make the macro select a fixed set of cells and then merge them. 2) read "Assigning macros" under "Shortcut keys" in the help, and follow the instructions. To assign a script to a key combination 1. Choose Tools - Customize - Keyboard. 2. In the Category list box, scroll down and open the ...


1

In LibreOffice, while selecting a cell, hit ctrl+alt+c. This will add a note to the cell, where you can type what you want, and it will add a red square in the top right corner of the cell. To view this comment/note again, simply select the cell, and hover your mouse over the red square.


1

How can I make sure that every single page's margins are changed? The reason it wasn't working for you is that in the document every chapter has it's own (different) page style. To fix this: Press f11 to display "Styles and Formatting" Select "Page Styles" Delete all of the "Convert xx" pages styles (select the styles one by one and press del). All ...


1

Too stupid. The basic problem was, that the default page size was letter, and that LO refuses to print to A4 (as selected by all instances of printer property options I could find - within WIN printer defaults, LO, ...) - UNLESS LO was told to actually use the selectd paper size: Printer -> Options -> USE ONLY PAPER SIZE FROM PRINTER PREFERENCES! ...


1

Lets say your checkbox is in cell A1 and if checked it returns a value of true. Then the logical functions looks like this =IF(A1 = "true" ;0;1) explained =IF(A1 = "true" ; "then this value" ; "else this other value") Problem was that the conditional does not work on text or string values that's why we go with this example: =IF(A1 = "true" ;0;1) ...


2

F2, Same as in Microsoft Excel. Once done you can press Enter to switch to next row.


1

I used a registry search and replace tool to solve this. There's many available online. There were some OemPath keys I couldn't modify.


1

If your E: drives files/folders is still there, you can do something like this: Run subst E: D:\E_Drive or subst E: D:\ from a command prompt and that will substitute E: with D: and let LibreOffice think that E: is still there. To delete E: run subst E: /D from a command prompt.


0

LibreOffice 5.0.0.5 is released 8/5/2015 upgrade and see if the problem persists.



Top 50 recent answers are included