small update

[Bill Cheeseman]

on 2004-09-04 10:31 PM, Adrian Smith at adrianslists at optusnet.com.au wrote:

> It might work with some fiddling but it doesn't seem to be
> straight-forward with multi-column outlines. For example, if I have
> column of figures (budget estimates) those numbers end up in the cell
> next to their text in Excel.  This means that for a multi-level
> outlines the numbers don't line up in Excel...

I see tabbing anomalies when exporting to Excel. Actually, I see this in the
exported tab-delimited file even when I open it in a text editor. I haven't
analyzed what's happening, but it seems as if the extra tabs come from the
way the outline is indented: every indentation step gets a tab, and every
column gets a tab, too. And maybe blank cells/columns aren't getting a tab
at all.

If I'm right about this, then you can either (a) control it by how you
indent and populate the outline, or (b) account for it by how you format and
write formulas for the Excel worksheet. I did the latter, and it worked
fine.

I don't know whether to think about this as a bug or a feature. If a
feature, documentation would be good.

--

Bill Cheeseman - wjcheeseman at earthlink.net
Quechee Software, Quechee, Vermont, USA
http://www.quecheesoftware.com

The AppleScript Sourcebook - http://www.AppleScriptSourcebook.com
Vermont Recipes - http://www.stepwise.com/Articles/VermontRecipes