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

learn more… | top users | synonyms (1)

0
votes
2answers
59 views

Can I have multiple views of spreadsheet data which extract and sort from a larger set?

Supposing I have a spreadsheet (Libreoffice ideally but Excel is ok) which has data like this ______| Age | Height | Shoe Size | etc... Adam | 14 | 180 | 11 | ... Beth | 21 | 205 | ...
0
votes
0answers
53 views

Make Open Office Table of Contents Link to Page, not Heading

I have a Table of Contents in my (Apache) Open Office document. It works fine, except that the hyperlinks go to the headings used to generate the Table of Contents, not the top of the page they reside ...
2
votes
1answer
34 views

Clear cell changed metadata in OOO Calc

I am trying to figure out how to clear the red highlighting around cells in Calc (OpenOffice 4). Here is an example: It is not affecting my work but I would like to clear them as they are ...
0
votes
1answer
1k views

OpenOffice Calc - calculating percentage for every cell in a column

I have a somewhat common task of calculating percentage of column. For example I have a column with 20 numbers on each row. I add 21st row with formula for the sum of all those 20 rows and then I need ...
0
votes
2answers
902 views

How to change the default font in LibreOffice 4

How do I change the default font in LibreOffice / OpenOffice. So that when I open a new spreadsheet document it doesn't revert to use the standard default font (Liberation Sans/Serif) How to set the ...
3
votes
0answers
791 views

microsoft visual c++ 2008 redistributable package x64, error 1935

I am working on Alienware 17, OS Windows 10 preview. When I try to install Open office it in turn tries to Install Microsoft visual c++ 2008 redistributable package x64 which then gives me following ...
1
vote
1answer
737 views

Openoffice / Excel combine multiple worksheets into one

I have not yet found the exact answer to my specific problem, so let's give it a shot : The Layout : 1 SharePoint Farm on which a report was run, returning 6 Excel Files with each containing 250 ...
1
vote
2answers
408 views

.odt vs .fodt: which is most space effective for git repositories?

Which is most space effective for git repositories: LibreOffice/OpenOffice .odt files or .fodt files? I think that it should be .fodt, since with the uncompressed XML format .fodt the repository ...
1
vote
1answer
700 views

How to convert html to doc/docx with OpenOffice or LibreOffice?

I am trying to convert a html to doc or docx. I used some of the available php classes but the results are not good. I wonder if I can convert a html file to doc using some office software like ...
0
votes
1answer
104 views

OO Calc: Detecting Blank Cells and Replacing with Cell above?

So annoyed I can't find a simple answer to this simple question! I'm using OpenOffice Calc. I want a formula which will detect if the cell is blank, and if it is to replace it with the contents in ...
4
votes
1answer
63 views

Removing functions from a column, but keeping data (convert to normal text)?

I have a column that contains the results of a few different formulas. I want to convert all of these cells to normal text, getting rid of the formulas. I know I'm missing something obvious here.
1
vote
0answers
36 views

OpenOffice doesn't copy charts properly

I'm using OpenOffice 4.0.0 and I have charts in them. Whenever I try to copy and paste them into another program it just copies and pastes a white rectangle (of the same size as the chart). I've tried ...
0
votes
2answers
83 views

OOO: Increment sheets for fill down

I have a row of cells on "sheet1" referencing a set of cells on a different sheet. I want to fill down identical sets of cells while incrementing only the sheet. Another way to describe the problem: ...
0
votes
1answer
503 views

Is there a way to have groupings of bars in a bar chart in?

I know this may be bad style, but I want a bar chart that groups certain bars together. For example if I was comparing the speed of two models of cars, and considering the speed under wet and dry ...
0
votes
1answer
87 views

Stop OpenOffice Writer from adding trailing cents after dollar sign

Whenever I precede a number with a dollar sign in a table in OpenOffice.org Writer, the autocorrect forces .00 on the end of the number. How do I turn this auto-correct off?
-1
votes
1answer
46 views

Excel: Shortcut key to move selection to specific row

I am creating a bot where I need to move the selection (cursor) to a specific row, like row 1, or row 5. Does such shortcut feature exist or is it possible to create it? Alternatively, does ...
1
vote
1answer
50 views

spreadsheet: sorting by the first n characters of the entries of a column then by another column

Is there any way to sort an OpenOffice Calc spreadsheet by the first n characters of a given column then by another criterion? For example suppose that we have the following 4*2 spreadsheet (Note ...
1
vote
2answers
158 views

How to accept LibreOffice Calc autocomplete suggestion without leaving the cell edit mode?

Whenever I start typing a sentence in a LibreOfice Calc cell it suggests autocomplete options based on other cells contents. I usually would like to accept it and make a slight modification but when I ...
0
votes
1answer
49 views

openoffice transfromed decimal separator for an xlsx file in server machine

i try to configure openoffice in linux server to use comma as decimal separator,i search and i found that have a relation with regional parametre so i configure etc/locales.conf to use french as ...
0
votes
1answer
103 views

In OpenOffice Writer, how to populate a column of a table with a sequential increase in dates?

I am using OpenOffice Writer. In it I have a table for a time sheet. The first column is for the dates which begin from eg. 01/01/2014 and should end in eg. 20/07/2014. These dates are not already ...
1
vote
2answers
833 views

Filter OpenOffice Calc rows by matching if a cell in one column exists in another column with a certain value

Have a question I cant seem to figure out using the filter. Column A has 1400 rows with 800 additional rows that are duplicates (so 2200 total rows). Column B has inventory amount for only the last ...
0
votes
2answers
673 views

Massive Blank Space To Right Of All Word Pages?

So my grandfather has been working on writing a book. All goes well until he rings me to state that he has somehow messed up the file. If you look at the image below, he has someone added something ...
0
votes
2answers
255 views

IF formula where the test is a logical value in OpenOffice

How can I do =IF(E2,-1,1) * D2 in OpenOffice, where D2 is Currency and E2 is TRUE/FALSE?
0
votes
0answers
124 views

How can view but not print a text from an OpenOffice pdf exported file

I have this pdf file completely generated from Mac 10.9.3 + OpenOffice 4.0.1 OpenOffice Draw -> File -> Export as PDF... -> File1.pdf The original File1.odg file was created with ...
1
vote
0answers
48 views

Merge duplicate text from two columns and put unique text in another column

I've got two columns of about 13,000 email addresses. One has members and the other has newsletter subscribers. There are duplicates between the two(ie. a member who also subscribes to the ...
-4
votes
2answers
4k views

How do I convert a .csv file to a database?

I have an 8GB .csv file with 6 columns and 202,176,000 rows. How would I convert that to an OpenOffice database(.db) file?
1
vote
1answer
83 views

How can I create a PDF with a different full-page background image for each page, perhaps using Word 2011 or OpenOffice Writer 4?

I've searched and seen how I can create a watermarked Word document with a background image that applies to the whole document. What I have not yet found, for Mac Word, 2011 OpenOffice 4.x, or other ...
2
votes
1answer
411 views

Multimedia keys don't work in Foobar2000 when LibreOffice is in focus (Winamp is not affected)

Multimedia keys are ignored while focus is on Calc from LibreOffice. Media keys work in foobar when it's focused, also while other programs are focused. I use Windows 7 Home Premium SP 1. My Foobar ...
0
votes
1answer
119 views

Which version of OpenOffice does TAILS have?

I can't find this information anywhere. TAILS is based on DEBIAN which at some point switched from OpenOffice to LibreOffice. How do I know before I download 0.23 or 1.0rc1 on my slow connection ...
1
vote
1answer
590 views

Open/Libre Office Writer: Display line numbers in frames only

I'm writing a report in which I have to explain some programming code. I'm putting bits of code into a frame so I can place it nicely around the text. I would like to number the lines in the frame. As ...
0
votes
0answers
36 views

How to create a reference line between a name and a value in LibreOffice

In the figure (which is a part of the table of contents of some book) the doted lines help our eyes to easily spot the page number of the mentioned chapter. When creating similar contents using ...
1
vote
2answers
122 views

Book like page numbering in LibreOffice

How can I achieve the following goals using LibreOffice Writer? The first few pages should be numbered in Roman numbers (like i, ii, iii, iv, ...), but the very first page number should be hidden, ...
0
votes
1answer
115 views

Automatic backups (history) in LibreOffice (OpenOffice)

LibreOffice can create a backup copy when you enable it in settings (Options > Load/Save > General), but it saves only the previous state (one only). It has also an versioning feature (File -> ...
2
votes
0answers
184 views

Convert rtf to pdf removing the hidden text of rtf file

I am using Ted on CentOS 6, for conversion of RTF to PDF documents via shell_exec command from php script like: shell_exec(rtf2pdf.sh test.rtf test.pdf) But the issue is that if the RTF file has any ...
1
vote
1answer
39 views

OpenOffice Secure? [closed]

As I know OpenOffice was mantained by Oracle earlier. I want to use it now but I am concerned if it is possible that some developer/programmer can smuggle malware into the programm code? OO was ...
2
votes
1answer
3k views

LibreOffice 4.2.1.1: do not display list of recent documents

Today I installed LibreOffice 4.2.1.1. When opening LO, it displays a list of recent documents with screenshots, similar to Firefox and Chrome. I don't want this. How can I disable this setting?
-1
votes
1answer
529 views

Change background fill of cells in LibreOffice worksheet containing specific text

How can I change the background fill of all the cells of a LibreOffice spreadsheet worksheet that contain a specified text? In Excel that could be done by configuring the settings in the find and ...
5
votes
1answer
255 views

Default font and cell padding when opening files in LibreOffice/OpenOffice Calc

I've seen solutions for setting a default font when creating new files. What about a default font (and cellpadding) when opening an existing CSV file? LibreOffice seems to always default to Liberation ...
2
votes
0answers
188 views

Disable prompt when opening a CSV file in LibreOffice/OpenOffice Calc

Every time I open a CSV file, LibreOffice presents me with a prompt asking to confirm Character Set, Language, and Separator options (tab, comma, semicolon etc). This prompt is not present in ...
3
votes
1answer
87 views

How do I check if the document formatting is right?

I have to submit a paper to a competition. They have strict rules on the formatting that is to be used. For example, the size of the font, the margin, the space between the paragraph and so on. I ...
0
votes
0answers
64 views

Inserting a web page in an OpenOffice Writer document and keeping (some) style

I'm writing a report for school and I would like to include a html document as an appendix. So far all my attempts have resulted in a seriously malformed appearance. The results are hardly readable ...
4
votes
1answer
2k views

How to count the number of review comments from a specific author in Word?

I have a large MS Word document with a high number of review comments (track changes feature). I'd now like to get a list of authors and the number of review comments. The number of authors is not too ...
0
votes
1answer
74 views

I've created a “section” in Open Office Org, but how to I exit from it & continue with my regular page parameters?

Using Open Office Org on my Mac os x 10.5.8, I typed text into my page, using my regular document parameters/margins, then I inserted a "section" so that what I typed in next could be entered in 2 ...
0
votes
1answer
500 views

Libre Calc error on a float in decimal notation. Err. 519 (#value error)

There is a problem with my libreoffice. I doesn't calculate cells with decimal points, possibly seeing them as text. I have checked my locale settings (you can see them in the picture above) that ...
2
votes
2answers
61 views

How to autofilter for given strings in common spreadsheet softwares?

I know I can create an "autofilter" at the top of an XLS table.. But how can I create a filter that filters for given strings? example TABLE input: LASFD@FOO.COM LKXYCVER@FOO.COM ...
2
votes
0answers
46 views

Evenly-spaced table rows, where table encompasses entire available height

Consider a page which may have a header, footer, and a list of questions with a heading: Some Company Header These are your questions: 1. What is your name? 2. What is your quest? 3. ...
0
votes
2answers
1k views

How to hide paragraph marks in OpenOffice.org Writer?

How do I remove the blue P-marks that indicate paragraphs from my documents when working? I have looked under the 'Tools' menu but have been unsuccessful.
5
votes
1answer
505 views

How to show full document path in Open Office title bar?

How can I automatically show the FULL PATH of the currently loaded document (not just only the file name) in the title bar of Apache Open Office 4, e.g. OO-Writer?
5
votes
1answer
626 views

Is it possible to remove the hyperlink background in OO Calc?

Hyperlinks in OpenOffice Calc are displayed with a solid background which covers the background color of the cell. I don't want a solid background; I want the background color of the cell to show ...
3
votes
3answers
732 views

How to embed formulas in a line of text using OpenOffice Impress?

I want to create a presentation in Impress and need to embed a formula in text. I only found very old forum posts (over five years old), which said it is not possible. Has this changed by now? How ...