Ubuntu :: Converting PDF To ODS Format (OpenOffice Spreadsheet)
May 11, 2011
I know this is more of the Openoffice question but I felt I would find some solution here for this. At my work I am using lot of PDF files which are created using Openoffice Calc (Spreadsheet). I want to convert those PDFs to Calc file again for editing. Currently I am using a windows Machine with able2extract pdf converter for converting PDFs to .xls file. But it is not ideal solution for Linux and Openoffice users here.
I'm having some trouble with hyperlinks in openoffice 3.2 spreadsheet, though it may be a begginers problem.
I wrote a script to execute a certain task (in my case, to open an DNA alignment file with bioedit) and then, in openoffice, I assigned a hyperlink button to the path needed to execute the script, which is in my /home ("./script_file"). When I do this the first time, clicking the hyperlink button runs the script perfectly. However, whenever I close openoffice and re-open it afterwards, the hyperlink doesn't work anymore. I've checked and this happens because the original URL, which was "./script_file" changes to /home/user/etc... or /temp/etc... and, obviously the file isn't found. If I manually correct the URL, the hyperlink is functional again... how to fix the URL of an hyperlink so that I won't have to correct it every time I close and re-open the program?
Does anyone else find that Openoffice 3.2's spreadsheet app becomes unresponsive when copying and pasting multi-cell selections? I've had this problem ever since I started using Ubuntu 10.04, which comes with OO.O 3.2. The problem becomes noticeable whenever I make a selection more than about 8-10 columns across. Once the flashing border appears around the selected cells, the spreadsheet app becomes very sluggish. The mouse still moves normally, but it takes several seconds after a click until the highlight moves to another cell, or to un-select the cells, or copy them. These slowdowns happen both in old spreadsheets and in freshly created ones. They didn't happen with Openoffice 3.1 or earlier. Haven't tried it under Windows, so I'm not sure whether this is an issue specific to Linux OpenOffice 3.2. Other apps don't seem to be affected.
I have a spreadsheet I have been using for years not and as I go I hide some of the cells. Today I unhide those cells and they came up but very thin and hard to read. I have tried to highlight the "thin" cells and do some type of format but I can not seem to get them back to the normal size.
Everywhere I read, this seems to come up as a very difficult thing. Just want to record how I did it.
In Access, export the table to an Excel Spreadsheet. Using Openoffice, open the Spreadsheet, but save as an Openoffice (.ods) spreadsheet. ( Note - According to the Base help files, if you import an Excel Spreadsheet, it is read-only)
Open Base and Create a database. No tables, no nothing, just create. Now Open this and and also Open the spreadsheet. Select all the data in the spreadsheet, 'copy' it, and in the Database tables area, 'paste' it. I had problems in that it wanted to create a primary key, so added an extra field.
I then went into the database design view, right click on the appropriate field to make that the primary key, and remove the primary key from the unwanted field.
Delete the excess column. This is just for a single flat table, with no linking to other tables. I hope that this helps someone. I did it for a membership database table, and have been able to replicate the query to filter for the Snailmail folks (Those that did not have an email address in the table). Still trying to figure out how to do an envelopes report though.
I'm having some problem converting an mpg file to avi. I did it with mencoder. The result was an avi file as I wanted but the image was like stretched vertically. Like this: (The avi is on the left) What can I do to convert it without the stretching?
I am currently looking for an app that can enable me to convert ms word and/or openoffice docs into an ebook format compatible with Kindle (I have been using mobipocket creator on Windows to convert to .mobi but I am now trying to get rid of Windows completly), so far the only possibility I have found is Calibre and it wont allow me to cnvert Word docs into another format.
I am building my first rpm package and I cannot seem to find out how to change an existing .tgz to a .tar.gz as required by the rpm .spec file - I've attempted to search on this, but I can't find the exact command I'm looking for. Specifically, I hope to avoid having to untar the .tgz and simply convert it to the .tar.gz format.
I'm trying to convert a 3gp (mobile phone video) file to PAL DVD format (which is I believe MPEG2 video and one of a few audio choices, in an MPEG PS container). But while the file plays fine in mplayer and vlc, my efforts to convert it, using either VLC or devede, always seem to result in either the converted video being speed up (noticeably, we're talking twice as fast or so not 5%), or in the audio going mickey-mouse. How can I get the file converted correctly? Bearing in mind it needs to be PAL not NTSC (so a lot of stuff I might find online isn't going to work as-is)
I have a whole bunch of wma files I want to convert to a more liked format like wv flac or shn. Shntool does not seem to want to do that soundconverter and soundkonverter both refuse too. My wma format is wma1 or wmal cannot tell if it is 1 the number or l the letter L. 1. They play in xine straight off. Xine is in your synaptic 2. To convert quickly install dBpoweramp under wine again quick and no fuss.
I have 2 drives mirrored via windows software raid and I plan to toss the drives into an Ubuntu server soon where they will also be mirrored. The server will have another drive for booting. What is the best way to get these mirrored drives into ext format while preserving my data? I plan to use software raid in Ubuntu as well. My only idea is to format a 3rd drive as ext and copy all the files over, seems inefficient though.
I have been searching for a while for a program to convert .flac files I rip off of cd's with my laptop (running Fedora 11) to a usable iTunes format for my desktop (running Win XP). The cd drive on my desktop is currently broken, so my fix of ripping on my desktop, then using Rhythmbox on my laptop is temporarily unavailable. Any suggestions? I've tried audiokonverter, soundconverter, audio-convert-mod and each come up with errors or wouldn't install.
Can I ask for some advice in converting a video (from my phone) which is a 3gp file into something more universal. I use audokonverter for audio files and this gives me a menu right-click option to convert a song from (say) wav to mp3. Is there an equivalent for videos? I am using opensuse 11.4 64 bit and have mplayer, xine and vlc installed plus the necessary codecs. Or is it simpler to use ffmpeg in a c/l environment
I am in the process of learning some scripting, however I am running into a roadblock in specifying a certain time format in the array. Ideally I would like to use Here are the lines of text that I am interrogating:
How do I save a document I created in OpenOffice.org in .doc format? I want to use the same file in a windows OS. Whenever i select the "Windows XP" option then click save OpenOffice crashes. How do I fix this?
I noticed that files that were written in MS Word 2003 change when opened in Open Office 3.2.1 This usually involves tables, lists, and image placement, as well as page margins and boundaries. It sometimes makes it annoying when reading files saved in MS Word .doc format that other people send me. Does anyone know if there is an extension to fix this? Or settings that can be changed? Also, was this addressed in version 3.3.0 of OpenOffice? Has anyone tried it on LibreOffice? I don't want to install VirtualBox, Windows, and Office to read Word files properly. I dislike MS.
I use openoffice writer 2.3.9 and when I paste a picture on a document, I can't find any option to get the portrait format. With a right mouse click I get a all lot of options (especially under "picture") but nothing about the format.
I have a document with page numbers in the Table of Contents in Roman Numurals. I would like to change them to numbers 1, 2, 3. How would I do this? I'm not finding any help on the Internet and in Openoffice help. If I change the numbers manually, they will revert back when I update the Table of Contents.