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

2014-12-10 Thread Andreas Säger
Am 10.12.2014 um 03:04 schrieb Joel Madero: pasteSheet.getCellByPosition(1,pasteRow).String = pasteValue Well, you set the string of a cell. Set the formula instead. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

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

2014-12-10 Thread Joel Madero
Hi All, Well, you set the string of a cell. Set the formula instead. So I just started from scratch because I had a ton of if statements before, decided to go to switch to make it faster but I'm hitting the same type of problem. Document:

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

2014-12-10 Thread Andreas Säger
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

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

2014-12-10 Thread Joel Madero
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

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

2014-12-10 Thread Andreas Säger
Am 10.12.2014 um 21:43 schrieb Joel Madero: give up the macro and stick with the limited abilities of kmymoney to do graphs and what not. Amen! -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

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

2014-12-10 Thread Andreas Säger
Am 10.12.2014 um 21:43 schrieb Joel Madero: 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. At least we know know waht you are talking about.

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

2014-12-10 Thread Joel Madero
On 12/10/2014 01:54 PM, Andreas Säger wrote: Am 10.12.2014 um 21:43 schrieb Joel Madero: 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. At least we know know waht you

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

2014-12-10 Thread Andreas Säger
Am 10.12.2014 um 23:08 schrieb Joel Madero: I extracted the kmymoney file and the info in it seems to be incredibly conveluted, I'd be surprised if I could just bring it into base without additional problems. Perhaps I'm terribly wrong though. Terribly wrong, indeed. You do not bring

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

2014-12-10 Thread Andrew Douglas Pitonyak
On 12/10/2014 12:23 PM, Joel Madero wrote: Hi All, Well, you set the string of a cell. Set the formula instead. So I just started from scratch because I had a ton of if statements before, decided to go to switch to make it faster but I'm hitting the same type of problem. Document:

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

2014-12-10 Thread Joel Madero
Hey Andrew, First - thanks for giving explicit examples of where I went wrong :) I'll study your examples and learn for the future. Second - as for the switch, I was actually trying to conceptualize abstracting more and doing it per digit but I need to think about it a lot more. Thanks for the

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

2014-12-10 Thread Andrew Douglas Pitonyak
On 12/10/2014 07:13 PM, Joel Madero wrote: Hey Andrew, First - thanks for giving explicit examples of where I went wrong :) I'll study your examples and learn for the future. Sometimes you need to specifically spelled out, I get that and your welcome. Second - as for the switch, I