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'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 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 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 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.
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 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.
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.
I had a really important spreadsheet with my student's grades in it. I wanted to rename it so I right clicked and renamed (at least that's what I thought I did). After I looked again, the file somehow became a zip folder. I inside the zip folder are a bunch of files but I can't the spreadsheet anywhere! Here are some screens:
I have used the words 'Open Challenge'.I have attached a spreadsheet 'Sample file for filter.ods'.TASK: In a presentation, I would like to show what are the Topics of India on Day-1 , Day-2 , Day-3 , Day-4. That means I am going to Filter India and (Day-1, Day-2, Day-3, Day-4).
I'm trying to create a simple times table on OpenOffice.org Spreadsheet
I'm trying to use the "$" in the top tab (input line) i.e.
Quote: =A3*$B2$ Quote: =A3*$B3$
To make the question clearer. When I used to use Microsoft Excel in Windows I would do just as I said in the above and I would be able to construct simple multiplication tables to more bigger/harder to memorize kind of type. And that would be by dragging the rectangle from it's bottom-right corner
So my question is what's the alternative OpenOffice.org Spreadsheet symbol for the "$" symbol used in the formula bar in Microsoft Excel?
I'm in an Aussie rules fantasy football competition and someone posted a zip file with relevant stats for players in the under 18 comp, as a guide for selecting possible players in next years team. Never used any of the office applications. I've attached the zip file and this is what the poster said...
In the actual spreadsheet though, there are two sheets. The first is all the raw data which you can order by position (based on me watching the games, and the line-ups listed on the AFL websites), K: H ratio, state etc. The second is a sheet which you can use to compare players.
I find that sometimes it is easier for me to make decisions about which players to pick when the stats are more obvious, so if you are the same, you can use this sheet as well. Anyway, I hope you guys enjoy the spreadsheet and I'll update it after each round. Fixed, I had to change the file from .zip to .xlsx
Is there any way to make an OpenOffice spread sheet open to the last cell that was edited? I have a friend that has a very large spreadsheet, and would like to have it open to where he left off, rather than cell A1. He says excel does, or can be made to do this.
I have an nfs share that mounts automatically when kde starts.
wendy@DellNB:~$ cat .kde/Autostart/mountNAS.sh #!/bin/bash mount ~/TestShare #echo "NAS Mounted"
Gimp works fine editing and saving photos from/to the nfs share. kWrite can do its thing and read/create files on the NAS. Files I create with vim are visible and editable under windows. OpenOffice however, when I try an open a file I get "file is locked by unknown user." I open as copy and try saving to the share with a different name... No Dice, error saving to share the file is created on the share but it is empty. I did some reading and found a post that said to comment a line from a file called soffice, which I cannot find.
In OpenOffice how do you generate a PDF from the current sheet in a spreadsheet. This spreadsheet has 40 sheets. But I want to get a PDF of sheet8 only. When I "Export as PDF", I get a PDF file that contains all 40 sheets.
I created a spreadsheet which I had edited repeatedly. Today I ran out of disk space and needed to resize some partitions. After that proceedure I opened the spreadsheet and when I click on a cell to see the formula I get the message "document opened in read only mode". Other documents open fine.
ClamAV tells me that three of my OpenOffice.org Calc spreadsheets may be infected (status "MBL_144360.UNOFFICIAL", if that means anything). This seems not entirely implausible, since yesterday I used a USB stick to transfer files from a Windows system. Anyway, I'd really like to keep these spreadsheets. Can I disinfect them somehow?