I just received a spreadsheet. Column B contains thousands of rows that look like this:
Giant Red Pencil 0.99
Case 2.99
Green Box 1.49
Ruler 0.59
Spiral Ring 0.10
So each cell contains the item and price. I need the corresponding cells in column C to contain only the price like this:
0.99
2.99
1.49
0.59
0.10
How do I extract just the price from column B and put it in column C ?
I have a file of words and want to encode them in a numeric form, based on position.This is best explained by example:
PEOPLE ==> 123152
Reading left to right:
P was first encountered at position 1 so it is encoded as 1.
E was first encountered at position 2 so it is encoded as 2.
[code]...
In my table, whenever I enter true or false in any cell, Writer changes it to all Caps, so true becomes TRUE and false becomes FALSE. Now I did not set the cell type to BOOLEAN. If I do Format > Change Case > Lowercase it changes, but reverts to all caps the next time the document is opened. I have checked autocomplete, autocorrect, table number format but seem to change this behaviour.
View 2 Replies View RelatedI want to count the digits in between the text in a file.
e.g.
write down the form
2.3 3.3 3.0 505.0 0.777E-07
22.3 3.3 5.0 503.0 1.777E-04
Then read this.
How can i do the counting of these digits present in between a text in a file?
Is there an application or script file that I can use to send a message to my cel phone every day at the same time with cron? I have medications I need to take and sometime do not realize I've missed the timing until 4-5 hours later.
View 5 Replies View RelatedAnyone know of an application that I can send text messages to cell phones with? I send alot of text messages to my wife while I work and it would be so much easier if I could just do it from my keyboard.
View 3 Replies View RelatedElsewhere is my question about 11.3. I have had to abandon that and 11.3 as my RAM is too small. Now, for the first time in many years, I find it necessary to extract specific data from received .pdf files. According to OpenOffice, editing of these files is only possible from version 3.2. My concern is whether this later vesion will be compatible with 11.2.OpenOffice installed is 3.1.1.4-1.1.4-i586. The same question has been directed to their Forum.
View 9 Replies View RelatedFedora 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 have a lot of files containing chat-log (IRC) and would like to extract information out of these files.
File sample
Code:
Session Start: Sat Apr 03 15:06:29 2010
Session Ident: XXX
[15:06] XXX is ~X@host-85-85-85-154.isp.be * XXX
[15:06] XXX on #channel1 #channel2 #channel3
[Code]....
I have many files in a folder from which I need to extract some contents, these are basically text files wich have individual lines with (i.e)
name: john
address: whatever
phone: 123456
Some caveats
1. Sometimes a line might be missing.
name: johnn
phone: 123456
2. Lines are not in the same line-numbers across the files I did try some things with awk based on google searches but I couldn't extract the data of each file into a single line (this is the ultimate goal):
john,whatever,123456
I don't have knowledge other than having put some bash scripts together for backup jobs, so I am open to install anything that could to pull this off.
I'm trying to figure this error message out. This little script is supposed to tweet my laptop's IP address, as a cron job, I'm hopeful that it would do so even if it's stolen. This is a variant of one that works, but this doesn't, and I can't see a difference in the curl line of either one.
Code:
#!/bin/bash
user="xxxxxx@xxxxxxxxx"
pass="xxxxxxxxxxx"
wget [URL]
TWEET=`sed -n 1p index.html`
curl --basic --user "$user:$pass" --data-ascii "status=$TWEET" "[URL]"
rm -f index.html
exit
This is the error message.
Code:
curl: (6) Could not resolve host: status=66.183.103.67; Cannot allocate memory
{"request":"/statuses/update.json","error":"Client must provide a 'status' parameter with a value."}
Why does curl think the status is the URL?
Good day, having a spot of bother with Openoffice, for some unknown reason im finding majority of the menu & button names have been replaced with "O" characters instead. Its doesn't effect all, but for example in the Writer, the only drop down menu at the top being render correctly is "Table". code...
All the buttons/sub buttons still work if you can guess where their pointing!
The only way I can seem to solve it is to remove "openoffice.org-gnome" & "openoffice.org-gtk" package.
Ive tried a complete reinstall already. Its usable without the above gnome and gtk extras but obviously not as nice to look at.
Im sure it was working fine the last time I used it?
I use Ubuntu 10.04 and OpenOffice 3.2.We have forms we use for computers we sell. I have to fill out a profile. The problem is I cannot enter text into the text entry fields. I get this error:"Readonly content cannot be changed. No modifications will be accepted."Here is a link to one of the files. If you try to enter more that a digit or two in a text field, you get that error:[URL]
View 9 Replies View RelatedI just upgraded from 9.04 to 9.10 then discovered that, in openoffice.org-writer, the text in the UI is gone. It's strange because the text to be edited is still there. So maybe it's a font or rendering problem but I suspect something related to the window manager is going wrong. I have checked and re-installed openoffice but I haven't been able to fix this so far.
View 1 Replies View RelatedI have this really strange openoffice behavior. Normally to drag window i need to press alt+left_mouse_button and drug window. Exactly same result i'm getting while selecting text in OOo writer and impress. As simple as holding still for, literally, a second, while selecting text, will initiate dragging of the entire window. I'm running F14_64 KDE and using OOo from repos.
View 3 Replies View Relatedi have a problem, when i open OO, the text of the menus is replaced by little rectangles.
For example, instead of:
File Edit View etc..
(they look more like rectangles than squares) i also have this problem with drop down menus, font names, font styles and even with the numbers on the ruler.
Ubuntu 9.10, OO 3.1
I have been using Ubuntu 10.10 for a few months now. I enjoy working with it, but there is one strange problem with Open Office (and Inkscape as well). When I attempt to work with either the word processor or spread sheet (this probably applies to other Open Office applications as well) under the default theme in Ubuntu, inevitably I get text and other elements blotted out with line smudges.
I have included a couple of screen shots, but I am wondering if this is a recurring problem with theme support (Open Office doesn't really use GTK/Gnome, does it?) or if it is some strange affect with the nvidia driver that I installed (version 260-19-06, my card is a GeForce Go 7150M). I have also noticed a slightly different problem, with Inkscape, where the ruler marks that track. The cursor movement don't delete themselves when the cursor moves, so the little triangles build up.
Using Debian Lenny
OpenOffice 2.4
I'm trying to fill in an application form that I downloaded. It has some shaded areas where I can answer questions, but there are
a couple places where the shaded areas are missing.Have you previously applied with the C.B.E? "Readonly content cannot be changed No modifications will be accepted." Can I add a shaded area in so I can fill this in, or can I disable the read only part?
I have recently done a clean install of Ubuntu 10.04. Since then I have had no end of trouble with Openoffice 3.2.
When I open any office app, the text on the menus is corrupted and has lines going through it. I've included some screenshot to show what I mean.
Also, sometimes when I open an Excel spreadsheet my entire system crawls to a standstill and it can take anything up to 10 minutes for it to respond again. Not even the mouse cursor will move. If I reboot the PC and open the same document it will sometimes be just fine. It is very random.
So far I have tried uninstalling and reinstalling openoffice.org from apt-get, but this hasn't fixed the problem.
My system:
OS: Ubuntu 10.04
CPU: Core 2 Duo
GPU: nForce 610i/nVidia 7050 (onboard VGA)
RAM: 2GB
I've just upgraded to Maverick Meerkat on a new Dell system and everything was working just peachy until today. I've spent the last couple days tweaking my ubuntu so something I did made it so that open office only allows me to click inside it and write text some of the time, and very slowly. And then my panel doesn't show the text of the main menu headers. If i click on them though, the menu shows up with text inside it totally in tact.
The problem disappears when I disable the additional driver (preferences-additional drivers-remove). And recurs when I activate it. So, suspect its a conflict with xorg and the proprietary driver. I'm running emerald with window decorations (theme is neon glow) - changing the emerald theme doesn't affect the problem. Im also running compiz-fusion.
I have Open Office 3.2 with Ubuntu 10.04.When I select text-- a word, a few words-- and then click on highlight on the toolbar, it highlights the whole paragraph, rather than just the selected text. This is a new problem for me, before it seemed to be working fine.
I searched online but haven't been able to find anything about this problem. I had tried to install the sun version of Open Office a few months ago, but wasn't able to in the end: [URL] I saw that OpenOffice 3.3 is out, but I would rather not upgrade until Ubuntu puts out the upgrade.
I get this:
0000000 1202 0 0 0 0 0 0 0
0000020 141 89 63 89 141 0 0 0
[code]....
How to go from decimal to numerical values?
what i am trying to do is to allow the user to key in data such as "23.23" or "24" , as it is the price of certain objectsHow am i able to design a check which will allow me to prevent users from typing in input such as "ab.21" or "rfrr" as this field is purely a numerical field. The problem i am facing is i tried using this search code.
Code:
echo "read this"
read this
[code]....
I have a Canon iR3570/iR4570 PXL, and installed the driver CQue 1.0 TCP/IP Queue from Canon webpage.
The problem:
- if i try to print an OpenOffice or LibreOffice Calc with an image and text, the image is not printed (the space is blank).
- if i try to print an OpenOffice or LibreOffice Calc with just an image, it's printed great.
- if i try to print an OpenOffice or LibreOffice Impress, the images are not printed but the text is printed great.
[Code]..
I have a file like:
ER- V67
ER+ V68
ER- V69
ER+ V70
[Code]....
I am using the code:
sort -k1
but it prints it by sorting the second column.
Using PHP 5.x. I would like to sort a set of values first numerically, then alphabetically. For example, here's my code so far:
Code:
<?php
print "<p style="font-family:verdana;font-size:10pt">
";
$myArray = array("1223:starfruit", "34112:oranges", "1223:zucchini", "321:apples", "34112:pears", "1223:tomatoes");
[code]....
I have fiddled with array_multisort but I can't seem to get my head around it or the many sort routines in PHP.
I have this .txt file
3183630 R
3574216 W
5264994 M
2656889 A
I want to sort it by the numerical order of column. After sort, I wish to get output like
2656889 A
3183630 R
3574216 W
5264994 M
anyone knows how to use sort to do that? or any other command?
I am using some "Numerical Recipes in C" routines in my C code.(I am using ludcmp() & lubksb().)These are used to find inverse of a matrix.After compiling my c code, I get following warning messages.I have not understood them at all. What is the meaning of these and why did they pop up and how to remove them?
Code:
nrutil.h:11: warning: 'sqrarg' defined but not used
nrutil.h:14: warning: 'dsqrarg' defined but not used
[code]....
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]...
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.