Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Comparing two columns in same Excel sheet
Special Forums Windows & DOS: Issues & Discussions Comparing two columns in same Excel sheet Post 302837133 by joeyg on Thursday 25th of July 2013 07:41:14 AM
Old 07-25-2013
I seem to recall Symphony as being a collection of tools, similar to Microsoft Office, released by Lotus.
In the spreadsheet program you would want a command something like:

Code:
=IF(E1=AO1,1,0)

That said, this forum is a Unix forum. I would suggest you search for a forum better suited for Lotus questions.
 

10 More Discussions You Might Find Interesting

1. HP-UX

Creating Excel Sheet in Hp-UX

Dear Members, How do I create an eqvivalant of Excel sheet in Hp-UX. Is there any application like the Microsoft Excel on HP-UX. How do I invoke it. Regards, PrasadKVS (5 Replies)
Discussion started by: KVSPRASAD
5 Replies

2. Solaris

Excel sheet

Hello, I have an information of about 100 odd file names which i have in my server. I need to attach this information in an excel sheet and sent to the concerned team. I use uuencode for attaching a text file. But how will i have all the information in attachment. Please assist. Is there... (1 Reply)
Discussion started by: venkidhadha
1 Replies

3. Shell Programming and Scripting

Excel sheet to be created from unix.

Hi Guys, I like to create a excel sheet with four tabs. Is it possible to create it. Acutually i want to apply formulas in fourth tab which uses the three different tabs. Is it possible to create such a script? Thanks & regards, Magesh (3 Replies)
Discussion started by: mac4rfree
3 Replies

4. Shell Programming and Scripting

Adding Tab to excel Sheet

Hi, I have 2 sets of data in two different files,say f1 and f2. I want to create a excel sheet with two tabs whose names will be set at run time(different from excel name) in a shell script, and the data will be written into those two tabs at run time.Any command in UNIX doing so? I am... (7 Replies)
Discussion started by: Kishore_1
7 Replies

5. Shell Programming and Scripting

Pdf to excel sheet??

Hi everyone, I want a shellscript code that takes an pdf as input and returns the data in the pdf into an excel sheet... Thanks, C10 (3 Replies)
Discussion started by: Carlton
3 Replies

6. UNIX for Dummies Questions & Answers

Add columns to an existing excel sheet

Hi All, i have an excel sheet as below: day ----- monday tuesday wenesday thursday friday i need to append the two more columns in this existing file below: insert date should be todays date--- day insert date insert user ---- ---------- ... (3 Replies)
Discussion started by: arunmanas
3 Replies

7. Shell Programming and Scripting

Perl : to get all the hyperlinks from the xlsx sheet(hyperlinks not visible in excel sheet directly)

Hi folks, I have a requirement in perl to print all the hyperlink from the spreadsheet(xlsx). Spreadsheet contains few lines of hyperlink data (pic attached). P.S. Hyperlink is behind the data and not visible in excel sheet directly. Now using perl script I need to copy the hyperlinks in... (3 Replies)
Discussion started by: scriptscript
3 Replies

8. Shell Programming and Scripting

Format Excel sheet

Hi, I want to format Excel sheet through Unix script. Format would mean bolding the data in the cell, adding clor to it etc. Please help me if it is possible through Unix scripting? Thanks, Durga (2 Replies)
Discussion started by: Durga Prasad NK
2 Replies

9. Shell Programming and Scripting

Summing up the data from different excel sheet into one excel sheet

Hi Folks, Can you please advise for any script in unix such that for example , i have 3 different excel sheet at the location /ppt/gfr/exc so the name s of the excel sheet are 1excel.xslx 2excel.xslx 3excel.xslx now in these 3 different excel sheet there is lot of data for example each... (3 Replies)
Discussion started by: punpun66
3 Replies

10. Shell Programming and Scripting

Writing in excel sheet using ksh

Hello, I'm trying to write a script to export a txt file to excel. The text file is a delimited with commas Example: Report Date,12/12/2014 Report By, Person Issue, Job Failed I tried exporting as csv and mailed to my id. But if I open the csv file the data is coming in single... (6 Replies)
Discussion started by: annamalaikasi
6 Replies

LEARN ABOUT DEBIAN

excel::template::element::backref

Excel::Template::Element::Backref(3pm)			User Contributed Perl Documentation		    Excel::Template::Element::Backref(3pm)

NAME

       Excel::Template::Element::Backref - Excel::Template::Element::Backref

PURPOSE

       Returns the cell location (i.e. B2) of the last cell to name this reference.  To return the location of the entire range of cells to name
       this reference see RANGE.

NODE NAME

       BACKREF

INHERITANCE

       Excel::Template::Element

ATTRIBUTES

       o   REF

	   This is the name of the reference to look up.

CHILDREN

       None

EFFECTS

       None

DEPENDENCIES

       This will only be used within CELL tags.

USAGE

       In the example...

	 <row>
	   <cell ref="this_cell"/><cell ref="that_cell"><cell ref="that_cell">
	 </row>
	 <row>
	   <formula>=<backref ref="this_cell">+<backref ref="that_cell"></formula>
	 </row>

       The formula in row 2 would be =A1+C1.  C1 is the last to reference "that_cell".

AUTHOR

       Rob Kinyon (rkinyon@columbus.rr.com)

SEE ALSO

       CELL, RANGE

perl v5.14.2							    2012-04-29				    Excel::Template::Element::Backref(3pm)
All times are GMT -4. The time now is 09:27 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy