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.
Questions tagged [excel-2008]
35 questions
1
vote
1 answer
Axis title setting
How to apply a vertical axis title as rotated title, Horizontal title, vertical title in Excel 2008 using AppleScript.
tell application "Microsoft Excel"
tell worksheet 1 of active workbook
set ochart to chart of chart object "chartname"
…
user1705318
- 77
- 1
- 13
0
votes
2 answers
Snow Leopard Automator: Trying to create a workflow for converting Excel Files
I was trying to learn the automator functions for Snow Leopard. I googled around how to use automator to create a workflow for exporting Excel documents to CSV files. I got some hits with demonstrations showing this procedure on Leopard. However,…
banditKing
- 9,405
- 28
- 100
- 157
0
votes
1 answer
Can't get the find command in Excel 2008 to work
I want to use AppleScript to find a TAG cell I put next to sets of data, so that I can then link to those values on a separate results sheet.
At the moment all I get is errors telling me that this, that and the other doesn't understand find. Here's…
Priesto
- 61
- 7
0
votes
4 answers
Find name of the last cell with data in a row
I've searched for an answer, but it seems that I can only find VBA-based solutions, which appear no longer be an option in Excel 2008.
I'm trying to return the name of the last cell in a row that contains data. It looks like…
KumbaThought
- 183
- 2
- 3
- 10
0
votes
1 answer
Excel - Match 2 columns and paste result from appending cell
From the table below, I want to match 'COLUMN A' and 'COLUMN C', when the match happens, the value from 'COLUMN D' should be pasted in 'COLUMN B'.
Column A Column B Column C Column D
AB FAST AE APPLE
CD …
Tanmay
- 1
0
votes
3 answers
Number value as text
I have a single cell with the value:
426,427,433,439,442
This isn't a number, rather a list of numbers. If I try to add another number to the list, for example, 679. Excel changes the cell to read:
679,426,427,433,439,000
If I select the cell…
gardener
- 59
- 5
0
votes
0 answers
Correctly Copying Worksheets When "Chart Data Range Too Complex"?
MS-Excel 2008 on OSX Mavericks. I don't think the problem is very version- or platform-specific.
Make a simple chart on a worksheet.
Make a copy of the worksheet.
Note the new chart in the new worksheet refers to the new worksheet, as it…
Damian
- 1
0
votes
1 answer
Why does opening a CSV file in Excel break my Highcharts chart?
I'm working on using CSV files to create Highcharts – but running into an odd problem: when Excel 'touches' a CSV file, the chart breaks immediately. Here's the simplest example:
Highcharts online documentation has a handy example of a bar chart…
victorz
- 205
- 1
- 2
- 4
0
votes
3 answers
Writing a CSV file for Mac users with PHP
I use a generic algorithm to write CSV files that in theory works for the major OSes. However, the client started to use Mac a few weeks ago, and they keep telling me the CSV file cannot be read in Microsoft Excel 2008 for Mac 12.2.1.
They have…
Dan H
- 3,524
- 3
- 35
- 46
0
votes
1 answer
Trying to split the time and date Text To Columns but getting zeros
I'm trying to split my time and date (numbers) from one column into three columns but am getting zeros when attempting this by treating them as General format.
My time column: 14:22:13
My date column: 26/3/2013
When I select delimiter as ':' then…
user1574598
- 3,771
- 7
- 44
- 67
0
votes
1 answer
Block the Excel message "content that is not suported" using AppleScript
I have an Excel 2008 file. This give a warning message when opened. I would like this message not to be displayed.
tell application "Microsoft Excel"
open workbook workbook file name "private:var:root:Desktop:XLS FILES:Copy of
…
user1705318
- 77
- 1
- 13
0
votes
1 answer
Create hyperlink in Excel file using AppleScript
In Excel 2008 on Mac, I want to create a hyperlink on sheet 1 on cell "A8" using AppleScript in same Excel document.
user1705318
- 77
- 1
- 13
0
votes
1 answer
Set theme color of Format cell color
In Office 2008, how may I set the theme color in conditional formatting using AppleScript?
tell format color of color scale criterion 1 of colorcellObject
set theme color to first accent theme color
end tell
This script through errors (set theme…
user1705318
- 77
- 1
- 13
0
votes
1 answer
Is it possible to create a table made up of multiple what-if scenario results?
I'm going to describe my goal in steps because I think that might be the easiest way to explain it. This is what I'm trying to do:
1) Create a template that has various calculations on it. On this template, 1 specific cell is left blank. The…
KryptKeeper
- 125
- 2
- 6
- 16
-1
votes
1 answer
Multiply two columns by a scalar
I'd like to multiply the value of a given cell by a scalar and output the result to an adjacent cell. For example, if I had:
B C
1 25 ?
2 20 ?
3 21 ?
4 23 ?
I want the ? values in each C column to be 20 * (B in same…
mfonda
- 7,873
- 1
- 26
- 30