Ubuntu :: Niggly With Display Of Excel Files Using OpenOffice?
Nov 17, 2010
My nephew dropped in today hoping I could print off some large Excel files. When I opened them in Office Spreadsheet I could see that each cell had a series of dots in it, similar to full stops (periods). These dots even occurred in cells that already contained text or numbers. Evenly spaced horizontally and vertically as if marking the corners of squares and regardless of the row height or column width. This wouldn't look good on a print out and being as he wanted them for a new job we booted up a Windows machine and took the printout from there. It turned out the page was intended to print to an A3 sheet whilst my available printers are all A4.
Later I reloaded these files into OpenOffice (3.2.0) because I was niggled about OpenOffice perhaps not achieving a decent performance against Excel, and printed off a couple of pages. The printout showed no sign of the dots, which is fine, but what about these dots that show up on the Spreadsheet page.
A bit more on this is that they show up in Preview in Web browser but not in Page preview. Any corrections on this admittedly trivial problem or do we just live with it?
View 1 Replies
ADVERTISEMENT
Oct 18, 2010
I prepare an MS Excel 2007 spreadsheet which includes macros and user defined functions on a Windows machine. I transfer that file to a Mandriva 2010 machine and I load the file with OpenOffice Calc 3.2.0 and it runs the macros properly. I transfer the file to a Fedora 13 machine and I load the file with OpenOffice Calc 3.2.0 but it doesn't run the macros. I set "Tools/Options/Security - Macro Security" to Low in both cases.I am very new to OpenOffice - is there any other setting of which I am not aware?
View 4 Replies
View Related
Dec 9, 2010
Can't use Excel files with Open Office. When trying to edit and fill out a RMA form using Excel file I keep getting a message saying: 'Protected cells can not be modified'.
Here's a screenshot. What do you have to do to get it to work with Ubuntu? Excel works fine with Windows but I can't use Excel on Ubuntu with Open Office. This is the first time ever using Excel with Ubuntu and Open Office.
View 2 Replies
View Related
May 22, 2010
I cannot open .xls of .ods documents. Something I have altered recently may have done this. If I right click open with options I cannot find Open office. pdf files are opening with Okular as default. Previously Excel files opened with Open Office as default.Open office appears to be installed. how I can get these files to open and set it as default again.
System: openSUSE 11.2 (i586)
KDE: 4.3.5 (KDE 4.3.5) "release 0"
View 3 Replies
View Related
Mar 2, 2010
Are there any solutions by which linux-based web server frameworks (like zend or any other) can process data inside microsoft excel spreadsheets (*.xls)?
View 1 Replies
View Related
Jun 11, 2009
We started upgrading our office package to office 2007. No problems right off the bat, but all of a sudden there are excel files stored on our linux file server that people store and share. Some of them you can open and some of them you can not open and it doesn't give a reason you can't open them it just says can't open file anyfile.xls..I attached a word doc with pic of error in excel.
View 6 Replies
View Related
Mar 22, 2010
I have xubuntu 9.10 installed I need to access MS word/Excell files stored on a disk-on-key. My system does not seem to notice the D-O-K. I guess i need to mount the DOK and specify the MS filesystem (FAT,VFAT etc) What commands should i use. What is the necessary code in /etc/fstab so that it is mounted on boot
View 5 Replies
View Related
Jun 24, 2010
Imported an Excel file into OO.o Calc. EVerything is fine except the comments are all blank. It knows that comments should be there, but they're all empty. how to recover the contents?
View 2 Replies
View Related
Oct 31, 2010
i have upgraded from 10.04 and now Impress wont display most videos when in SLIDE SHOW mode (most important). These videos do play however when viewed in editing mode. impress is thus unusable if you have videos. i tinkered with it all i could, i even reinstalled 10.10 from usb stick no progress.
View 1 Replies
View Related
Mar 31, 2011
I have set up an OpenOffice (3.2) Base database - tables, mainly, and a few queries. The main table contains about 9000 rows and around 50 fields and there is a second table of 1900 rows and 20 fields and a few other tables with either fewer rows or many fewer fields. The primary key on the main table is a single text field. The .odb file is 4.4Mb. There are no Forms or Reports; the idea at the moment is that I enter data using OO's Table data view. I see that I have an embedded HSQL database and I cannot change dit>Database>Properties because it is greyed out.
Opening the database is reasonably quick (about 5 sec) but then when I want to look at any but the smallest of tables (in data Table view) it is very slow (15 sec on the main table) to display the first group of rows. When I want to move to show a different record it takes just as long to display the new set of rows. It makes no difference whether the new set of records is adjacent (in terms of record order) or a long way off. I need to speed this up x3 or more or I will have to abandon Base as impractical to use.
On the OO Forum some posts talk of separating the database from the engine and others of increasing the cache size. I can't do the latter as access is via the greyed out option and I can't find any instructions for the former. I'm not convinced these would have much effect anyway.
View 5 Replies
View Related
Jun 10, 2011
I always enjoyed the feature in Microsoft Word when in "Print Layout" where I could make the end of one page touch the beginning of the next page so the pages could be viewed seamlessly. There appears to be no way to do this in Writer Anybody know if this is possible in Writer?
As a work around I use WEb Layout to view documents. But everytime I reopen OpenOffice it defaults to Print Layout. Anybody know how to make it default to Web Layout when it is opened?
View 4 Replies
View Related
Jan 20, 2011
I'm trying to open a Windows '.docx' file on Open Office 3.2 and it just crashes.
View 4 Replies
View Related
Mar 17, 2009
I need to know if I can easily transfer powerpoint files from an old microsoft computer to my now linux computer and run them w/o difficulty in OpenOffice Presentation I looked on google but couldn't find a definite answer. The same question for all my microsoft office files and converting and running them in my linux OpenOffice programs.
View 9 Replies
View Related
Oct 11, 2010
Using connect to server in 10.04, service type SSH (sftp) from the places menu. This shows my folder and I can double-click pdfs, text files etc from Nautilus. But.... if I try to open an ods or odt file it opens the archive manager. It also fails if I open from within OOo. It used to work but has recently stopped.As an aside, if I export the share via NFS and access it that way, then everything works OK.
View 2 Replies
View Related
Apr 12, 2011
I have to use and update many documents on a network share in my organization. I am using OpenOffice 3.2 (latest and Greatest). When I go to the document that I need via the network share, I can open up the document no problem at all but the minute I attempt to save it, it will freeze and I have to:
PHP Code:
pgrep soffice| xargs -i kill -9 {}
Kill it. To get it to work I have to save the document from a .docx format to a .doc format then all works well. Unfortunately, all of my coworkers use the latest and greatest of MS Office.
View 5 Replies
View Related
Apr 2, 2011
i want to change the default format of open office files permanently. Like if i save a file it saves as .odt i want to change it to .doc
View 4 Replies
View Related
Jun 3, 2011
I am having problems opening and printing word 97/2000 formatted documents that were saved using OpenOffice in Maverick. If I try to open one of these files in openOffice for Lucid, it causes OpenOffice to freeze every time. If I save the files in OpenOffice format and share them between Maverick and Lucid - everything works fine. Anyone know what might be causing OpenOffice in Lucid to freeze when loading word 97/2000 files?
View 5 Replies
View Related
Feb 5, 2010
Have openoffice 3.1.1 and samba shares set up between my Opensuse 11.2 desktop and wife and daughters widows7 notebooks. Can access everything perfectly over the shares except anything in Openoffice.
When I try to open a file located on one of the two notebooks Openoffice gives the message "you can only select local files"
I found an old solution from 2005 on this in google suggesting that you had to mount manually the remote drive.
That seems extremely clunky and cumbersome.
There must be a way to enable Openoffice to open remote files. I can't believe in 2009 Openoffice is not able to do this without jumping through hoops.
View 7 Replies
View Related
Dec 27, 2010
It would appear that novell openoffice 3.2.1.4 on opensuse 11.3 fails to correctly import pps/ppt files. Slide transition data is lost and this results in presentations without sound. This problem does not exist in openoffice from openoffice.org. openoffice from openoffice.org will play pps files with sound which will not play with openoffice from Novell. However the openoffice.org version requires JMF.
JMF is old and 32 bit. I have tested openoffice 3.2.1 from openoffice.org with JMF on a 32 bit 11.2 system and it works. I assume that JMF will not work with a 64 bit JRE. I also assume that it would be difficult to get a 32 bit jre to work with a 64 bit openoffice FMJ is an alternative to JMF. It plays various types of audio including mp3 and wav. It is packaged for installation on 11.3. Does anybody know if this works in place of JMF with openoffice from openoffice.org on a 64 bit system?
View 9 Replies
View Related
Apr 15, 2010
I just started wonder how to make insert video files option in openoffice documents like text docs or presentations work. Any hints on that subject?
View 5 Replies
View Related
Mar 28, 2010
From MS-Word, there are certain graphics that one can create that feature linked boxes of text (I think they're referred to as smart graphics, or something). There's another MS program called visio that also creates these type of graphics. When I tried to open a docx file that had one of these graphics in it with openoffice.org (I'm using version 3.1 from debian backports on my lenny system), it was unable to read it. Is there a plugin or filter that I can add to openoffice.org to give it this functionality? If not, is there another program that reads these files?
View 2 Replies
View Related
Dec 14, 2009
I'm trying to install a language-pack for my OpenOffice, but there seems to be a dependency-problem. Maybe someone has a suggestion. FC12, x64 OOo.x64 3.1.1
Code:
[root@sarah yum.repos.d]# yum install openoffice.org-langpack-de
Loaded plugins: fastestmirror, presto, refresh-packagekit, remove-with-leaves
Loading mirror speeds from cached hostfile
* fedora: ftp.astral.ro
* livna: rpm.livna.org
[Code]...
View 6 Replies
View Related
Jun 5, 2010
I have an nfs share that mounts automatically when kde starts.
Code:
wendy@DellNB:~$ cat .kde/Autostart/mountNAS.sh
#!/bin/bash
mount ~/TestShare
#echo "NAS Mounted"
[code]...
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.
View 2 Replies
View Related
Jun 16, 2011
I have a dual boot system with Windows 7 and Ubuntu installed on my machine. I use Ubuntu much more often than Windows 7. On Ubuntu I can use LibreOffice Calc, but I'm more used to Microsoft Excel and would like to be able to run it under Ubuntu.
View 4 Replies
View Related
Jan 15, 2010
I'm currently running Office Home and Student version on Ubuntu 9.04. I installed Wine 1.1.36 along with Winetricks, apparently office appears to be working well. However I do have one issue.
I'm trying to run an add-in on Microsoft office excel for a statistics class that I'm currently enrolled in,
I follow the instructions to select the appropriate add-in which is (Analysis Tool Pack) but keep getting an error message, please see below.
Microsoft office excel can't run this add-in. Microsoft office excel cannot install the necessary files due to windows installer error2. File not found.
Next message:
Microsoft office excel cannot access the file 'analys32.xll'.
View 2 Replies
View Related
Jul 2, 2010
What Linux software can repair a corrupted excel file? I can't find anything useful in google or searching with synaptic.
View 5 Replies
View Related
Jan 6, 2010
how do I make ubuntu display txt files directly? (instead of asking me: run in terminal, display, run etc).
View 8 Replies
View Related
Mar 29, 2010
since upgrade from 9.04 to 9.10, I cannot load a website link which should load openoffice and then an excel or spreadsheet document.
It recognises that its an "excel" document because it load openoffice spreadsheet, but it loads a blank document without any data in it.
It worked properly in version 9.04?
View 3 Replies
View Related
Apr 13, 2010
In shell, I execute "./ffmpeg -f h264 - | xxx"
Now I hope use execl function to execute above operations,
I call execl("/bin/sh", "sh", "-c", "./ffmpeg -f h264 - | xxx");
but ffmpeg doesn't work, it seems that "|" pipe don't work.
how could I solve this?
View 1 Replies
View Related
Feb 24, 2011
how to generate excel charts from C, or if it's possible at all? For example, if I had 2 arrays that I wanted to export to excel and graph against each other. I know how to export it to a csv file, that's no problem, but I have no idea where to start with generating a graph of the data. I can't seem to find any examples anywhere. Just a simple example to show you what I mean: Code:
char arr1[] = {'a','b','c'};
int arr2[] = {10,20,30};
int main ()
[code]....
View 5 Replies
View Related
