I have 2 versions of the same spreadsheet. Each spreadsheet is divided into many different workbooks.
I have googled this without success. I want to automatically find any lines in spreadsheet 1 which are not in spreadsheet 2 or vice versa.
I don't know if such a thing exists but I would like to do convertion a PDF file to a spreadsheet. Do You know of any application to do this ?
View 2 Replies View RelatedI have been trying to repeat the first two rows in a Calc document but I keep getting an error.
Here are the instructions that I used.
Printing Rows or Columns on Every Page If you have a sheet that is so large that it will be printed multiple pages, you can set up rows or columns to repeat on each printed page. As an example, If you want to print the top two rows of the sheet as well as the first column (A)on all pages, do the following:
1.Choose Format - Print Ranges - Edit. The Edit Print Ranges dialog appears.
2.Click the icon at the far right of the Rows to repeat area. The dialog shrinks so that you can see more of the sheet.
3.Select the first two rows and, for this example, click cell A1 and drag to A2.
In the shrunk dialog you will see $1:$2. Rows 1 and 2 are now rows to repeat.
4.Click the icon at the far right of the Rows to repeat area. The dialog is restored again.
5.If you also want column A as a column to repeat, click the icon at the far right of the Columns to repeat area.
6.Click column A (not in the column header).
7.Click the icon again at the far right of the Columns to repeat area.
Rows to repeat are rows from the sheet. You can define headers and footers to be printed on each print page independently of this in Format - Page.
And here is the error.
"invalid sheet reference"
Is it possible to filter data using color in Open Office Calc?? It's very easy to use this function in MS Excel.
View 1 Replies View RelatedI had 2 unsaved Open office docs crash. It said something about saving them for recovery. But they havent reappeard. Is there some where i can look for them?
View 1 Replies View RelatedOkay so I have a file that I always save and close properly and get in my Ubuntu One folder for backup that will not open. Its called "Income.ods" and is quite important and I cannot seem to recover it. When I double click it, it shows the Libre Office Calc splash screen shows up then goes away and the nothing, no error messages, no nothing. I tried to open it on my Windows Vista machine and it said it was corrupted and could not open in Office Word. I tried a few recovery tools but to no avail.
View 9 Replies View RelatedI highlight a column by selecting "D" > format cells > background > I select a color and press OK. But the color on the document remains the same.
View 3 Replies View RelatedI have a Calc spreadsheet that has 3 sheets. The first page is set for Portrait and the remaining pages are Landscape. Currently I am printing each page as a separate print job.I would like to print the entire Calc pages as one job where the printer prints the first page as portrait and the remaining pages as landscape without user intervention.
I do not see any command in the print dialog or in open office dialogs that tell the printer to change orientation. It seems that OpenOffice fails to tell the printer the page orientation. Is there any way to accomplish this. If a macro is required how do you write it and how is it executed?
KWord won't save as .doc format on Slackware 13.0 so I got the SlackBuild for OpenOffice and changed my .odt resume to .doc. But now yahoo won't attach it, it says it has a virus. Wtf? (I don't really think it has a virus.)
View 5 Replies View RelatedIs it possible to delete Libre Office Writer and install open office again as Libre seems to be full of bugs and unusable? I have 11.3.
View 9 Replies View Relatedhow to open microsoft office file in ubuntu without installing microsoft office for sure
View 2 Replies View RelatedI just found out about Libre Office. I am currently using Open Office on my Netbook (ubuntu 10.10), and NeoOffice on my Macbook (OS/X 10.6.7).
QUESTION: I have some backups using these formats: .sdw, and .odt. Can Libre Office read documents saved in these (StarOffice / Open Office) formats?
FWIW: I would have preferred to use OO on both machines, but unfortunately OO never fixed a problem with printing envelopes in the Macintosh version. Hence my use of NeoOffice.
I have both installed, but since LO is going to be the way Ubuntu goes for office applications, can I easily have my system setup for native LO? Native being if I double clock on a .doc file it will start up LO's Write program instead of OO.Will just removing OO achieve this or is there an easier way? I looked for file associations and didn't find it.
View 9 Replies View RelatedThe first is regarding my home network that I've setup. It mainly consists of two laptops, both running fedora. I find myself using rsync, ssh, scp, and the like quite often, but it is very annoying constantly needing to provide a password. This sounds like a job for RSA keys, but is it safe to do so on my laptop I take whenever I travel? If my laptop were to be stolen, my personal and private keys would be available to the thief. Is it instead better to use something like kerberos (which I'm not very familiar with, ie. I've used it at work but never took the time to learn how it works).
This isn't much of an issue with my home network since it is protected behind my router. However, I have the same issue with rsync, and ssh to my work PC. These are the RSA keys I'm worried about if my laptop were to be stolen.
Sometime ago I realized my Open Office had changed, I don't remember having done anything in particular but today it isn't the regular open office but what I believe is a KDE version or idk. The theme changed and instead of regular menus I get "window" menus, in the sense that they get effects as regular windows. It's hard to explain it.
[URL]
I tried uninstalling it and installing open office and also in the soft center open office is more than once, but I tried the different versions and I still get the same problem.
I recently upgraded to 10.10 and installed ktorrent at the same time. After the upgrade whenever I try to open up and file or folder for that matter totem tries to open them. Totem is acting like the default app for all the files on my computer. I tried uninstalling an reinstalling both totem and ktorrent and I still have the same problem.
View 1 Replies View RelatedEverything was going fine until about an hour ago. I havnt changed any settings on the computer. I can't open any folders, they all give a "File not found" error. Also some pics in Firefox have inverted colors. I doubt they are related though. Im running 10.10 and have been for about 2 weeks. I am completely new to linux prior to downloading this.
View 6 Replies View RelatedThere are about 120 users on linux centos server,most of them access their mails with pine, users are unable to open attachments of PDF, docs or JPEG with view attachments with pine. Can anyone let me know what configurations will make this work. I tried ssh -x username@xyz... error is kdf not found.
View 1 Replies View RelatedWhen I open an open office document from an NFS share it always opens as readonly. This was a problem I had on Arch linux and the fix was to change the locking options in the soffice script but I've tried that fix here and it doesn't work. I've seen a lot of discussions but they all go back to changing the locking options in soffice, has anyone got any alternative fixes or one that definitely works with locking?
View 4 Replies View RelatedI don't know if I'm doing something wrong but I've been running Ubuntu or a variant for about a year now and suddenly every now and then one or two of my documents (open office or pdfs) have no information and they won't open.
View 6 Replies View RelatedI'm having sporadic issues with the openoffice.org program. Sometimes, power point presentations will crash the program and then I can't open any open office programs without rebooting the computer. The problem seems to be just with powerpoint files and I'm not sure what the issue could be.
View 7 Replies View RelatedI installed Open Office 4 on Debian 8 but when I run the program I get this error message.
root@localhost:/home/paul# openoffice4
No protocol specified
No protocol specified
/opt/openoffice4/program/soffice.bin X11 error: Can't open display:
Set DISPLAY environment variable, use -display option
or check permissions of your X-Server
(See "man X" resp. "man xhost" for details)
Open Office works fine when I run the command "startx" in the Konsole but so far I haven't been able to configure it.
I cant open xls files in a shared folder using open office 3.1. Its all started when i install a new open office version. when im using open office 3.0.8 i can open all the files but now i cant even open it. Its always display untitled documents.
View 14 Replies View RelatedI have a MS Access database I would love to able to use in OOo. How do I do it
View 2 Replies View RelatedI've been using this howto to set up automatic logins to virtual console using "a C login program" method. In slackware64-current updated till january it prompted me to enter a password before logging in, while now after installing latest updates and kde 4.3.5 from current it logs in automatically without any prompting.
View 3 Replies View RelatedIs there any way to open a "b.docs file" with Fedora 9? I should have written "b.docx file" JR
View 1 Replies View Relatedsome software replacements for open ofiice calc? i had fedora 13 lxde and i liked that one, but i don remember the name. maybe there are better ones than it too
View 3 Replies View RelatedI am not a programmer. But I feel safe enough to edit a file (afteracking it up of course.)I am using Arch with Enlightenment (E17.) I installed fwbuilder. Now when I click on the tutorial button it would not start my browser at all. The terminal gave this error;
Code:
/usr/bin/xdg-open: line 478: firefox: command not found
/usr/bin/xdg-open: line 478: mozilla: command not found
[code]....
I can't get open office to run. I believe I need jre1.60 to run this. I have jdk installed since I need this for java programming. Can I also install jre1.60 and use jdk as well? I am taking a class in Java programming so I don't want to screw up my programming environment. However, I need to use OO powerpoint for class as well.
View 3 Replies View RelatedI have been on the open office site, and tried several different downloads for Open Office 3.2. However, once I unpack the gzipped file, I get several deb packages from within the archive. Could someone kindly point me to a link where I can d/l a single deb package so I may easily install / (upgrade to)version 3.2? FWIW, I am using Karmic with the latest updates and OO ver. 3.1.1 on my netbook.
View 4 Replies View Related
