Ubuntu :: Lock A Open Office Spread Sheet Cell?
Aug 12, 2011How can I lock a open office spread sheet cell, that is not a sheet or document, only a cell ?
View 4 RepliesHow can I lock a open office spread sheet cell, that is not a sheet or document, only a cell ?
View 4 RepliesIs there an application that will take the data from an Open Office spread sheet and locate and mark each address on a map?I've got a long list that I need to sort and locate by zip codes.
View 9 Replies View RelatedI'm looking for a means to automate filling out web-forms with data (names, addresses, etc...) from excel spreadsheets. I'm not sure how to do it with a macro, of if theres programs out there, or if a script could do the same work.
View 3 Replies View RelatedI have written my own matlab script to output a cell array to csv format, but I am having problems when I try to view the file in openoffice. In my script, if the length of the string in the cell is longer than 30 characters long I put a linefeed into the fprintf. This all works great and the linefeed works in Open Office, however the width of the columns are still set to the width of the entire length of the string. For example, in my cell I will have several lines 30 chars long, say four lines or 120 chars, and the width of the cell that it is contained in matches the width of about 120 chars long rather than 30. This is a problem because it shows the text all left aligned in the cell, which looks great, but there are pages of white space to the right and the next column is off the screen. This seems obviously inconvenient.If the string is longer than 30 chars I output it in the following way:
" First 30 characters of the string the rest of the string and so on"
I feel like there should be a simple solution to this but I can't find it. Is this a problem with Open Office or my understanding of csv? Would excel have the same problem? How can I fix this?
in openoffice i could open my excel spreadsheets. now that i have GNOME and Abiword, they won't open. any suggestions? can't find OOffice in the repository.
View 3 Replies View Relatedis there a way to lock an individual cell in libreoffice? I can lock/protect a whole document or sheet, but can for the life of work out how to lock an individual sheet.
View 4 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 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 RelatedWhen i connect windows server 2003 from ubuntu these error displayed .When i installing the tsclient, by executing these following command from a Terminal window:
sudo apt-get install tsclient
When i run these command the following error displayed.
E: Could not get lock /var/lib/dpkg/lock - open (11 Resource temporarily unavailable)
E: Unable to lock the administration directory (/var/lib/dpkg/), is another process using it?
my problem is the terminal:
E: Could not open lock file /var/lib/dpkg/lock - open (13: Permission denied)
E: Unable to lock the administration directory (/var/lib/dpkg/) , are you root?
I have pidgin2.5.2. I want to install pidgin2.6.6.How can I do that?E: Could not get lock /var/lib/dpkg/lock - open (11 Resource temporarily unavailable)E: Unable to lock the administration directory (/var/lib/dpkg/), is another process using it?
View 1 Replies View RelatedI am not able to open excel file which is generated from java web application in Linux. The file is opening in Windows but not in Linux. I am not using Open Office. I have two different applications deployed in two different was7 servers in same Linux machine. Both the applications generate excel output stream which I open in IE. When I am trying the same application in Windows environment both are working fine, but in Linux I can open and download xls files in one application but not in other. I am using application/vnd-ms... as mime type and POI jars to generated excel, no errors in my debug log or system errors.
View 2 Replies View RelatedSometime 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.
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.
View 3 Replies View RelatedI am looking for some advice on how best to lock down our office network to keep our employee's from wasting time on sites like facebook and ...... This will be my first time setting up a server as a gateway in a production environment so I thought I should get some suggestions on what the best packages would be to do this.
I essentially need to lock down our network so that i can monitor what everyone is doing on the Internet and block it if needed. it doesn't have to be web based or have a bunch of gui's, im fine with command line, configs and log files, but it would be nice.
I'm interested in commercial products as well as long as they are linux based.
Fedora 13, 64 bit. I have 9 cell Dell Studio 1555. However, it shows a battery time equivalent to 6 cell one. Works fine with Windows 7. Recebtly upgraded the BIOS as well.. No effect.
View 5 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 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 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 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 RelatedI installed open office 3.2, but when I start it get this error Quote: /opt/openoffice.org3/program/soffice.bin: /opt/openoffice.org3/program/libuno_sal.so.3: version `UDK_3.10' not found (required by /opt/openoffice.org3/program/../basis-link/program/libsfxlx.so)
/opt/openoffice.org3/program/soffice.bin: /opt/openoffice.org3/program/../basis-link/program/../ure-link/lib/libxml2.so.2: no version information available (required by /opt/openoffice.org3/program/libjvmfwk.so.3)
If Open Office had any problems saving in different file formats than the open format (which I know it doesn't have problems with) and rtf (which I know it does). I have to use it for school and I do not want to lose things like bullets, numbering and especially not information when saving in Microsoft Word formats.
View 7 Replies View Relatedhow can I remove Open Office 3.2? I can't find it in the Software Center or anything, and I don't want to accidentally do something wrong. I'm using Ubuntu 9.10 and I have AbiWord installed, and to be truthful that's all I really need.
View 2 Replies View RelatedI'm trying to use Open Office presentation, and it makes me angry and a little disappointed because it feels like it is everything else than user friendly...Like 50% of all the options are grayed out and it is really irritating!It started when i tried to view the presentation, and advance to the next image by pressing the mouse button like in power point, and it is so bad layout i don't understand how, and it makes it even worse when i can't click 50% of eventual solutions.
View 2 Replies View RelatedHave installed msttcorefonts but they're not showing up in Open Office 3.2. I've tried restarting the machine and even a fresh install of Open Office to no avail. Can't recall doing anything special to make them available in Open Office in past; has something changed or am I missing something obvious?
OK, solved it; for anyone else having trouble, I completely removed ttf-mscorefonts-installer package then reinstalled it; upon reinstallation I got a EULA to accept and everything went as expected.