Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [openoffice]

Open source application suite that includes Writer, Calc, Impress, Base, Draw and Math

0
votes
0answers
5 views

How to Use KDE File Chooser In Libreoffice 6.2.2.2?

I changed the file chooser a while back because my version of Libreoffice Writer crashed all the time when I would go to choose a file. There have been a few versions between then and I would like to ...
1
vote
0answers
29 views

OpenOffice Calc import special characters in CSV incorrrectly?

I'm trying to import a CSV file to OpenOffice Calc, but the program is reading special characters incorrectly. For example, one of the fields in the CSV is "Puma La Cerámica", but Calc imports it ...
0
votes
1answer
29 views

How to Remove Paragraph Breaks in openoffice

I am using openoffice 4 and i have a Paragraph Breaks between two pages and i want to avoid it
0
votes
0answers
6 views

Mac OpenOffice Writer

I am have trouble exporting my book to pdf. There are 159 images in black and white. The images resolutions have been changed to 300ppi by me as required by the printing company but when exported the ...
0
votes
1answer
49 views

Calc pie chart for 25000 rows with long tail

I have a file that contains 25,000 rows, each row containing a number, looking like this: 4000 3000 1500 700 ... 2 1 1 1 From this I want to make a pie chart. The first few pie parts will be ...
0
votes
0answers
20 views

Merge ttwo tables using order id number where one table has multiple rows with the same id number

I'll first explain what I'm trying to accomplish then give the table details. I'm trying to export sales data from my website and organize it by order id number so I can easily see which orders were ...
0
votes
0answers
4 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
34 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
133 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
405 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
43 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
119 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
63 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
37 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
393 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
72 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
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
72 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
186 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
40 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
233 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
1answer
496 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
1answer
283 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
138 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
437 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
1k 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
106 views

Open Office is not showing in English, even though the English language is selected

I don't understand what happened with this Open Office installation. It's on a college computer (Linux), so I can't do a reinstallation without admin access. I have English language selected in ...
1
vote
1answer
116 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
65 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
89 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
313 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
72 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
33 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
242 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
111 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
53 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
459 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
526 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
376 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
204 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
652 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
443 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
834 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
14k 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 ...