Open source application suite that includes Writer, Calc, Impress, Base, Draw and Math
0
votes
0answers
13 views
Change border color in OpenOffice - macro
When I have table in Open Office and I´ve got there some values (for example 23 and 26) and I need circumscribe all numbers beteen this values, how can I do it in macro?
For your imagination, I post ...
1
vote
1answer
40 views
Find the Nth instance of a text string within a range?
I have a list of names next to a list of shifts. I want to collate a list of people on each shift by day, which will automatically and dynamically update. I can't work out the best way to do it.
In ...
1
vote
3answers
86 views
libreoffice what is a fast way to paste special > text and numbers only (aka paste special values)?
I copy and then paste values in excel quite a bit (when I use Excel). When I use LibreOffice you can do the same thing (see related question here) but it is oh so tedious!
It gets especially tedious ...
0
votes
0answers
8 views
How to Create a User Field that Displays the Product of 2 Other Numeric User Fields?
What I'm trying to do sounds very simple but I cannot find the way.
Price × Percent = Down-Payment
I already created the "Price" and the "Percent" numeric User Fields as variables but I do not know ...
0
votes
1answer
15 views
Excel/Calc: Pivot table with (almost) identical row: how to identify them?
I need to examine via pivot a datasource from a sheet. This datasource sheet is something like this:
| Field 1 | Field 1 | Field 3 |
| AAAA | BBBB | CCCC |
| DDDD | EEEE | FFFF |
| GGGG ...
0
votes
2answers
29 views
Potential issues with working on the same document with Open Office and Word
I'm writing a report and plan to edit it using Open Office 3 and Word 2013. Open Office 3 can save in the .doc format but not .docx, which is the default of Word 2013. Will there be any compatibility ...
0
votes
0answers
27 views
How do I make a document fully read only on Open Office
When I use the security setting and set the password, I can still overwrite my original document. What am I doing wrong?
-1
votes
2answers
181 views
Why can I open .docx with OpenOffice but not .odt with Word?
I am using Office 2007 and OpenOffice 3.3. I have to be able to open and save documents in both formats .docx and .odt. As .odt is an open format why can't Word open and save documents in that Format?
...
0
votes
0answers
10 views
Indent button for lists is dissabled in OpenOffice Impress
So I'm just having a horible pain while making a presentation in OpenOffice Impress. The first two slides took me 10 google searches and now something ungooglable occured.
I need to indent list items ...
0
votes
0answers
19 views
How to apply AutoFilter on multiple sheets in OpenOffice / OpenOffice Calc?
I have a calc document with two sheets. When I apply the AutoFilter on sheet 1, then apply AutoFilter on sheet 2, the first AutoFilter on sheet 1 is gone again.
It seems that OpenOffice Calc can only ...
0
votes
2answers
180 views
Decrypt .docx file to view in OpenOffice.Org
I have been sent an encrypted .docx file as it contains confidential information, but I am on linux.
I have the password, but OpenOffice.Org doesn't seem to even recognize that it is an encrypted ...
1
vote
1answer
33 views
Where does open office writer save its default template
Does anybody know where Openoffice saves its configuration for standard font, size etc?
I know i can create a template which gets used as a standard for new documents, but how do i get the location ...
2
votes
2answers
70 views
OpenOffice Calc regex returns wrong value - what's wrong with my regex?
I have a column of text with values concatenated by my bank, as in a typical monthly statement.
Here is an example (column A240):
OCT 26 BALANCEPROTECTOR PREMIUM $10.05
I'm trying to set the ...
2
votes
1answer
42 views
Remove a word from OpenOffice.org standard dictionary
Our company has just named some new software using a regular English word. My fingers are determined to misspell this word. Unfortunately, the misspelled word is also a place name that is in the ...
0
votes
1answer
17 views
Duplicate an Open Office document in a new window
I am using Open Office 3.4.1.
Is there a way (via key combination or something) to duplicate the current document and open it in a new window?
Edit: I mean a more convenient way than pressing CTRL + ...
0
votes
3answers
38 views
Check for one value in column A exist in another column B in open office
suppose I have values like
A B C
abc cde
bcd abc
cde afg
mn mn
for column C I have used formula =IF(MATCH(A1;B2:B4;0);A1)
But its giving wrong ouput like below
A B C
abc cde #N/A
bcd ...
0
votes
2answers
47 views
OpenOffice - Regex for reformatting line with word + numbers
I have a document with sections headed "Chapter 1"-"Chapter 45". I want to make them all caps and all in bold font by using a regex. I am stuck. I keep ending up with things like "CHAPTER "[0-9]" ...
2
votes
1answer
57 views
OpenOffice Mail Merger - 530 Authenthication Required
In OpenOffice Writer, I'm trying to to do a mail merge with OpenOffice Base. When I test the email settings, OpenOffice claims they work. However, when I try to do the actual mail merge, OpenOffice ...
0
votes
0answers
25 views
openoffice base report
I'm using open office Base to create a stand alone database for my service record. the problem is when i try to create a specific report, i cannot get the output that i want. lets says, I want to open ...
0
votes
1answer
51 views
How to prevent OpenOffice from running file recovery every time at startup?
Whenever I start my computer and start OpenOffice, the file recovery option is always displayed.
How do I turn this off?
0
votes
1answer
103 views
Excel/OOCalc: finding rows that have matching values in one field but different values in another
I have a large table (20-30 cols, 10-15K rows). What I need to do is to find the number of rows that match identically in one (or two) particular field(s), but not in another specific field (rest of ...
2
votes
1answer
42 views
How do I copy the results of a calculation without copying the formula behind it? Open Office Calc
How do I copy and paste only the results of a calculation without copying the formula behind it? I'm learning to use Open Office Calc. I remember other spreadsheets that had a values function, or ...
0
votes
0answers
19 views
Combined Open Source Office Suite?
Are there any programs that can combine Inkscape, Scribus, and OpenOffice.org? For example, in OOo, the startup screen has options to create a new document in any of the OOo programs. Is there anyway ...
0
votes
2answers
43 views
Create selected lines into table in Microsoft Word/Openoffice
I want to move the entire content of an MS Word file into a table.
The content consists of Objective Questions like:
Question 1
a. option1 b. option2 c. option3 d. option4
...
0
votes
3answers
77 views
Multiple “If” answers in one cell
I am trying to make a fishing tournament spreadsheet.... I would like to perform in once cell that if their position was first, they get 100 points. if their position is second, they get 90 points, ...
1
vote
2answers
160 views
Can MS Word read OpenOffice formats?
I am using Ubuntu 10.04.4 LTS, but am required to produce a document readable by MS Word. Can MS Word read .odt documents, or is OpenOffice capable of exporting into a .doc format so that it is ...
0
votes
0answers
16 views
Make OpenOffice use a certain dicionary file
I am working with Open Office at home, on my laptop and at work. I'd like all those Open Office instances to use the same dictionary file - which I have downloaded as en_GB.dic.
This file is on a ...
0
votes
1answer
31 views
How is the LOOKUP function named in German? [closed]
The english version of OpenOffice Calc does have the function LOOKUP.
How is this function named in German (Deutsch)?
2
votes
0answers
73 views
How can I open a .mdb with a password in OpenOffice?
I'm trying to open a .mdb with a password in OpenOffice Base. I can connect to the .mdb, but I cannot specify a password (forums say this method doesn't support passwords). Is there a way I can open ...
1
vote
1answer
58 views
How to fix document broken content?
I have been sent several files in order to fix them - the issue is that when they are opened you are not seeing the correct text and my cousin is not able to prepare for his exam.
So, I have found it ...
1
vote
1answer
110 views
Binary spreadsheets with bitwise operators [closed]
I am looking for a way to easily construct binary spreadsheets using bitwise operators such as SHIFT, AND, OR and XOR.
I've looked at Gnumeric but can't find any function that'd allow you to set the ...
0
votes
0answers
37 views
OpenOffice Calc Searching a table containing drawn lotto numbers
I have a table with drawn lotto numbers (1-49), prizes etc.
Date n1 n2 n3 n4 n5 n6 city prize Retailer
...
0
votes
2answers
34 views
OpenOffice.org Lowercases second capital letter
How can I turn of the feature in OpenOffice.org Calc which converts CCleaner to Ccleaner?
0
votes
0answers
34 views
Can OpenOffice intercept Microsoft Office OLE commands
I want to use open office but I have software that opens Microsoft Word via OLE for mail merge. Is it possible to redirect that to OpenOffice? Is there an OpenOffice extension that supports that?
2
votes
1answer
28 views
How can I tell where an OpenOffice Writer document extends beyond set margins?
I am using OpenOffice.org Writer to create a PDF, and have explicitly set margins of 1" all around. CreateSpace, which I am creating the PDF for, has rejected my PDF on the claim that it does not have ...
0
votes
0answers
49 views
Openoffice.org 3 MS Powerpoint Mac 2012 compatibility?
I made a presentation in Openoffice 3 and saved it in .ppt format. However, when I saved it on a USB drive and tried to open it on my mac, it said that the file needed to be repaired. When I hit ...
0
votes
1answer
55 views
Split sheet by rule (filter) in Open Office
I want to split a large sheet. I have different products and for each of them I would like a new file. Is it possible to split the sheet by some rule?
P.S. I am new in here, so if my question is ...
1
vote
2answers
124 views
running word count in OpenOffice writer
In OpenOffice Writer 3.4.1 is there a way to show the word count as you type without clicking anything? I'm new with OpenOffice and am use to word.
12
votes
3answers
183 views
Open Office makes my words bumpy
I'm using OpenOffice 3.4.1 on Windows 7, the Writer keeps giving me these weird bumps in my words. Sometimes, randomly, the words I type have little hills and/or valleys of about one pixel. I took a ...
0
votes
0answers
168 views
How to open .rtf files in OpenOffice Writer, not in Calc?
Case 1. When I open Open Office recent .rtf file via Quick launch or open recent .rtf file from Writer menu, this file is opened in Calc.
Case 2. But when I open .rtf file in Windows Explorer - it is ...
1
vote
0answers
62 views
Is there a way to view a slideshow with OpenOffice Impress with a video embedded beneath the slide content?
I have a video clip I want to add slideshow content in order to gussy it up before producing it, but when I add the clip to OpenOffice.org's Impress software, the video always plays on top of all the ...
0
votes
1answer
32 views
How to apply a page style to a specific set of pages?
I want to split my document in three parts.
The first part is the first document which has the style "First Page". The other ones have "Default". Now, I want the appendix to have the "Index" page ...
0
votes
0answers
74 views
Excel/OpenOffice spreadsheet template for expected and actual values
I would like to create a spreadsheet to generate graphs about cost items (anything with a cost, doesn't matter what) in order to have:
expected values: these would be created using some formulas ...
1
vote
1answer
44 views
excel / open office - append an incrementing value to all non-unique fields
I have a large table of about 7500 store names. I need to search through those names and, if they are not unique, append an incrementing value, for example:
store_1
store_2
etc.
Anyone know how to ...
0
votes
0answers
26 views
How do I resize two objects without changing their postions in OpenOffice Draw?
In OpenOffice Draw, if you have two circles, how do you make them both the same size? If you select one circle, you can go to Position and Size and set the size of the object. However, if you select ...
0
votes
0answers
23 views
OpenOffice fork that allows debug.print in VBA
Is there a version of OpenOffice/LibreOffice/Symphony, or an addin, that supports a version of VBA that allows 'debug.print' statements?
2
votes
1answer
64 views
Tagging or defining automatically in an Excel or Libre office spreadsheet?
I want to review and sort my expenditures in a spreadsheet where I have all my transactions listed. Is there a way to automatically label or tag to categorize the transactions like in a budget ...
0
votes
1answer
230 views
Set row delimiter in Excel
How can I use row delimiter other than \n?
CSV fields contain \n and the row delimiter is \n\n\n\n, to separate line breaks in fields from the row delimiter.
I'm using Excel 2010, and in need to ...
0
votes
0answers
54 views
Where is the OpenOffice AutoCorrect file?
I have a version of OpenOffice on one computer which I added words into my auto correct dictionary.
I have another version of OpenOffice on a different computer and I would like to find a way to use ...
-1
votes
1answer
163 views
How can I turn off auto-completion in word processing apps?
In both Word and Open Office, these word processors try to be clever and guess where you want to indent, or automatically complete a word you've started to type. In my experience, they are wrong a ...
