[libreoffice-users] Calc - detect landing on a particular cell.

2015-12-02 Thread Bill Gradwohl
t function, and I'm already relying heavily on event handling, but it only works on a modified cell. In this case, I'm not modifying A6 or A7, but I want to trigger an event that lets me know they have become the active cells. -- Bill Gradwohl -- To unsubscribe e-mail to: user

[libreoffice-users] Using PriorToReset event in Base form

2015-01-04 Thread Bill Gradwohl
the field is empty or somehow invalid until I touch the field and tinker with its last digit. If I set the last digit to 9, for example, a database row is stored with 01/04/2019 in it as expected. -- Bill Gradwohl -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http

Re: [libreoffice-users] LibreOffice / OpenOffice Calc very slow with Excel File

2011-09-25 Thread Bill Gradwohl
. -- Bill Gradwohl -- For unsubscribe instructions e-mail to: users+h...@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

[libreoffice-users] storeToURL fails until machine is rebooted.

2011-09-18 Thread Bill Gradwohl
Below are 2 routines that print a sheet to paper and then to a .pdf file. After the machine is started in the morning, and then for x number of transactions, these routines work as expected. At some point however, an error occurs at the line below that says:

Re: [libreoffice-users] Re: CALC - copy formula via macro

2011-09-04 Thread Bill Gradwohl
and validation. Thank you for both links. I was so intent on finding methods for formulas that I completely missed looking at the problem from the cell perspective. Thanks for waking me up. - -- Bill Gradwohl Roatan, Honduras -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment

Re: [libreoffice-users] CALC - copy formula via macro

2011-09-04 Thread Bill Gradwohl
() oRange = oDoc2.Sheets(0).getCellRangeByName(F1) oDoc2.CurrentController.select(oRange) oDoc2.CurrentController.insertTransferable(o) Andrew: I'm going to have to study this one. GetTransferable / insertTransferable - Never heard of them! - -- Bill Gradwohl Roatan, Honduras 504

[libreoffice-users] CALC - copy formula via macro

2011-09-02 Thread Bill Gradwohl
? I don't want to use the macro recorder/dispatcher - too ugly. -- Bill Gradwohl Roatan, Honduras -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

Re: [libreoffice-users] Re: Linking between two separate spreadsheets result in Err:509.

2011-08-31 Thread Bill Gradwohl
to. The second doc has the private data. This is useful when the primary doc uses a macro to generate the data for the second doc so the primary doc does NOT have a copy of the output of the macro. -- Bill Gradwohl Roatan, Honduras -- For unsubscribe instructions e-mail to: users+h

Re: [libreoffice-users] Re: Suggestions to PTB

2011-08-27 Thread Bill Gradwohl
a branch for profit, and get on with it or get out of the way. -- Bill Gradwohl Roatan, Honduras -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

Re: [libreoffice-users] Re: Search/Replace in Basic IDE

2011-08-16 Thread Bill Gradwohl
in OpenOffice on Fedora 14. Searching for a string and having nothing in the replace field causes the dialog to just search and do no replacements. - -- Bill Gradwohl Roatan, Honduras -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http

Re: [libreoffice-users] Calc will not save file after sheet deleted.

2011-08-11 Thread Bill Gradwohl
been reliable for years and that's a problem. - -- Bill Gradwohl Roatan, Honduras -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk5EEGMACgkQ7Orvev+eC8rvIACgly5u6U6eM9DeiCbJJ5++k8rf

Re: [libreoffice-users] Calc will not save file after sheet deleted.

2011-08-10 Thread Bill Gradwohl
Oracle lost interest in the office suite. Does LO provide a needed service? Yes it does, just as a Ford coasting down a highway provides a service. The difference is that if a Ford gas tank blew up periodically, Ford would fix it. - -- Bill Gradwohl Roatan, Honduras -BEGIN PGP SIGNATURE

Re: [libreoffice-users] Calc will not save file after sheet deleted.

2011-08-10 Thread Bill Gradwohl
seeing get fixed. A fix won't help me now, as I don't trust the .ods file contents. - -- Bill Gradwohl Roatan, Honduras -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk5CpyoACgkQ7Orvev

Re: [libreoffice-users] Calc will not save file after sheet deleted.

2011-08-09 Thread Bill Gradwohl
on a rusty chassis and are shocked, shocked when someone points out the rot. -- Bill Gradwohl Roatan, Honduras -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

[libreoffice-users] LO corruption

2011-08-04 Thread Bill Gradwohl
end. It's a Point of Sale system used in my wife's restaurant and she needs something more reliable than the LO version. - -- Bill Gradwohl Roatan, Honduras 504 9 899 2652 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http

Re: [libreoffice-users] LO corruption

2011-08-04 Thread Bill Gradwohl
and help in isolating and fixing them to the best of my ability. BTW - my internet connection is 16Kb/sec, when its up at all (Thank You TIGO/Honduras), so that is a tremendous limiting factor in what I can accomplish from here. - -- Bill Gradwohl Roatan, Honduras 504 9 899 2652 -BEGIN PGP

Re: [libreoffice-users] password problem

2011-08-04 Thread Bill Gradwohl
take my password, start to load, and then fail some seconds later on some internal error and puts up a bogus message. - -- Bill Gradwohl Roatan, Honduras 504 9 899 2652 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

Re: [libreoffice-users] Code snippet

2011-07-31 Thread Bill Gradwohl
in particular. That's why I had to ask for help, and you came through. Thank You. - -- Bill Gradwohl Roatan, Honduras 504 9 899 2652 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk41nKcACgkQ7Orvev

Re: [libreoffice-users] Code snippet

2011-07-31 Thread Bill Gradwohl
returned do have Control=Null via the debugger. Other than that, It's working fine. - -- Bill Gradwohl Roatan, Honduras 504 9 899 2652 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk413n8ACgkQ7Orvev

[libreoffice-users] Code snippet

2011-07-30 Thread Bill Gradwohl
, not on a sheet itself. - -- Bill Gradwohl Roatan, Honduras -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk40jisACgkQ7Orvev+eC8rGHQCgmq3OwAJmVey+UVF051lvj9nj agYAoIiZ3ZEl5074W6+CpTowdUxilfcl =U2Iw

[libreoffice-users] Shrinking buttons

2011-07-28 Thread Bill Gradwohl
as OpenOffice and Fedora 15 as LibreOffice. Both display the identical problem. I can supply additional details, as the whole story has some additional twists, but I'd like to know if this will be taken as a serious issue. - -- Bill Gradwohl Roatan, Honduras 504 9 899 2652 IM:billgradw...@gmail.com