Questions tagged [openoffice]
Open source application suite that includes Writer, Calc, Impress, Base, Draw and Math
558
questions
0
votes
3answers
40 views
How to open .XLS in excel viewer without changing default program?
I have two excel .XLS files. We need one of the files to be opened using Excel Viewer and the other is being opened using OpenOffice. the file using excel viewer cannot be edited hence using the ...
1
vote
0answers
8 views
Searching indexed spreadsheets from Windows 10 explorer “search”
I have a client that used to use Windows 7, and was able to search directly from the Windows explorer (start menu) to find spreadsheets by searching a number that was on column B within. Now that they'...
0
votes
0answers
8 views
How to make Open Office Writer correct spelling?
It will not automatically correct spelling. Instead it underlines bad words in red. How do I automatically correct spelling?
0
votes
0answers
33 views
Mac Big Sur repeatedly tries to open “Open Office” for no obvious reason. I suspect malware
Something is periodically (every hour or so) trying to open "OpenOffice" while I'm working in other apps. Because OpenOffice was previously downloaded onto my machine, I get a warning about ...
0
votes
0answers
16 views
Libreoffice calc multiple horizontal window splits
On a libreoffice calc spreadsheet I would like to have two horizontal splits to yield three window areas.
I have the top several lines split off and frozen to provide headings, title and unit ...
0
votes
0answers
7 views
OpenOffice Calc understanding this user defined cell format
I'm using OpenOffice Calc to write to a template spreadsheet from HMRC. They're very strict in their formatting so they've laid everything out and I need to fill in the data.
However, when I add a ...
1
vote
2answers
55 views
Excel formula help please?
I'm hoping someone can help me figure this out as I am frying my brain with this.
I am trying to figure out how to input the formula so if and when numbers are entered, the total is shown.
Like for ...
0
votes
0answers
16 views
How to use multiple if statements in open office calc
The question is to Write the function to Grade of total marks of all subjects.
Criteria of grade:
A+ >= 90
B+ >= 75
C+ >= 50
D+ >= 33
0
votes
1answer
9 views
OpenOffice Macro - How to append text to “Author” field
currently I have an OO macro that processes a document and then sets the "Author" by using:
oDoc.getDocumentProperties().Author = cAuthor
However that replaces any existing text in that ...
1
vote
0answers
43 views
OpenOffice Calc: Is it possible to create conditional formatting to highlight a row based on checkmarks?
This is kind of a two-part question.
Is it possible to create conditional formatting to highlight an entire row with a certain color based on whether the checkmark object in the row is selected? For ...
0
votes
1answer
29 views
XLS: 'if statement' calculation
I have a cell B19 which consists of taking the value of another cell and dividing it by 5:
=B15/5
However I'd like to change it so that it only divides it by 5 if the B15 is more than 1000... and for ...
0
votes
0answers
13 views
How prevent objects from snapping back into position in LibreOffice Writer?
How can I disable this super-annoying "feature" causing objects (e.g. a drawn rectangle) to snap back into its original position when doing drag & drop? I simply want to translate a ...
0
votes
0answers
11 views
Turning off smart quotes in OpenOffice for a single document
That's pretty much it. I have an OpenOffice spreadsheet, and for my purposes it's essential that the quotation marks in it be straight ones, not "smart" ones. But for all my other OpenOffice ...
0
votes
0answers
19 views
Can OpenOffice Calc AutoInput reference data on a different sheet?
I've set up a spreadsheet in OpenOffice for project estimation at a contractor. The first column is a description of the item or service that I'm adding into the price. Since there are many commonly ...
1
vote
1answer
322 views
How can I escape commas in a CSV file?
I thought there were two ways to do this: either enclose the field containing the comma in quotes, or place a backslash before the comma. However neither of these is working; when I load up the CSV ...
0
votes
0answers
3 views
Master slides in OpenOffice Impress
I'm using OpenOffice for Mac and am trying to create custom master slides.
I've tried viewing in Slide Master and created a new master slide, it then gives me the following:
I am trying to remove the ...
0
votes
0answers
21 views
OpenOffice: different font weights
I'm using OO for Mac, although I've had this same problem with LibreOffice and I think maybe MS Office too.
And the problem is that, for fonts that have a lot of different weights, I can only use ...
0
votes
0answers
12 views
Single Column, 1000's of Rows, Print as 2 Columns on Single Page
Imagine this...
Just column A, every row down to say... 200, populated with first names.
John
Jane
Bob
Mark
Joe
Timmy
When I print this... I want it to come out as:
John Mark
Jane Joe
Bob ...
1
vote
0answers
13 views
How do I turn off autoformat OpenCalc / OpenOffice Spreadsheets
Without context and background: Read the title, How do I turn off AutoCorrect in OpenCalc, specifically time, preferably turn off all AutoFormat.
I am using a spreadsheet to track how fast my online ...
0
votes
1answer
316 views
Mime type of MS Office documents saved from OpenOffice etc. is not recognized in Debian 9
Just today I faced the problem that document created by OpenOffice package and saved in XLSX format, recognized in Debian 9 as octet-stream instead of valid MS Office format:
root@linux# file -b --...
1
vote
1answer
42 views
Can I get this Perl command on Windows to not generate dates with apostrophes in LibreOffice?
Based on the help I got on this question, I have this Perl command that I run in Windows 10 PowerShell:
ls |% { $_.Name } | perl -pe 's/(.)(.*)_(\d{4})(\d{2})(\d{2})_(\d+).jpg/\u$1$2,$3-$4-$5,$6,$&...
1
vote
1answer
91 views
Is it possible to combine two IF(AND functions into one? (OpenOffice Calc 4.1.7)
Is it possible to combine two IF/AND functions into one? (OpenOffice Calc)
I have two IF/AND functions that work perfectly well, however I need them to both work on the same line. Is there anyway to ...
0
votes
1answer
117 views
How to Install LibreOffice Python on MacOS
I'd like to use Python to manipulate LibreOffice documents using the UNO API. I have LibreOffice 6.3.4.2 and Python 3.7 on MACOS (OS X).
I find doc which says UNO is available in the Python shipped ...
1
vote
1answer
112 views
How to copy a new line from libreoffice calc to txt?
I have the following function in cell 'B2' a libreoffice calc document:
=CONCAT(A1,CHAR(10),A2,CHAR(10),"end")
Which, with in cell A1="function plotName = getPlotName(plotData)" and A2=" plotName ...
0
votes
0answers
52 views
Excel turns my floats into integers
The following is part of the output of a code I have written. When I open it with excel part of the floats turn into integers while others remain.
Wrong:
Correct:
When I sort them in ascending ...
0
votes
1answer
599 views
I can't uninstall open office 4.1.7
I just got a brand new laptop. I install open office but could not make it run. So I try to uninstall it. But I can't do that either. :(
When I try using the Windows remove program option from the ...
0
votes
1answer
174 views
ssh X11 forwarding from multiple clients simultaneously always opens openoffice windows on the same screen - bug or feature?
Situation:
Three "computers":
A. a desktop with its own display
B. a virtual machine on A (kvm)
C. a small PC with its own display
I generally work on A, ssh -Y to B from A, work with firefox --...
0
votes
1answer
182 views
How can I stop Open Office Calc from changing the data?
I am using Apache Open Office Calc to view CSV data. I just noticed that Calc rounds the data on saving, reducing its precision, or at least I think that's what's going on.
I show below the same data ...
1
vote
0answers
86 views
Adding language (Dutch) to LibreOffice Writer
I'm having trouble doing a spelling check in LibreOffice (in Dutch). It supposed to come with the package but it doesn't show in my screen (see image: no abc mentioned before 'dutch').
I tried:
...
1
vote
1answer
209 views
LibreOffice fails to export PDF containing arabic letters
I used LibreOffice to write an arabic document.
When exporting this document to PDF through the LibreOffice "File -> Export...", I get an unexpected result: the PDF is different from the original ...
1
vote
0answers
32 views
Widowed pilcrow (non printable ¶ at line begining) in LibreOffice
I'm struggling with widowed pilcrows (i.e. non-printable ¶ at beginning of lines). This happens only in footnotes, on page-breaks, and it adds a space between the footnote's rule and the first ...
0
votes
1answer
41 views
Stop OpenOffice from removing decimal places
In a table-cell when I type 1.00 and move the focus from the cell OpenOffice
removes the decimal places from the number and makes it 1!
Why is this happening?
How do I stop this from happening?
0
votes
1answer
20 views
How to order column in open office
I have a column like this
RA1
RC4
RJ9
RA3
RA2
RA10
RD14
RA11
and I want to get
RA1
RA2
RA3
RA10
RA11
etc..
Not
RA1
RA10
RA11
RA2
etc...
There's any way to change the behavior?
0
votes
1answer
214 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
1answer
233 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
238 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
1answer
86 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
26 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 ...
2
votes
0answers
42 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
192 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
1k 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
2k 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 ...
3
votes
1answer
264 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
341 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
159 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
41 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
2k 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
127 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
49 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
137 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 ...
