[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? http://www.libreoffice.or

[libreoffice-users] [Twitter] Opening a new user support channel

2014-12-10 Thread Charles-H. Schulz
Hello everyone, As you know we provide several options when it comes to users support. There is: - the mailing lists (this one is in English but others exist for other languages) - the forum that is really the Nabble interface to the mailing list - the ask.libreoffice.org website - IRC channel

Re: [libreoffice-users] [Twitter] Opening a new user support channel

2014-12-10 Thread dave boland
Charles, May I ask what is wrong with a traditional news group? They work very well, don't clog my e-mail (like this does), and are used by some open source projects like Mozilla. Seems like a news group would have been the best choice for support. As for Twitter, Facebook, etc., forget it - no

Re: [libreoffice-users] [Twitter] Opening a new user support channel

2014-12-10 Thread Tom Davies
Hi :) I think GMane is a way of viewing the posts to this mailing list as though it was a traditional (fairly trad anyway) News Group. Similar to the idea of viewing the posts through Nabble to make it look like a forum. Quite a clever system imo, keeps 2-3 quite divergent different ways of handl

Re: [libreoffice-users] [Twitter] Opening a new user support channel

2014-12-10 Thread Gordon Burgess-Parker
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/12/14 15:27, dave boland wrote: > Charles, > > May I ask what is wrong with a traditional news group? They work > very well, They /did/ work very well. I shouldn't think that anyone under the age of (say) 30 really knows what NNTP is, far less

Re: [libreoffice-users] [Twitter] Opening a new user support channel

2014-12-10 Thread Gordon Burgess-Parker
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/12/14 15:27, dave boland wrote: > Charles, > > May I ask what is wrong with a traditional news group? They work > very well, They /did/ work very well. I shouldn't think that anyone under the age of (say) 30 really knows what NNTP is, far less

Re: [libreoffice-users] [Twitter] Opening a new user support channel

2014-12-10 Thread Charles-H. Schulz
Hello, Le 10.12.2014 16:58, Gordon Burgess-Parker a écrit : -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/12/14 15:27, dave boland wrote: Charles, May I ask what is wrong with a traditional news group? They work very well, They /did/ work very well. I shouldn't think that anyone unde

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: https://drive.google.com/file/d/0B5S-XtOUGGH5UmpBdn

[libreoffice-users] Landscape & Portriat in same LO document

2014-12-10 Thread cement_head
Hi, Using Ubuntu 12.04.4 LTS AMD64 and LibreOffice 4.3.4.1 Trying to print both a landscape and portrait page in a single Writer document. Using Manual Section Breaks. When I get to the Landscape page, it prints properly, but I cannot return to Portrait. I think this is a bug.- CH -- View

Re: [libreoffice-users] Landscape & Portriat in same LO document

2014-12-10 Thread Kevin O'Brien
Are you using Page styles for each of these types of pages? Thanks, On Wed, Dec 10, 2014 at 1:55 PM, cement_head wrote: > Hi, Using Ubuntu 12.04.4 LTS AMD64 and LibreOffice 4.3.4.1 Trying to print > both a landscape and portrait page in a single Writer document. Using > Manual Section Brea

[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 what

Re: [libreoffice-users] Landscape & Portrait in same LO document

2014-12-10 Thread Brian Barker
At 11:55 10/12/2014 -0700, Nobody Noname wrote: Using Ubuntu 12.04.4 LTS AMD64 and LibreOffice 4.3.4.1. Trying to print both a landscape and portrait page in a single Writer document. Using Manual Section Breaks. When I get to the Landscape page, it prints properly, but I cannot return to Portr

[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? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubsc

[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. > https://docs.kde.org/

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 kno

[libreoffice-users] Re: Landscape & Portrait in same LO document

2014-12-10 Thread cement_head
ok, Manual Break is the term in Writer (i.e. insert Manual Break). Print Preview works perfectly, and I'm doing this correctly, it's not my technique. However, when I actually print, it doesnt revert. So, there's either a bug in Writer, in CUPS, or in the Printer Driver. I'm thinking it's in Wr

[libreoffice-users] Re: Landscape & Portriat in same LO document

2014-12-10 Thread cement_head
Yes, page styles. -- View this message in context: http://nabble.documentfoundation.org/Landscape-Portriat-in-same-LO-document-tp4132156p4132177.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://

[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 a

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: https://dr

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 po

[libreoffice-users] FrameMaker file conversion

2014-12-10 Thread MR ZenWiz
Is there any way that LO handles conversion of FrameMaker files into .odt files? I have a bunch of old (FM 4) FM files that I'd like to convert, but I don't see an option in LO Writer for this. Alternatively, I have all of them also in .ps format, but if I use ps2pdf to convert them, the format i

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 was

Re: [libreoffice-users] FrameMaker file conversion

2014-12-10 Thread M. Fioretti
On 2014-12-11 02:10, MR ZenWiz wrote: Is there any way that LO handles conversion of FrameMaker files into .odt files? I have a bunch of old (FM 4) FM files that I'd like to convert, but I don't see an option in LO Writer for this. same problem here, and by a long time now: http://stop.zona-

Re: [libreoffice-users] Re: Landscape & Portrait in same LO document

2014-12-10 Thread Steve Edmonds
Hi. For me to get this to work I have to change the device to postscript. File>Print>Properties>device I don't know if it is a bug in LO or Cups or the OS. Steve On 2014-12-11 10:53, cement_head wrote: ok, Manual Break is the term in Writer (i.e. insert Manual Break). Print Preview works perfect