Re: [libreoffice-users] Re: macro pasting text instead of formula

Well - this is why I came to the list - I'm not a developer by trade,
this is a hobby and just a single macro I'm working on. I don't have the
time to read hundreds of pages of documentation for a hobby as I do in
fact have a trade, and it eats up almost all of my time.

I'll try to figure out what you mean by what you said - worst case I'll
just give up the macro and stick with the limited abilities of kmymoney
to do graphs and what not.

Joel

On 12/10/2014 12:33 PM, Andreas Säger wrote:
> Am 10.12.2014 um 18:23 schrieb Joel Madero:
> > I literally have no clue where those are coming from. They should be:
> This is because you hack upon something you do not understand.
> 1) First of all you need to understand (almost) each and every aspect of
> the spreadsheet component. Otherwise there is nothing to be programmed.
> 2) Then you need to be a fairly competent programmer in order to
> comprehend this extraordinary complex office API.
> 3) You need to install an object inspector in order to find all methods
> and properties you need.
>
> Again, you set the (pseudo-)property String of a cell. Instead you
> should set the cells Formula (pseudo-)property.
> Regarding your second question: Spreadsheets do not know any "date
> values". All values are doubles unless they are text. Dates, times,
> booleans, currencies, percent are just formatted doubles.
> Strings representing US-dates (M/D/Y) do not serve any purpose.
> A cell object has a string, a value and a formula at the same time. The
> number format has absolutely nothing to do with it.


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted