I am looking for a small linux tool that would be able to extract text from odt file.
It just needs to be human-readable and it can have problems with complicated objects etc.
It's almost a duplicate of this question but I need it to be small and have no dependencies on OpenOffice or X server
I remember having a 1MB MS-DOS program that could…
I have looked at ways to convert word or open office text files to LaTex format, and those have been addressed on SU here and here.
These will work, but I'd rather have a native single-step solution. Does anyone know of any module or add-on for LaTex that will let one open .doc and/or .odt files without the use of third-party conversion tools?…
I have some cells which contain times entered in by users, which are written in the following format: mm:ss. There are never any hours. The seconds always have leading zeroes. The minutes may or may not have leading zeros.
Because I need to separate out the minutes and seconds for various operations, I need to be able to get at the numbers…
After completely reinstalling my laptop due to apparent registry corruption, I've encountered a problem with Open Office:
I open a simple Calc spreadsheet, it comes up normally, but then after anywhere from 5 seconds to several minutes (without even touching the Calc window) OO crashes, then comes up through recovery. If I let it…
I'm trying to build a database that I can use to track prices of groceries on certain dates. My problem is that I cannot figure out how to have a single entry associate with multiple data.
For example, carrots. The index would be carrots. Then, a few categorizing fields (ie, Produce|Vegetable) Then, I can enter a price, date…
I have a spreadsheet in Open Office 3.0 Calc.
The spreadsheets consist of the first sheet and an arbitrary number of additional sheets, each collecting data for a specific month. The Month sheets have an identical structure. The first sheet is supposed to provide an overview to the most important numbers in the month sheets.
…
I want to rearrange rows with the mouse in Calc.
In Excel, I select the whole row, then drag and drop it while holding SHIFT. This causes the drag and drop cursor to turn into a bar rather than cells, and the cells are inserted at the bar's position.
Is there a way to accomplish the same sort of thing in Calc without going…
I need to fill a form (which I received in .doc format and saved as .odt). The file is read-only except for the fields where I can enter the information. Unfortunately, with the fields filled it doesn't fit on one page, and I need to edit it so I can print and submit it.
With LibreOffice beta 3, I could edit anything…
Hi,
I've imported a document into Open Office and it has a number of hard returns in wrong places. In MS Word, I could use the search and replace to simply get rid of them all easily, but Open Office's earch won't find them. I tried /n with the 'use regular expressions' box checked, but it seems that only looks for…
I'm currently looking at upgrading our office machines from Office XP to Office 2010. For most users the standard edition is fine but just a few of us use Access. There are only a couple of standalone Access databases but the program is used fairly extensively (mostly by myself) as a front end to MySQL.
As the cost…
I have been given 10 old eMAC computers to donate to a local primary school. I am a PC person but I have volunteered to set these up with some kind of office suite. The specs are:
700MHz G4
640MB RAM (should be enough for anyone!)
OS-X 10.3
40GB hard disc with 30GB free space
I'd like a recommendataion for an…
hello dear community. Hello dear friends form all over the planet
first of all - this is a great great forum. I like this place to share the ideas. It is so great to see such a supportive place - featuring the knowledge exchange!
today i have the following thing to discuss:
i want to separate the following…
Hi
I found a couple of old spreadsheet documents that I created a couple of years ago that I would like to read again.
I think I used the old Star Office 5.2 to create those Spreadsheets.
They all have names like *.sdc
I have tried to use Open Office to open them, but he can't recognise what it is.
Does…
hello, i have some scientific data that i want to insert into oo.org calc. when i do this, instead of displaying 0.35678 in a cell it displays 0.35 (only the first 2 digits after the decimal). but on clicking the cell, the formula bar shows the correct value...please help
The formula failing is the following:
=IF(TIMEVALUE(C2 & ":00") > TIMEVALUE(B2 & ":00"); 0; C2-B2)
I previously tried
=IF(C2 > B2; 0; C2-B2)
but this also gives me "Error 502".
The cells it is referring to contains data in the format "12:30" (I formatted the columns with format "HH:MM").
…
I have an area chart in LibreOffice Calc where I would like the X axis to be measured in one month intervals spaced evenly apart.
The data going into the graph, however, is not regularly spaced at one month. There can be zero, one, or two entries in any given month.
Right now, the chart is keeping the…
How do I make a whole row follow wherever I am in the Calc document when I scroll down/up?
I'm looking for something that keeps a row from moving, or to make it stay put.
This is so that when I want to see other rows, this one locked row will stay in place and allow me to refer back to it on screen…
Hi,
I would like to draw diagrams using Open Office but I didn't find any installed by default. What I am exactly looking for are diagrams that look like the ones that come with MS Office 2007/2010 (like Pyramid diagrams, Star diagrams etc.).
Any idea? A plugin to install? Otherwise are there any…
We have a few really large HTML files (60-100 MB) that we cannot convert to PDF with any reliability.
Adobe Acrobat 9 crashes - hits the 2GB limit for applications.
Open Office converts, but removes some of the anchors ().
ActivePDF webgrabber crashes.
Is using a 64 bit situation an option…
i have a collection of word files with lots of formulas objects made in MathType.
i know there's a way to mass convert doc files to open office format, but it doesn't guarantee that formulas will be transfered smoothly.
i was wondering if someone already figured out how to do that
thanks in…
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 do this?
For another project, I was using this:
…
I have a an spreadsheet of a questionnaire I conducted. Each column represents a multiple choice question and the values are the answers selected by each participant. Therefore each column has repeated values. Example :
**What is your favourite…
I need to align a paragraph at bottom of last page of a section. I'm looking for a workaround of foot page because OO has repagination problems when I use foot notes.
Someone know how can I align a paragraph at the bottom of last page of a…