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 RepliesAccidentally we happened to rename the ldl 64 bit library and since then no command has been working on the linux box, inlcung cp,move and su. How to recover from this?
View 1 Replies View RelatedI've been an UBUNTU advocate and supporter since I switched to Ubunto v8.4. However, in my opinion, version 10.10 is the biggest piece of **** yet - everything is broken.
I have seven PC's at home: an office PC, a Media centre, two computers for the kid's, a milling machine running EMC2 and two laptops.
If I recall, v8.04 was okay and v8.10 gave me endless hassles. But I stuck with it, taught myself the basics, and got each of my machines doing what I needed them to do.
Upgrading from v8.10 to 9.04 to 9.10 to 10.4 all occurred effortlessly and without any issues.
However. both the Beta and final releases of v10.10 are extremely disappointing. Why do you guys need to release a "NEW" OS every six months? Why can you not fix / enhance the latest, best version?
Since upgrading to v10.10, ALL my PC's are broken in some way: Drive sharing is broken, my Media centre is broken (tuner cards won't lock onto signals - what is that?), VPN is broken, Remote Desktop is broken, printing doesn't work, sound is screwed.......And I certainly do not have the time and the patience to start from scratch trying to get everything working again - that's why I make backups (twice a month).
What are you guys doing? And please don't ask for logs and hardware specs - Everything was working great with v10.04.
Herewith a question to my fellow countryman Mark S - Wat gaan aan? Wat vang julle aan? Why change things that work(ed) perfectly fine? Maybe you should change the name for v10.10 to "Ubutu VISTA". That's exactly what made me (finally) dump Microsoft.
My harddisk had one extended partition, sda2, split into several logical partitions: da6,sda5,sda7,sda8,sda9 in this order. sda6,sda8,sda9 were [the only] PVs in one [and only] volume group.
I tried to delete sda7 and to resize sda5 (both unrelated to the LVM setup) to take the freed space. I entered both changes in GParted and clicked 'apply'. It gave some error, but had apparently deleted sda7, without resizing sda5. I tried to resize sda5 again, it again gave an error again, but sda5 was resized. I did not save any logs from GParted. Then I saw that the partition names had changed to sda8,sda5,sda6,sda7, in this order.
Now when I run 'vgdisplay', I get the error "Couldn't find device with uuid ....". Running 'blkid' gives the uuids of sda5,sda7,sda9. According to GParted and fdisk, sda9 does not exist. Also, according to blkid, the uuid of sda7 is what used to be the uuid of sda8. I am very confused. As you could expect, I don't have backups, so... (I am now creating a copy of the whole disk, in case things go even more wrong)
I am running a test installation of Ubuntu 10.04 Server on a Virtual Machine (VBox specifically) in order practice recovering RAID problems. When I initialy created the RAID arrays I created a MD Device named "md0" with an ext4 file system and "/" mount point. My other RAID array was called "md1" and was used for swap.When loading GParted off of a bootable disk I noticed that the devices were changed from md0 and md1 to md127 and md126. I shut down the VM and on reboot grub rescue shows up saying that disk can not be found and using "ls" lists the MD devices as they appeared in GParted (md127 and md126).
I rebuilt the OS via importing an backup Appliance and repeated the same thing. Boot into Ubuntu, success, then sudo shutdown, boot into GParted, note md device name change,shutdown, boot into Ubuntu, grub rescue.Is there anyway to stop this from happening(in the event that GParted must be used on a Physical Machine). Or a way to revert the problem after GParted messes the system up?Edit: I talked with one individual who suggested changing the md device names to md 127 and md126, but I am looking for a more robust solution than taking a shot in the dark that GParted will set the same names on other systems.
I just did something stupid... I wanted to remove a numeric prefix from a bunch of files in a folder (EXT4 filesystem), and I ran the following Python commands to rename the files:
Code:
import os
currentdir = os.getcwd()
[code]...
I get annoyed sometimes that from one Fedora release to another, some programs get renamed or put into different packages. Examples:
* Gnome's volume control applet. Used to be provided by gnome-media, now it's moved to control-center. Worse, the command itself was renamed from gnome-volume-control-applet to gnome-sound-applet, so I couldn't even try a `yum provides` search to locate it.
* Gnome's Disk Usage Analyzer tool. Used to be in a package by itself, baobab. Now it's provided by gnome-utils.
Is there a wiki or something where the full list of all renamed/repackaged programs can be found? I'm not a Gnome desktop user, so, while I'm sure all the packages I like from Gnome are just there out-of-the-box for most users, it doesn't help me very much. The volume control applet for example is extremely useful for other desktop environments (and Gnome itself really doesn't have much need for it anyway, since they have their own built into the window shell).
I have this script that I use to find log files in the /var/log directory that are 2 days old, move them to /var/log/tmp, rename them to the system date.filename and move them back to /var/log. Everything seems to work as planned, except that the files don't get moved out of temp, and they keep getting rename. This leads to very long filenames such as:
2010-02-22.user_040.2010-03-05.user_040.2010-03-07.user_040.gz
What is it about this script that isn't moving it back to /var/log? Also, is there a better way of doing this than what I'm doing? Basically, I'm just trying to set up an audit trail on some of the files in /var/log, so that at the end of the month I can tar them, and then have our syslog server pick up the one giant monthly log.
Code:
# Create variables.
dir="/var/log"
tmp="$dir/tmp"
hostname="$(uname -n)"
[Code].....
Almost every time I use my external Hdd the drive gets named with an appended underscore. this is the list from my /media folder.
/media$ ls
1CF44533F4451106 F Drive G Drive_ G Drive___ G Drive_____
E Drive G Drive G Drive__ G Drive____ G Drive______
i have tried to remove the directories in terminal by using sudo rmdir but this is the error i get:
sudo rmdir /media/g drive
rmdir: failed to remove `/media/g drive': No such file or directory
now each file in the /media folder has a white x on them and i don't not know what that means. but i attached a screen grab of the folder.
how to know how to delete all the underscored folders.
After what feels like weeks have tinkering around trying to get a Samba file server set up, I've finally given up! I have 4 drives and 2 groups:
1) Dev - Available to all users in both groups (normal and admin)
2) Misc - Available to users in admin group only
3) Admin - Available to users in admin group only
4) Accounts - Available to users in admin group only
Drives 1 and 2 are working fine, with the correct access rights. Drives 3 and 4 can be browsed by admins only, but no changes can be made at all - files & directories can't be renamed/moved/deleted. What is most confusing is that Drive 2 is set up exactly the same as Drives 3 and 4. The process I went through to get them working:
[Code]...
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 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'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?
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 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
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 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 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 RelatedI'm looking for a Linux Open Office Calc Spreadsheet template to replace Intuit's Quicken. I prefer a spreadsheet over a stand alone. Anyone?
View 1 Replies View RelatedIn my prior experience with spreadsheet software on Linux, Gnumeric has been the most useful for my daily tasks. However, I am now required to plot scientific data and I need to be able to plot log-log graphs and semi-log graphs (graphs with logarithmic scales for x- and y- axes) and I cannot seem to find a program that will "fit the bill".
Gnumeric allows for log-log and semi-log graphs by selecting the logarithmic scale for the x- or y- axis, however it automatically does the log to a base 10 and I need to do log graphs to base n (n being a variable that I can set, whether it is 1.5 or 150000).I know this is possible in MS Word (somebody showed me a few weeks ago), but I want a Free (as in speech and as in beer) program that will allow me to plot log-log and semi-log to different bases. OpenOffice.org is also not useful for doing this as it plots to the base 10. Also tried labplot and qtiplot, they give a few more bases but still no base n
I have a spreadsheet which I update regularly. This involves downloading CSV files from a couple of websites, copying data from those files into an OO.org spreadsheet and copying formulas within the spreadsheet (the number of rows of data varies, so when the number of rows of data increases, I need to copy more lines of formulas).
I'd like to automate this process, so that with a single command I can get the data from the websites and feed it into my spreadsheet without having to copy rows of formulas. Although I've done lots of numerically-oriented programming, I have no idea how to undertake this automation task. I don't even know which tools I need to learn to do it.
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.
View 1 Replies View RelatedI had (and still do) a working dual-boot XP/Karmic (GRUB version 1.97 beta4). I shrank the Ubuntu partition and set up partitions and installed Debian 5.04. When I got to the point of installing GRUB, I told Debian to install grub to MBR. On rebooting, Ubuntu was not an option on the NEW (looked different) grub menu.Maybe it was GRUB2? Could boot to either XP or Debian though.
Thought easiest thing was to reinstall Ubuntu since it seems to "see" other OS's more reliably. So I did, and installed GRUB again during its install to MBR. Then, all three were in the GRUB menu (version 1.97 beta4 again), but when tried booting to Debian, got an error (forget the wording), but think it was because the partitions got renumbered when installing Ubuntu.
SO, reinstalled Debian, reformatting the partitions but not deleting them first so the numbering stayed the same. When got to the part for installing GRUB, I told it to skip (I got some kind of error that said "Install failed. This is a fatal error. You will have to boot with an external device..."), hoping now the current GRUB would work.
Now, all three were on the GRUB menu, but when I tried to boot Debian, I got "no such device" and a list of numbers/letters after it. And "press any key to continue", which takes you back to the GRUB menu (version 1.97 beta4, by the way).
O.K., did sudo update-grub in ubuntu and rebooted. Now, Debian 5.04 shows as last entry in GRUB, and choosing it starts a boot, which hangs at "Begin: Waiting for root file system....".
Waiting long enough at the "Waiting for root file system..." hang results in a series of notifications:
WARNING bootdevice may be renamed. Try root=dev/hda3
Gave up waiting for root device. Common problems:
-Boot args (cat /proc/cmdline)
-Check rootdelay= (did the system wait long enough?)
-Check root= (did the sytem wait for the right device?)
-Missing modules (cat /proc/modules; ls /dev)
ALERT! /dev/sda3 does not exist. Dropping to a shell!
In Gparted, the partition with Debian root is hdc3, although on the GRUB menu it's listed as /dev/sda3. However, in Gparted the Windows partition is hdc1 and on GRUB it's /dev/sda1, and it boots fine.....
Is my Debian install just borked? Did telling it to skip installing a bootloader (I got some kind of error that said "Install failed. This is a fatal error. You will have to boot with an external device..." ruin it?
If skipping the bootloader install did ruin it, how do you install Debian without borking your current GRUB? That's what happened the first time.
I have a problem to reorganize a spreedsheat using shell, I want to use "sort" to organize the first column (descending scale) and then organize the second column in an ascending scale related to the first column so that the final result should be that one displayed at the end of the message. I have tried "sort -r -n" but I don't know how to reorganize the second column related to the first column.
40.0 20.0 9
40.0 15.0 8
40.0 10.0 14
40.0 5.0 12
39.0 15.0 18
39.0 10.0 19
39.0 20.0 5
39.0 5.0 4
41.0 20.0 10
41.0 15.0 12
41.0 5.0 8
41.0 10.0 7
Solution:
41.0 5.0 8
41.0 10.0 7
41.0 15.0 12
41.0 20.0 10
40.0 5.0 12
40.0 10.0 14
40.0 15.0 8
40.0 20.0 9
39.0 5.0 4
39.0 10.0 19
39.0 15.0 18
39.0 20.0 5