spreadsheet
Formulas to populate spreadsheet with data
I want to populate some cells given certain condition. The thing is, I have no idea how to do this with just formulas (can’t use macros or the sort).[详细]
2023-04-11 07:20 分类:问答Setting an Excel worksheet's custom page size (not the printable area) from Perl
Long story short, all I\'m really attempting to do is print my reports on half sheets. I had Kinko\'s chop a pack of printer paper in half and my laser printer is perfectly happy to suck them in and p[详细]
2023-04-10 23:57 分类:问答Do you know of a sophisticated spread sheet like component for Swing
I need to write a data exploration tool that displays large amounts of data in a spreadsheet format. Salient problem features:[详细]
2023-04-10 17:02 分类:问答spooling a clob value with multiple lines using sqlplus to a single cell of a CSV
I tried to spool a CLOB to a CSV file using code that looks like below: set pagesize 0 set heading off set long 30000[详细]
2023-04-09 03:44 分类:问答In Apple Numbers, how can I calculate a difference between two dates?
I have a spreadsheet with data in Apple Numbers.I have a column of dates, and I would like to create a second column which displays the difference in number of days between the two dates.[详细]
2023-04-08 18:38 分类:问答Conditional Formatting in Excel using Alphanumerics
I have a conditional format in Excel that is displaying the up/down arrows based on certain values. This works just fine. However, in my spreadsheet (which is largely controlled by VBA)the user has th[详细]
2023-04-08 14:28 分类:问答Excel spreadsheed populate cell based on value of another cell
I have a excel spre开发者_运维百科adsheet that contains a bunch of columns. My first column contains values of mpg(about 300 entries of miles per gallon). What I want to do is populate another column[详细]
2023-04-06 11:45 分类:问答iphone GData spreadsheet unrecognized selector
I\'ve used the GData spreadsheets code for MAC to write a corresponding iPhone version (the same code), but I get a exception thrown:[详细]
2023-04-04 17:46 分类:问答Formula One (Tidestone) question
At work we\'re stuck with using Formula One Excel components. The problem is that I can\'t find anywhere to post questions so I thought I try here.[详细]
2023-04-04 10:46 分类:问答Fox Pro 8 - Export to Spreadsheet
I don\'t have much programming knowledge, but I h开发者_如何转开发ave a data set on a CD in the FoxPro format and I need to know if it can be exported to something like Google Docs in the form of a sp[详细]
2023-04-03 19:58 分类:问答