Questions tagged [openoffice]
Open source application suite that includes Writer, Calc, Impress, Base, Draw and Math
0
votes
0answers
3 views
How do I move around chapters in kingsoft office writer ?
Is there a way to acheive the same functionality as Libreoffice/OpenOffice Navigator's Chapter Up/Chapter Down button in Kingsoft office writer ?
These buttons allow you to move around a header and ...
2
votes
0answers
25 views
How get text lines larger than 69cm?
I’m using Apache OpenOffice 4.1.6 and I want to convert a text file to ᴘᴅꜰ without automatic line returns.
In practice this requires using very wide page sizes.
I enabled landscape mode set page as ...
0
votes
2answers
29 views
Calc print several sheets in same page
I have a Libreoffice Calc spreadsheet that holds around fifty sheets (each one with no more than a dozen valued rows); this is good for data organization — each sheet holds a sequence of events ...
0
votes
2answers
55 views
OpenOffice/LibreOffice Calc how to not print column but show it in sheet?
I have a column with hyperlinks to other parts of the same spreadsheet and I want this column to be visible inside the program, but hidden when printed: it should not take up space.
The only solution ...
0
votes
1answer
208 views
What to Save As when exporting Visio .vsd to OpenOffice or LibreOffice to minimize differences?
I have a Microsoft Visio Pro. 2010 file (.vsd), and I want to work with it in LibreOffice (or OpenOffice, as a secondary option).
When I import the .vsd file to LibreOffice, there are many ...
1
vote
1answer
42 views
Opening a .doc file, which is actually an HTML file, as a .doc file
My software generates .doc files which are actually HTML files but with the ".doc" extension.
When I open them in Microsoft Office they open as a .doc file and the user does not know that it is ...
2
votes
2answers
83 views
Document shows text in “Khmer UI”, but that font is not in available list
I received a Document (*.doc) and am able to open it in OpenOffice (3.4.1), where I see that the font shown in the font selection dropdown is "Khmer UI".
When I click the dropdown, the font name ...
1
vote
1answer
62 views
How to delete a large image from my libre office doc?
I'm using Libre Office Writer 5.4.5.1 (x64); I added a very large image (81 MB) to a doc (which already has several images, but none that large).
The document keeps going into "Not Responding" mode, ...
1
vote
0answers
35 views
Windows 7 remove “Application Link” from open and save explore window in OpenOffice
Been digging around for an answer for a couple hours, and all the results I am getting are completely irrelevant.
For some reason OpenOffice, in its "Open" and "Save as" file explorer windows, has ...
1
vote
1answer
242 views
How can I add duplicate rows to LibreOffice Calc to make there be one per day?
I have some data like this (it's stock market data)
29/07/2015 35972.82 32056.2 17751.39
30/07/2015 35961.86 32046.43 17745.98
31/07/2015 35848.13 31945.08 17689.86
03/08/2015 ...
0
votes
0answers
59 views
Can't see VBA when I open XLS in OO or Libre Office
I've got some spreadsheets in Office 97 format. When I open the spreadsheet in Open Office 4.15 (or any version), none of my VBA is visible in the OO Basic editor. I can save the spreadsheet as ODS, ...
0
votes
0answers
9 views
Use different margin for header of document than text
I am using OpenOffice Writer version 3.4.1 and I cannot change the margin of the header to be negative, i.e. to be to the right of the text. For example:
In the screenshot above, you can see that the ...
0
votes
2answers
41 views
Need to delete specific rows that are missing an email
I have a spreadsheet I want to delete the rows that are missing an email. How do I sort and delete each of those rows?
2
votes
1answer
58 views
Word/Writer — Bible-like two column layout
Is there a way to create a "standard" bible-like layout in Microsoft Word or OpenOffice Writer without using tables?
It should be a two column layout but the columns are not "global":
Paragraph 1 ...
2
votes
1answer
17 views
Rule based highlighting in open office
I use notepad for some rule based highlighting of text... but I need more control/formatting. So I moved to open office... rather than search and replace, which requires repeated use ever time I ...
0
votes
1answer
127 views
Remove blank cells containing a formula in OpenOffice Calc
I am attempting to remove blank cell values which also have a formula, from a column in OpenOffice calc.
Row numbers and corresponding data:
1 A1
2 A4
3
4 A9
5
6 A98
Each cell in the data ...
0
votes
0answers
39 views
Recovering OpenOffice password - CL_INVALID_BINARY
I have an OpenOffice Document that I protected with password (its length should be 4 characters).
Unfortunately I forgot the password I set so I am trying to recover it by using brute force.
I have ...
0
votes
1answer
149 views
Put transparent form fields/text areas on an image in Openoffice Writer?
I'd like to create a few pages with a background image and (different) text at the same areas on the image. Think of invitation cards or recipes - there is some structure (recipient and location, or ...
0
votes
0answers
44 views
Can I create a sheet which sums groups of N rows in LibreOffice Calc?
I have a LibreOffice Calc spreadsheet which has this structure
APPLES ORANGES BANANAS
5 0 10
15 2 12
3 2 105
...
0
votes
1answer
365 views
“File Access Denied” when using “Remove Properties and Personal Information” from ODT files
Trying to use the Remove Properties and Personal Information feature in Windows 7.
To use this feature, you right-click the file in question and select Properties. On the Details tab, there is a link ...
0
votes
0answers
88 views
Libreoffice Calc creating every pivot table of two variables possible
I have a big table of data that looks like this :
image
and I want to compare them in a pivot table with two variables each time. I find it very long to select every variable. Is it possible to ...
0
votes
1answer
245 views
GhostScript | LibreOffice. Is there a way to change page order before printing?
I've got one typed story to print as a small (A5) book, and my wife is willing to sew pages together. But one problem is, pages in document must be in specific order: 4-1-2-3-8-5-6-7-etc.
First I ...
0
votes
1answer
108 views
How to open csv with blank columns correctly in open office [closed]
I have a CSV file that looks like this:
"column1",,"column3"
"column1",column2,
Sometimes the CSV contains blank column(s). Is it possible to open it correctly in Open Office?
1
vote
2answers
399 views
How to just add conditional formatting to a cell without overwriting the cell's direct formatting
I have different cells with different background colors. Depending on a Conditional Formatting I'd like to add borders around some of these cells.
Applying the borders works but the cells' ...
1
vote
1answer
709 views
How do I get a keyboard shortcut (CTRL+K or otherwise) working for hyperlink in OpenOffice?
In OpenOffice (Writer, in this example), I can right-click on any toolbar, select Customize Toolbar, and then click the Keyboard tab in the dialog. At the top, there is a list of shortcut keys and a ...
2
votes
1answer
96 views
Open office is not showing in English, even though English language is selected
I don't what happended in this open office installation. Its on college computer (Linux), so I can't do a reinstallation without admin access.
I have English language selected in Language setting, ...
1
vote
1answer
112 views
Show the arrangement stack of a page or document
Right-clicking an image (or -for the lack of better word- other "object") on a page
in arrange menu, options such as "bring to front" is shown.
I suppose this is analogue to the z-axis or z-order of ...
1
vote
1answer
41 views
I need a safe reliable way to increase the number of files in OOo's Recent Documents list
The wiki page at apache has links to extensions and macros that do not seem to exist any more, and I cannot follow the written instructions for hand editing because there is no <node oor:name="...
0
votes
1answer
29 views
Should I assume doc file layout differences are not saved, just viewed?
If I open a doc file from environment A in environment B which results in differing layout and then edit and save it, should I assume those differences excluding deliberately edited parts will not be ...
0
votes
1answer
63 views
Insert arrow into image in OpenOffice Draw
I've opened a PNG in OpenOffice Draw (v4.1.2) and inserted an arrow onto the image.
I then right-click the image and select Save as Picture, but the resulting image doesn't have an arrow inserted. ...
0
votes
1answer
23 views
Automatically highlight current chapter in Navigator
Is there way to automatically highlight current chapter in Navigator?
Yes, there are at least two workarounds: (1) use "Chapter" field in Header of the pages or (2) Start every chapter as Section, so ...
0
votes
0answers
86 views
How to change scale of units in OpenOffice
I have made a chart in OpenOffice but in x-axis the values are very small ~10^-3. How can I just change the numbers so that they are scaled without changing the data?
Here's a picture of the x-axis:
...
1
vote
1answer
255 views
How to swap or reverse day and month of date in openoffice?
I have over 3000 rows of numbers that i need to sort by days. but its reading the days wrong.
if i do: Format Cells.. -> Numbers -> Format code -> D.MMM.YY
12/01/15 -> D.MMM.YY -> 1.Jan.15 (...
1
vote
3answers
65 views
How can I copy the formula used in a cell to another cell as a literal formula
Cell A1 has the value 1.
Cell A2 has the value 2.
Cell A3 has the formula entered " = A1 + A2" and shows the value 3.
Similarly Columns B1,B2, B3, C1, C2, C3 etc.. etc..
I want to copy the formula (...
1
vote
1answer
32 views
How to convert list of orders into a date-based calendar
First, I'm aware this is a fairly complex question, if you have a better place for me to ask it, I would be happy to ask again somewhere else.
Here is the question: I've got an open-office document ...
0
votes
1answer
210 views
corrupted file, on flash drive, renamed itself “&”, and won't open on hard drive either
I have a document on flashdrive that suddenly changed to working marvelously to not opening at all. Somehow the file name changed to "&". when I open the file I get this: " & refers to a ...
1
vote
0answers
99 views
LibreOffice and HSQLDB SERVER: cannot access with my Windows Notebook on the HSQLDB Server running on iMAC OSX Sierra
I have used so far the OpenOffice and now LibreOffice package with the standard BASE System, so the HyperSQL DB in Embedded Mode and have to say, it is quiet easy using it on one computer.
However my ...
1
vote
1answer
44 views
How to rearrange rows based on one group in Libreoffice spreadsheet?
I would like to rearrange the LibreOffice Calc rows, based on the values in the first column. For the sheet given below;
| Object Name | Value 1 | Value 2 | Value 3 |...| Value N | OUTPUT |
...
4
votes
1answer
408 views
Fonts appear UGLY in Apache OpenOffice 4 for Windows
In Apache OpenOffice 4 for Windows, fonts are ugly! While text in Microsoft Word is crisp, in Apache OpenOffice, it is blurred as if "artistic rendering -> translucent glass" special effect was added. ...
0
votes
0answers
460 views
Convert datetime string to date/time: OpenOffice
Format of text string: "05/04/2017 04:35 PM CEST"
Desired value: 5/04/2017 10:35 AM
Or "07/15/2017 01:05 AM CEST"
to 07/14/2017 7:35 PM
Possible?
OO 4.1.3 on Win7 Home Premium SP1
2
votes
1answer
310 views
OpenOffice Calc macro in Python - macro triggered by a click of a button, how to get a name of that button?
I am really new to this and OpenOffice Developer's Guide is too difficult for me to understand or I'd help myself.
I have a large number of rows with data and in each row I want a button that would ...
0
votes
1answer
167 views
How do I remove some/all images in LibreOffice Writer using “find and replace”?
Microsoft Word has this nice little feature "find and replace". There I only have to find ^g and replace with nothing and it removes images without using mouse.
I'd like to do the same thing with ...
0
votes
1answer
529 views
Printing two pages per sheet, how to keep first page on the right side in OpenOffice?
I'm writing a book with OpenOffice 4.1.1 and I'd like to print sheets of the book for proofreading. The book uses page styles extensively and the first page is set to be the right page. I can select ...
0
votes
2answers
334 views
How do you get multiple if statements working within the same open office calc cell
I am trying to sort a column out in open office and need the cell values to stay between 10 and 0. I currently have an If statement as follows: If(X6>0;(((S7/V7)-($B$6))/$B$4)+$X$5;0)
I need to ...
1
vote
0answers
746 views
How to reset all toolbars in OpenOffice or LibreOffice without affecting other settings?
How does one reset all toolbars in an OpenOffice or LibreOffice application to their default complement of displayed buttons in default positions without affecting (or resetting) other settings or ...
5
votes
1answer
10k views
How to merge 2 columns into one in LibreOffice or OpenOffice?
In my CSV, using I have to columns which are really just one column, so I want to concatenate the content of these two columns - for each row - into the first one(after this I want to remove the extra ...
4
votes
3answers
4k views
Highlighting every other row in LibreOffice (or OpenOffice) without conditional formatting?
Besides using conditional formatting, is there any way in LibreOffice Calc (or OpenOffice Calc) to highlight every other row in order to make the spreadsheet easier to read?
LibreOffice has a serious ...
2
votes
1answer
349 views
Preventing capitalization in OpenOffice Calc (or LibreOffice Calc)
In OpenOffice Calc (and LibreOffice Calc), the first letter of each cell is auto-corrected to be capitalized.
Is it possible to prevent this, without affecting the behavior of the other applications ...
1
vote
0answers
17 views
Different values in different editors
I opened same document with OpenOffice and with use of Microsoft Word. Document language is english and I use operating system also with english language. MS Word opens the document correctly, but ...
0
votes
1answer
68 views
libreoffice calc - average of sums
Let's say I have some data on columns B through E that I want to average as follows:
for each row: sum the four columns
then take the average such sum
Do I have to get another column for the sum and ...
