General :: How To Delete Empty Lines In OpenOffice Calc

Jun 17, 2011

How can I delete empty lines in OpenOffice Calc?

View 2 Replies


ADVERTISEMENT

General :: Delete All Lines Containing A String, Plus 4 Lines Below It?

Jan 26, 2010

I've come across an unusual requirement for a service in my Ubuntu system.Simply put, I need to find a way to search for all instances of a term in a file, delete lines containing containing that term, and delete four lines below each instance of that term. ither that, or copy the entirety of a file to a new file and skip over all lines containing the term plus four below it.This sounds kinda weird, I know. Without going too far into detail, I either have to change the logfile format for a server I'm running which is a huge pain in the butt, or I can just run a script to edit an HTML report generated from said logs. (Said report is really just for managers to peruse, and I like my log format, so I'm pursuing option 2.)

View 4 Replies View Related

Software :: Excel Files Have Empty Comments In OO.o Calc

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

Debian :: Calc Function To Return Numeric / Alphabet Or Remain Empty

Oct 17, 2015

I need to make a function combination to get for: If cell A1 then for B1 as:

A1 B1
--- ---
abc abc
hello hello
empty empty
0 0
-3 -3
5 5
and like wise

View 1 Replies View Related

Fedora :: Fill Series Window In OpenOffice Calc?

Dec 10, 2009

I'm using OpenOffice from repo. In Calc I want to fill in 2 cells under eachother, consisting of a name, space and a digit. Then, after selecting both cells, drag them down to get a list of this name, with only the digits being different. When using OpenOffice from original download, this gave no problem. Now however, I'm presented with a Fill Series window that gives me some options like Direction, Series type, etc. And whatever I fill in, it says �nvald value. How can I get rid of this Fill Series window. The Help function in OpenOffice doesn't give a clue on Fill Series.

View 4 Replies View Related

OpenSUSE :: OpenOffice Calc Page Break Preview?

Oct 30, 2010

In OpenOffice spreadsheet, using the Page break preview you should be able to move the thick lines that indicate the separation between pages. Some versions ago you could do it normally. But now it's impossible. You can just move the thick line that indicates the limit of the print area.Has anybody noticed this? Is there any solution? In Ooo for Windoze it's possible, but I prefer not to use it unless is absolutely necessary.

View 4 Replies View Related

Software :: Looking For System (Ubuntu) OpenOffice Calc Spreadsheet?

Jul 11, 2009

I'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 Related

Software :: Openoffice Calc Not Running MS Excel Macros

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

Software :: OpenOffice.org Calc Formula To Check If Day Is Last Day Of Month

Jan 19, 2009

I've got a CD which does the monthly compounding on the last day of every month instead of every 30 days. The bank gave me a print-out (of course), but I'd like to make my own Calc spreadsheet too. My question is: How do I check whether a certain day is the last day of the month? In other words, I'm looking for something that returns TRUE if it's the last day of the month and FALSE if it isn't. I'm using OpenOffice.org 2.4.1 on Ubuntu 8.10.

View 1 Replies View Related

Software :: Setting Data Types In OpenOffice Calc?

Mar 3, 2010

you are using Calc to hold data, and you have a column of surnames. You enter True and it turns into TRUE: OO has decided you wanted a Boolean. Similarly, you enter a date as 12 Jan 09: it may appear in that format, but you can't search for Jan 09, only for 01/09. Is there any way one can set the data type of a cell as text, or prevent OO from carrying out unwanted type conversions? I suspect the answer will be no; I can't find anything in the pages, and I suspect the developers would say I should be using Base. Well, I don't want to use Base: I want my data displayed spread-sheet style There is a solution: to insert non-breaking spaces in dates and after words like "true", but it would be nice if the problem could be fixed just once.

View 5 Replies View Related

Ubuntu :: OpenOffice Calc: Macro Command To Select Entire Row / Column

Feb 4, 2010

What is the macro command (in OpenOffice Basic) to select an entire Row or Column? I tried to "Record Macro", then click on the Row/Column header, which would then select the entire row/column. But "Record Macro" failed to capture this action.

View 1 Replies View Related

Ubuntu :: OpenOffice Calc Fails To Include Sheet References In VLOOKUP Formula

Nov 1, 2010

I am trying enter a VLOOKUP formula in Sheet1, where the array is in Sheet2. For both the items, I have used mouse to enter cell references, which I always do.

1. Search criterion has been entered as a range, which is different from previous versions and not a very comfortable situation.

2. array reference completely missed entering Sheet2! in front of A1:C13. Only way out of this is manually entering the sheet name, which is not only cumbersome but also ludicrous. Moreover, we never had to do it like this in the past. I am using OpenOffice.org 3.2.1 in Ubuntu 10.10.

View 2 Replies View Related

General :: How To Delete All Empty Folders

Jun 7, 2010

I just had a bad experience with a server, and now i have a 17GB lost+found. It appears a lot of the stuff in there are folders which are empty. Since those really serve no purpose as far as recovering data from what I can tell, is there a slick way to delete just the empty folders from my /data/lost+found folder, leaving me with just the stuff I truly need to look through?

View 3 Replies View Related

General :: Why Seq 10 Sed Just Delete Three Lines

Jun 30, 2011

Code:
[root@station3 ~]# seq 10 | sed -e '1,2d' -e '1,2d'
4
5
6
7
8
9
10
We can see that sed just deletes the first three lines. How "seq 10 | sed -e '1,2d' -e '1,2d'"works?

View 1 Replies View Related

General :: Delete Last 6 Lines Of File With Sed

Jun 5, 2011

looking to delete the last 6 lines of a file with sed. figured out how to delete the last line..but i want the last six.

View 6 Replies View Related

General :: Copy Some Lines In A File And Delete These After?

Jul 20, 2010

I have a file that contains 100 ligns, i need to write a script that read 70 lignes and redirect those 70 ligns to another files and these 70ligns have to be erased in the first file

when i write this command
head -70 somefile.txt>test.txt
or

sed -n 70p somefile.txt>test.txt

i have these 70 lines in the text.txt files
but these 70 lines have to be deleted inthe first file somefile.txt

View 1 Replies View Related

General :: Delete Lines From File By Their's Length

Apr 27, 2010

i've got a file with sorted words - one on each line.How could it be possible to delete thouse lines that have words of length 1 or 2 (1-2 letters). I guess a good way it will be with AWK, n its fuction length(), but getting it, i dont know how to delete those very lines.

View 14 Replies View Related

General :: Use Sed To Delete All Lines Before First Match Of A Pattern?

Apr 14, 2010

I have to use sed with this problem, and sed is extremely complicated, they could probably teach a whole class on this entire function.

Here's an example to show what I need to do:

Code...

how would I say that every line before I reach the first match of "sweet" should be deleted so that the output will look like: Code...

View 9 Replies View Related

General :: Delete All Lines In A File Which Consists Of Particular String?

Mar 21, 2011

i am having following lines in a file called test.

subscribe parser for dinesh
extend size for dinesh
subscribe parser for anish
unsubscribe parser for dinesh
extend size for arvind

I want to delete all lines which contains the string "dinesh". Is it possible.

View 8 Replies View Related

Software :: OpenOffice Calc - Sticky Selections In "Paste Special"?

Jan 27, 2011

I just upgraded to OOo v3.3.0, but it feels more like a downgrade; a real disappointment. In my previous version, I could choose 'Tab' in the 'Paste special' dialog and the choice would stick between pastings as well as between sessions. No longer so. In v3.3.0 I have to tick 'Tab' and 'Detect special numbers' each and every time I paste something. I am working with OOo all day and this regression is tiresome, to say the least. So, I am wondering whether there is a way to make the choices sticky? If not, I shall have to go back to the previous version, or perhaps try out LibreOffice.

View 7 Replies View Related

General :: Delete Duplicate Lines Without Removing First Instance Of That Line?

Feb 7, 2011

I have a file "test.txt" with following data

#1
aaa
#2
bbb
#3
aaa
#4
ddd

I wanted it to be displayed as

#1
aaa
#2
bbb
#4
ddd

I used awk "'!x[$0]++' test.txt > file.new"
,but it deleted #1 also.I tried using uniq command but i didn't work.
Can anyone Please let me know is there any way to do this using shell script.

View 2 Replies View Related

Debian :: Print An OpenOffice Or LibreOffice Calc With An Image And Text, The Image Is Not Printed (the Space Is Blank)

May 11, 2011

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]..

View 3 Replies View Related

Software :: "link" One Column To Another In OpenOffice Calc?

Jul 28, 2011

If I have say, a column of Months, eg. "January", "February" etc., with a "income" column to the right of it, for say, 6 months - eg. "423", "2342", if I highlight some or all of the months and Sort it, I would like the "income" column values to move up and down as well- eg. if the months become "February", then "January", I would like to see the corresponding change in the "income" column as well, eg. first "2342", THEN "423". I would like this even if I say, Manually move the "months" column data around, eg. put "February" at the bottom.

View 2 Replies View Related

Programming :: Bash There Will Be Empty Lines At The End Of The File?

Mar 26, 2011

Using awk I pull the first field of a random line from my datafile.myvar1=`awk -F" " 'NR=='$randline' {printf "%s", $1}' myfileThis works fine. The problem is there will be empty lines at the end of the file. Rather than using awkto filter out blank lines I would like to figure this out first.So I test $myvar1 for a blank string after setting $randline to one that I know is blank:test -z "$myvar1" && echo "true" || echo "false"But, this returns "false"? So the string is not zero length. Why? It's a tab-separated file. Is awk storing the tab with the $1 field or something.This is where I get headache. I try to echo my variable to see what it looks like.

echo "$myvar1"
outputs: nothing
echo "My variable is [$myvar1]"
outputs: [y variable is [

Why is the closing bracket at the beginning? What character could be stored in $myvar1 that would do such a thing and how did it get there?

View 7 Replies View Related

Programming :: Delete Folder Not Empty C++?

Dec 5, 2009

I'm using rmdir(), and everything goes ok if the directory is empty, ?how can I remove the entire tree when i have other files or directories in the folder that I want to delete?I've read about using "system(rm....)" but i REALLY want to do this without it, is it possible?

View 4 Replies View Related

OpenSUSE :: KMail HTML Email Always Removes Empty Lines When Viewed In MS Exchange Outlook

Dec 8, 2010

When sending an HTML formatted email with KMail and viewing this email on an MS Exchange Outlook client, all the empty lines are removed. This appears to be a known issue (KMail & HTML. - KDE Community Forums), but I was hoping anyone here knows a workaround for this....?

This is REALLY annoying when using KMail in a business setting, since emails look embarrassing on a customer's email client (which is in 99% of the cases Outlook, I'm afraid).

View 9 Replies View Related

SUSE / Novell :: Delete (empty) Tmp Folder In 11.2

Jan 29, 2010

I have tried to empty the root /tmp folder but instead to empty it I , as it seems, deleted it with rm -rf /tmp as su. Now SUSE does not start anymore.

1. how to repair that and

2. how to empty the tmp fplder.

View 5 Replies View Related

Ubuntu :: Cannot Delete Or Empty .Trash-1000 Folder?

May 5, 2010

Straight to the problem on my [Ubuntu 9.10].I cannot delete or empty my .Trash-1000 folder on my flash drive. I tried changing permission with chmod but no way, I cannot empty the folder via the Ubuntu main trash option 'Empty Trash'. I read a bunch of threads but no way.Do you know a solution that works to this problem?Even further. Do you know a way to tell nautilus to avoid using that folder in my USB devices and use instead the normal trash folder on my system?

View 5 Replies View Related

Programming :: Delete Lines Between Match?

May 15, 2011

My problem is like this I have to delete all lines between two pattern match example- suppose below is the content of the file then i have to delete all lines between text1 and text2

...
text1
abc
def
ghi

[Code]....

View 14 Replies View Related

Ubuntu :: Using Sed Or Awk To Find And Delete Lines In A File?

Dec 21, 2010

I have a bunch of text files, all of them have a .txt extension. They are all located in subfolders of the /MyTextFiles folder (but could be anywhere, no idea what depth). If any line in any of the text files has the word "hello" I want to delete that entire line. I know sed and awk are made for this problem but I can't seem to get the syntax correct.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved