Excel formatting

[Ben Butler]

Hi Andy,

It is not an answer to your question. But.. I would consider driving Excel
with Python, and invoke Python from Omnis and storing shared data in Mysql
or similar DB.

A thought...

Ben

On Wed, 7 Oct 2020, 23:53 Andy Hilton, <andyh at totallybrilliant.com> wrote:

> Using the excel object LibXL I am trying to apply formatting to columns….
>
> Not of itself that huge a deal - I create a Format object and apply a
> number format like so :
>
> Calculate Format.$numformat as kXLNumFormatNumber_d2
>
>
> Of itself all good - that can get applied to cells and life is good….
>
> However my base code is still at $5.1 without the excel object - so adding
> the code in to my base library gives me an error on finding the constant
> kXLNumFormatNumber_d2
>
> Looking at the constant it shows that this relates to a value of 3 - fair
> enough so in my base I save it as
>
> Calculate Format.$numformat as 3
>
> However running this (back on $10) produces a different result for the
> number formatting - using the actual  kXLNumFormatNumber_d2  numbers come
> out like : 4586.31
>
> But if the code uses just the $numformat as 3 - then that same number
> comes out displayed as 4586 (no decimals) - the value held in the cell is
> correct it is simply the formatting that changes
>
> Does anyone know why there is a difference between using the ‘k’ constant
> and using a straight integer value ??? Its driving me mad :)
>
> Andy Hilton
> Totally Brilliant Software Inc
> Phone (US) : (863) 409 4870
> Phone (UK) : 0207 193 8582
> Web : www.totallybrilliant.com <http://www.totallybrilliant.com/>
> Helpdesk : http://totallybrilliant.kayako.com
> Email : andyh at totallybrilliant.com
>
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
>