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 RepliesI 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).
View 7 Replies View RelatedI 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.
View 1 Replies View RelatedHow can I lock a open office spread sheet cell, that is not a sheet or document, only a cell ?
View 4 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?
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 RelatedIs there a way to lockdown the panels in xfce so they can't be edited? There used to be a way using an xfce kiosk mode but the documentation for it is really outdated and the files it references don't exist anymore.
See http://wiki.xfce.org/howto/kiosk_mode for the outdated documentation
Last week I attempted to install some software on my computer (on ubuntu) and I edited a couple of files now I can't update ubuntu. I get 2 error messages:
1. Not all updates can be installed.
- I select partial update
2.Could not calculate the upgrade
An unresolvable problem occurred while calculating the upgrade:
E: Error, pkgProblemResolver::Resolve generated breaks, this may be caused by held packages.
This can be caused by:
* Upgrading to a pre-release version of Ubuntu
* Running the current pre-release version of Ubuntu
* Unofficial software packages not provided by Ubuntu
This is most likely a transient problem, please try again later.
How can I resolve this issue. I don't remember what files I edited to reverse the damage.
My PC running 11.04 was showing a blank screen after every 10 mins while watching BBC iplayer (with all the screensaver and power saver settings switched to over 1 hour). The picture returned when I moved the mouse but it was still annoying.
So I googled for a solution and found this page [URL]. Based on this, I did the following in terminal:
"sudo gedit /etc/X11/xorg.conf"
Then when the text editor came up, I deleted 'EndSection' from the xorg.conf file, and added the following lines:
Section "ServerFlags"
Option "blank time" "0"
Option "standby time" "0"
Option "suspend time" "0"
Option "off time" "0"
EndSection
My problem: upon rebooting the computer, I just got a purple screen with the Ubuntu logo, it went no further. I tried booting with the livecd and removing the lines I added, but it wouldn't let me save the file. I also tried booting into recovery mode but I'm not very adept at the command line navigation stuff, so I don't know how to find or re-edit the file.
Two video files on my external hard disk refuse to be deleted, renamed or moved. They keep giving the following error message
Error removing file: No such file or directory
or
Error renaming file: Input/output error
I have a large music directory that I'd like to somehow acquire, or generate, a list of each sub-folder within it, and then somehow get the list into a spreadsheet format. Is there a way to do this?
View 1 Replies View RelatedI'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$
[Code].....
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
Screenshot-5.jpg
Screenshot-4.jpg
So my question is what's the alternative OpenOffice.org Spreadsheet symbol for the "$" symbol used in the formula bar in Microsoft Excel?
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:
View 2 Replies View RelatedI have been editing MP3 tags with Easytag and it has worked for nearly all files but I have some files that when I open them with Easytag, gtkpod Manager, or MusicBrainz Picard, they display the new tags. But when I open these files with Rhythmbox player and when I look at the file properties I see the original pre-editing tags. I know I can change the artist, album, etc. in Rhythmbox player but that just seems to be a local change and I was more concerned by the audio properties of the file showing the old value because I don't want to have to go back and edit the tags again.
View 2 Replies View RelatedI have Natty Narwhal and everything was working. Then I moved it to my HDTV, and I had overscan issues. Following some advice I found online, I edited /etc/X11/xorg.conf with new information including a ModeLine.
Upon restart, I get my BIOS screen, the Ubuntu splash, then... nothing. The display goes to sleep. I can ping the computer, and everything seems to work except I have no video.
I did backup my xorg.conf file, but I don't know how to get to it without a display. Hindsight tells me I should have given myself a way to remotely control my computer before messing with xorg, but you live and learn.
I've read online that there is a way from the login screen to get to Terminal without loading the desktop environment, but I can't get to the login screen.
I've also tried using a Linux LiveCD to access my filesystem, and that works to view files, but I have no root privileges.
Is there...
...a way to get to Terminal without loading the login screen?
...a way to give myself root access to my harddrive from a LiveCD?
...something else to try?
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?
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.
View 2 Replies View RelatedI'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
I installed vsftpd on my fedora 15 system. I tried to edit vsftpd.conf through gedit
(as root su - command). It showed an error message. I couldn't edit this file. Is there any way to revert my system to gnome 2.30(which is better to work ) from gnome 3
I unpacked a .zip file, and it gave me two directories. Which file must I edit, and how do I integrate the two dir into the edited file?
View 3 Replies View RelatedHow do I save a file edited with the VI editor? How do I get help information on this program?
View 1 Replies View RelatedI use RadHat Linu5.We usually log in to LINUX via putty (remote). Very often many people use the same user and password to log in.I wonder how to tell who has edited/modified a file?
View 9 Replies View RelatedTo make an rpc call I need to sent an xml file as post data.I know how to do this with wget. It works fine when I have the xml already filled in (depending on the node values the response from the call is different).owever I want to be able to edit part of this file, and then sent that as post data using wget. can edit this file using sed (I dont want to rewrite the files each time this gets used; and it does get used alot, with alot of different values).
View 1 Replies View RelatedI use RadHat Linu5.
We usually log in to LINUX via putty (remote). Very often many people use the same user and password to log in.
how to tell who has edited/modified a file?
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.
View 3 Replies View Relatedsince 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?
I have created a very simple spreadsheet - using gnumeric - with small numbers and simple formulas - the numbers fit easily inside their cells - the formatting all seems in order BEFORE I try to print. When I set up the spreadsheet for printing - and "print preview" the document, I see hash marks in place of numbers in a majority of the cells. When I print the document, the hash marks are printed, in place of the numbers. When I view the document under normal circumstances, for editing - the hash marks are not present. All seems well. I cannot print the spreadsheet without the hash marks (#####) appearing!
View 1 Replies View RelatedI would like to create an automatic sequence of Openoffice backups of a spreadsheet file, and each would be the daughter of the previous version.I would like it to autosave every hour so at the end of the day I could then manually make up a 'Day' file for permanent record.
View 2 Replies View RelatedClamAV 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?
View 2 Replies View Relatedhow to read data from excel to java in the excel sheet chinise language is present while reading into java iam getting question marks.how to get chiniese language instead of question marks in the java file
View 1 Replies View Related