Stack Overflow
Stack Overflow

Questions tagged [excel-2008]

Released in January 2008, the Mac OS X equivalent of Excel 2007 except distinguished from that and other Mac Excel versions for lack of VBA.

35 questions
10
votes
5 answers

Conditional formatting to hide cell content even when printed

I would like to set up a conditional formatting setting that would hide the contents (the cell should look blank) if the cell's contents is equal to another cell. Does anyone know of a function to do this? I tried just making the font the same color…
Jeff Erickson
  • 3,783
  • 8
  • 36
  • 43
10
votes
5 answers

AppleScript or Automator to click on menus in an application?

I'm not sure if this is do-able via AppleScript and/or Automator…but I'd like to be able to: a) launch an application (I know this can be done pretty easily by AppleScript or Automator) b) once the application is launched, use AppleScript or…
user141146
  • 3,285
  • 7
  • 38
  • 54
9
votes
1 answer

How do I create a chart with multiple series using different X values for each series?

I want to draw several graphs and combine them into one figure. I will explain the problem in an example. Let's say that I want to draw two graphs with these points: Graph #1 (X and Y are defining a coordinate). X - Y _____ 1 - 5 2 - 5 5 - 7 9 -…
Ivan
  • 519
  • 2
  • 6
  • 14
4
votes
2 answers

Access MS Analysis Services Cube via Excel on Mac?

In MS Excel 2007 on PC you can connect to a MS Analysis Services Cube via Excel. I can't see how to do the same on Mac using Excel 2008 there. Does anyone know how to access the OLAP cube data on Mac?
Cilvic
  • 3,417
  • 2
  • 33
  • 57
3
votes
4 answers

How do I import text into time format?

I have text files from a data logger in a format like this hh:mm, Data, Data that I need to import into Excel. I cannot for the life of me figure out how to get Excel to import the hh:mm part as (24 hour format) time instead of text. Is it…
notMyScreenName
  • 119
  • 1
  • 3
  • 10
3
votes
1 answer

Porting Applescript to Scripting Bridge: can't get value of range in Excel 2008

I have a need to move some Applescript code to Scripting Bridge to take advantage of some Cocoa hooks without the need for Applescript-ObjC. Using Excel 2008 with Applescript, getting the value of a range is easy: set myList to…
Philip Regan
  • 5,005
  • 2
  • 25
  • 39
2
votes
3 answers

ODBC connect with propritary driver/Excel Trust settings

I have a spreadsheet in Excel that connects to an internal DB using the odbc driver for the software (Action Request System). That works fine. Now I'm trying to move the Excel file to a SharePoint site so that our team can review the data and make…
Anthony
  • 36,459
  • 25
  • 97
  • 163
2
votes
1 answer

Setting Time Stamp Axis to Show Only Hours and not Partial Hours

Using Excel 2008 (Mac) I want the hours shown in the x-axis not to be 1:12, 2:24, 3:36, etc but 1:00, 2:00, 3:00, 4:00, etc.
Timothy Clemans
  • 1,711
  • 3
  • 16
  • 26
2
votes
1 answer

Delete mutiple instances of variable strings within a single cell

If I have a cell looking something like this: Ford Escort (ref 1234) , Ford Mondeo (ref 5588) , Suzuki Swift (ref kjgh) , John Holmes (hulubulu) and want to remove all the parentheses and the information inside those but NOT all the information…
olin62
  • 23
  • 3
1
vote
1 answer

Saving a chart as .jpeg file

I have been using Excel charts for some years for creating computer animated movies for teaching physics. However, in converting from VBA to AppleScript I have had trouble saving the charts as .jpeg files. I have tried the script below: tell…
Robert B. Moore
  • 11
  • 2
1
vote
1 answer

Excel copy and paste a column of hyperlinks

I created a column B of hyperlinks by using the formula =hyperlink(a1) etc. Now I'd like to copy and paste the hyperlinks into col C in a way that gets rid of the formula so that I can delete column A. The command "paste as hyperlink" doesn't seem…
IdRatherBeGardening
  • 65
  • 2
  • 10
1
vote
2 answers

Formula to get lowest value based on two columns

I'm looking for some help with an Excel formula for determining the lowest value based upon data in first two columns. I have seen questions regarding basing it off one column, but I'm not sure how to convert that into a two column data range…
Jess K
  • 11
  • 2
1
vote
0 answers

AppleScript and Excel 2008 PivotTable

I've been having a lot trouble creating a automation script for moving Excel columns to a PivotTable. I am on OSX 10.8.5 running Excel 2008 without VB. The final goal is to convert column data fields to row data fields. tell application "Microsoft…
arkjoseph
  • 494
  • 9
  • 27
1
vote
3 answers

Find row number of next instance of specific value

I have a column of days of the week in an Excel 2008 spreadsheet. In another column, I want to execute code that involves the Friday in the current row and its following Friday further down in the column. The problem is, it's five years of data…
Jordan Fine
  • 57
  • 5
1
vote
1 answer

Excel VBA not working on Mac

I have written some code in Excel 2007 and tried to run it on a Mac with Excel 2008. The procedure is linked to a control button on the sheet, and there was a similar discussion going on here: Excel vba to mac However, in my case this does not seem…
Matthias
  • 123
  • 2
  • 7
  • 19
1
2 3