[libreoffice-users] Calc - detect landing on a particular cell.
I want to trigger an event when a particular cell becomes the active cell. Here's the situation: After entering a payment in a specific cell (say $10 in A5) and hitting enter, I'd like to programatically put the current time as hidden "userdata" in the cell immediately below it (A6) - the new active cell. I'd like to detect leaving that cell (A6) or entering the cell below (A7) without modifying the visible contents of A6 or A7. I want to use the elapsed time between the enter keystrokes to change the way the sheet reacts. $10 (enter) (immediate enter) Signals that the transaction is over and a macro sets up for the next transaction. $10 (enter) (wait a second) (enter) Signals the transaction isn't over and just sits there. The time difference between the double enter keystrokes determines what happens next. This spreadsheet has 6600 lines of macro code that makes it 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: users+unsubscr...@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
[libreoffice-users] Using PriorToReset event in Base form
Please correct me if I'm wrong, and if there's a better place to ask, let me know. It is my understanding (experimentally verified) that the PriorToReset event will fire when a new database row is produced for data entry. Inside this event, I can use the passed in event object to get the Form and from the form get at the elements of the form. I named my sub the same as the event it relates to. Sub PriorToReset(event) dim Form dim DateField Form=event.source DateField = Form.getByName(Date) Now I can drop a date into the Date field via : DateField.setPropertyValue(Text, 01/04/2015 ) That date shows up on the screen as though I had keyed it in by hand. Great so far. Once I fill out the remaining fields manually, and an attempt is made to send the data to the database, an error shows up asking to fill in the mandatory Date field. I'm looking at it filled in exactly as I want it, but somehow the system thinks it's not filled in. If I focus the date field and backspace over the last digit (5) and then re enter 5 and hit enter, and then attempt to save the record, it works. Why? Why can I see the date field filled in exactly as I want it, but somehow the system thinks 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://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
Re: [libreoffice-users] LibreOffice / OpenOffice Calc very slow with Excel File
On 09/25/2011 12:37 PM, Cor Nouws wrote: However, the file turns out to have 41472 empty (?) graphics on the second sheet ... Cor: This creation of objects is earily similar to the problems I encountered where I would have numerous hidden buttons on a spreadsheet that I never created. My document was created and used only under OO / LO, never Excel. Could the interpretation of the Excel document involve an internal conversion to LO xml and then a read of that xml to actually load the spreadsheet? I'm convinced the xml writing/reading is the source of many of the issues I've seen. -- 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/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] storeToURL fails until machine is rebooted.
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: thisComponent.storeToURL(pdfURL,args()) When I use the debug window to look at the fields being passes to the storeToURL, they are as expected. I have no idea why after a while the storeToURL fails and continues to fail until I reboot the machine. Getting out of LO does not work. I have to reboot the box to get it functioning again. After a reboot, the sheet that was to be printed and turned into a pdf again works as expected. Other executions work as expected until it stops working as expected some number of transactions later and I have no idea why. Because I have to bounce the box to correct this, I suspect the problem is in a loaded library that does not unload when LO is closed. Anyone have any insight? I think this is a real bug. sub receiptPrint(PrintOnPaper as boolean) dim printRange(0)as new com.sun.star.table.CellRangeAddress dim nullRange() as new com.sun.star.table.CellRangeAddress dim printOptions(1) as new com.sun.star.beans.PropertyValue dim doc as object dim sheetReceipt as object On Error goto errorRoutine doc = ThisComponent sheetReceipt=doc.sheets.getByName(Receipt) printOptions(0).Name=Wait printOptions(0).Value=True printOptions(1).Name=CopyCount printOptions(1).Value=1 printRange(0).sheet=sheetReceipt.RangeAddress.Sheet printRange(0).StartColumn=0 printRange(0).StartRow=0 printRange(0).EndColumn=9 printRange(0).EndRow=getEndRow(sheetReceipt) thisComponent.sheets(sheetReceipt.RangeAddress.Sheet).setPrintAreas(printRange()) if printOnPaper=True then thisComponent.Print(printOptions()) end if On error goto 0 printPDF(receipt) thisComponent.sheets(sheetReceipt.RangeAddress.Sheet).setPrintAreas(nullRange()) saveSpreadSheet() exit sub errorRoutine: dim message as string if Err0 then message=Error Number Err at line Erl chr$(10) Error() chr$(10) msgbox message,0,Error Occurred endif end sub ' receiptPrint sub printPDF(subDir as string) dim odsURL as string dim pdfURL as string dim strArray() as string dim x as integer DIM args(0) AS NEW com.sun.star.beans.PropertyValue 'exit sub odsURL=thisComponent.getURL() ' file:///bill/Desktop/WestEnd.ods ' Need file:///bill/Desktop/.pdf/YYMMDD/subDir/count#.pdf strArray=split(odsURL,/) for x=0 to ubound(strArray)-1 pdfURL=pdfURL strArray(x) / next x pdfURL=pdfURL .pdf if dir(pdfURL,16)= then mkdir pdfURL end if pdfURL=pdfURL / right(year(Date()),2) right(100 + month(Date()),2) right(100 + day(Date()),2) if dir(pdfURL,16)= then mkdir pdfURL end if pdfURL=pdfURL / subDir if dir(pdfURL,16)= then mkdir pdfURL end if pdfURL=pdfURL / x=1 while dir(pdfURL right(1000 + x,3) .pdf,16) x=x+1 wend pdfURL=pdfURL right(1000 + x,3) .pdf ' Save as PDF args(0).Name = FilterName args(0).Value = writer_pdf_Export thisComponent.storeToURL(pdfURL,args()) end sub -- 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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: CALC - copy formula via macro
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/03/2011 06:41 AM, Andreas Säger wrote: http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/XCellRangeMovement.html#copyRange provides the normal way to copypaste with all (conditional) formattings, relative/absolute references 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: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk5j61kACgkQ7Orvev+eC8r41gCggWjM5lHQO3KhP+xloyx48K1v UCEAoIzpt4azfLvHD7xjKWKCg6dshghw =U5JL -END PGP SIGNATURE- -- 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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] CALC - copy formula via macro
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/04/2011 07:38 PM, Andrew Douglas Pitonyak wrote: Dim o Dim oSheet Dim oRange Dim oDoc oRange = oDoc1.Sheets(0).getCellRangeByName(B2:C3) oDoc1.CurrentController.select(oRange) o = oDoc1.CurrentController.getTransferable() 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 9 899 2652 IM:billgradw...@gmail.com (No email please-IM only) -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk5kRz4ACgkQ7Orvev+eC8qdkQCgtdzPAwRSQPvV3OWOTY4EH4fI hWoAoJeBMO5zxfEbmnJZg9rTX1p0Mzgp =+R9E -END PGP SIGNATURE- -- 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/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] CALC - copy formula via macro
Assume: A1 contains the formula =SUM(B1:E1) I want to programatically copy A1's formula to somewhere else in column A that is determined at execution time, and I need the cell references adjusted accordingly. If it gets copied to A19, for example, I need the formula to read: =SUM(B19:E19) The getFormula and setFormula methods don't adjust the relative references - they get and set text. Is there a way to get the references adjusted auto-magically? Is there a method that can take the formula obtained via the getFormula and apply a row and column distance offset to the contents? 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://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
Re: [libreoffice-users] Re: Linking between two separate spreadsheets result in Err:509.
On 08/31/2011 05:53 AM, Andreas Säger wrote: The target document keeps a copy of the referenced data anyway, so why not store all the sheets in a single document? Because the primary doc may be used by an employee and that doc generates information the employee should have no access 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...@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
Re: [libreoffice-users] Re: Suggestions to PTB
On 08/27/2011 06:48 AM, Alexander Thurgood wrote: . However, where some of the bugs are very old, the investment needed to correct them is often perceived as greater than the benefit to be obtained, in fact greater even than rewriting the whole corresponding code module. As such large rewrites are more future oriented than bug catch-up, it is normal then for such bugs to be placed on standby, pending further new development. I might not like that any more than you (especially with respect to Base in my particular case), but I can understand it from both a human motivation and ressource allocation point of view. If Ford did to automobiles what you suggest is proper conduct for software development, Ford would be out of business. If during the normal course of using a product (Ford car), the brake pedal would periodically fall off for no apparent reason, consumers would be outraged, Ford would put a team on it and it would get corrected. I'm certain of it. I and many other people use OO/LO and periodically get file corruption rendering the document useless. I'd say that's roughly the equivalent of the brakes falling off a car. I've reported this for years and corruption issues persist with identical symptoms from one release to the next, from OO to LO. I can understand your position for nuisance items, but file corruption is the software having a brain aneurysm. It needs emergency attention right NOW. I'm a professional software developer (mainframes PC's) and I've managed software teams to produce products sold for hundreds of thousands of dollars per copy. The market incentive to produce a reliable product is what is missing in open source. No ones butt is on the line - no accountability. As the old saying goes, Lead, follow or get out of the way. LO has positioned itself as an alternative office suite. It has an obligation to produce a reliable product. Period. If that can't be achieved year after year, then the management of that project, or lack of it is at fault. Stop writing code. Get the project organized, possibly even create 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://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
Re: [libreoffice-users] Re: Search/Replace in Basic IDE
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/16/2011 12:44 PM, Johnny Rosenberg wrote: When I search for something and leave the Replace With field empty (meaning that I will replace something with nothing), replace will not take place. What you describe is also what I get 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://enigmail.mozdev.org/ iEYEARECAAYFAk5KwUMACgkQ7Orvev+eC8otvQCfTgNOakWvFJhNumE9WkNKh/VU mvgAnjvMfxc01SJSC50fxeIvANFlKE6h =sgpU -END PGP SIGNATURE- -- 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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc will not save file after sheet deleted.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/10/2011 05:23 PM, Simon Cropper wrote: It is obvious that you do not like OO or LO Calc, and that you don't like the fact that your data is continually corrupted. LO is a tool. I neither like or dislike it. As a tool, it has a major defect in that it periodically destroys the product which was built using it. You're right in that I don't like the tool I'm using to destroy my work. You also say you continuously have to rebuild your spreadsheet and that the process can take several days. Just spent 2 long days recreating the spreadsheet using 2 machines. Not fun. If you are so unhappy with the format, corruption and dirty code, my question is why do you persist? I've got a lot of investment in my macro code (9000 lines of it) that can only function within LO. I can't migrate it to something else as is. Had I known about the corruption when I started the project 6 years ago, I would have chosen a different platform. I would have never imagined that over the course of several years that corruption issues would be ignored. That's just inconceivable to me as a professional software developer, but that's apparently the reality. Change packages. Can't, as was mentioned above, unless I rewrite everything. Sad to say, LO is the only real competitor to MS Office and given its corruption history it will turn a lot of people off that might have moved away from MS Windows to Linux had the product been reliable. My real interest is in moving people away from a lousy operating system like Windows to something near bullet proof like Linux. We all need applications tools like word processing, spreadsheet, etc, so a tool like LO is vitally important to Linux adoption. If I could get MS Office compiled to run on Linux as a native application, I'd forget about LO in a heartbeat. MS Office is the best thing Microsoft has. It works well in its native environment. I wish I could say the same for LO, and that's why I'm critical of it. With the time and effort you have already put into recreating corrupted spreadsheets you could of written your own application or mastered alternative packages. I guess you don't write code for a living. I estimate a rewrite of my POS system would take well over a year of my time. While that's going on, I need something reliable to help run a business. I have sketched out a web based replacement much much more sophisticated than what I'm using now, and plan on developing it when I have the time. Wasting time reporting OO / LO bugs that never get taken seriously and recreating a spreadsheet periodically helps keeps me from such a new development effort. My wife (also a professional software developer) keeps telling me to stop wasting time reporting issues - that I'm tilting at windmills. She may be right. I am not trying to be rude here it just if I had a package that caused me so much wasted time I would just move on. I will move on in time, but in the interim, I'd like LO to thrive in the market, and that won't happen unless it becomes reliable. My problem is really with LO management. There isn't any. Despite what you may think, I'm more interested in LO's success than most people are, and I know it won't be successful long term unless its reliable. It hasn't 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 BpUAoIy9kOViLVFCssIwmN3BfCGnR+Dy =ct68 -END PGP SIGNATURE- -- 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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc will not save file after sheet deleted.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/10/2011 12:41 AM, Simon Cropper wrote: Unless someone recognised these symptoms and can put forward some ideas, I am treating this as a corrupt file. When LO can't read its own handwriting, so to speak, does that not prove LO has a serious problem? When you use only the tools provided by LO to manipulate your document and that document gets trashed due to corruption, does that not prove LO has a serious problem? Now that you've concluded that corruption has occurred, what do you think should happen to the software that did the corrupting? A: ) Should it get fixed? or B: ) Should it stay broken, and in return for not expending the effort to fix the underlying rot, you'll accept the next releases 3 new bells and 4 whistles? Check the archives and you'll note that file corruption is a frequent problem. Its as though giving buggy software the label file corruption absolves the developers of investigating and eliminating the underlying code bugs. I've been reporting corruption issues for years and in that time only one developer (with an oracle email address) ever showed any interest. Even he dropped off the radar when 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- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk5CkUsACgkQ7Orvev+eC8p1pQCeOXYJZ0Hxviu0Vx3FQrS1y0KY OPAAn1FA2iVoMjWyXvUwdLIuTaYVfAT6 =KOyQ -END PGP SIGNATURE- -- 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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc will not save file after sheet deleted.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/10/2011 08:24 AM, Tom Davies wrote: Hi :) Please post a new bug-report against LibreOffice rather than against OpenOffice. It stands a good chance of getting soem attention now. I already did: https://bugs.freedesktop.org/show_bug.cgi?id=39930 I'm in the process of once again rewriting my spreadsheet from scratch and importing my macro code into it. At least 2 days worth of tedious work. The bug report I submitted was to help someone else avoid my problems in the future should the underlying root cause of the corruption I'm 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+eC8rAvwCgs8vTIfZBzm7oljLl0U8yPRmK NqMAoMT9BNc7BctLOyye0ILePyYN2m5Y =UQsx -END PGP SIGNATURE- -- 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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc will not save file after sheet deleted.
On 08/09/2011 05:46 PM, Simon Cropper wrote: *Has anyone encountered or heard of a similar problem?* *Anyone got some ideas?* Check out the bug I just created at https://bugs.freedesktop.org/show_bug.cgi?id=39930 I've been fighting this corruption issue for YEARS and can't get anyone to look at it seriously. They keep coming out with new releases, but none of them ever solve these corruption problems. When LO saves a file and then can't reopen it successfully, it is LO's problem regardless of what an end user might have done. They keep putting a new coat of paint 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://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
[libreoffice-users] LO corruption
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 About a week ago, I asked this list for help and got what I needed to further investigate a situation I'm having with calc. I've now determined that my problems are due to corruption of the calc sheet. Further, I believe its calc itself that's doing it. Case in point. My buttons were shrinking randomly, but in a somewhat predictable fashion. Random as in I couldn't be certain when it would happen, but predictable in that when it happened it was done in a reasonably consistent way. Using code that Andrew supplied, I dumped the shapes on each involved sheet expecting 4 items. The first sheet had 1524 shapes of which 1520 had a control=null. The remaining 4 were my real buttons and were scattered among the debris. Common sense says I didn't manually create and somehow abandon 1520 shapes. I had absolutely no code that tried to create or manipulate the buttons, so Sherlock Holmes would deduce that OO / LO did it. I only used the IDE to create these 4 buttons on the first sheet and then copied them to 20 other sheets using cut and paste within the IDE. The remaining sheets all had far lesser amounts of rubbish, but not one sheet had only the 4 buttons it was intended to have. I wrote code to remove the dead ends. It worked like a charm. I saved and reacquired the spreadsheet and then all the buttons were gone on all 21 sheets. I repeated the process several times all resulting in the same outcome. I also wrote code to reinflate my shrunken buttons to their required size. Again, the code worked perfectly and I traversed each sheet to make certain all was well. After a save and restart of LO, I get a bogus password error part way through loading the spreadsheet and the whole thing won't load. The spreadsheet is not password protected, so where did a password come from? On a damaged but working spreadsheet (shrunken buttons), if I move a sheet from one position to another, or attempt to delete a sheet, all is well during that session, but a save and LO reload fails, again with some internal bogus password error half way through the loading process. When LO was OO, I tried repeatedly to have knowledgeable people look at this sheet as it has developed numerous anomalies over the 6 years I've been developing and using it. It is a laboratory full of LO issues that need to be addressed as to how these things could have happened, but I could never get anyone's attention. I'm a professional programmer (operating system internals) and can smell logic errors in the application. The main line works well, but I suspect that bugs exist in the more obscure portions of the code base. Lets face it, it takes computer power to create 1520 dead end objects and I didn't write any such code. Every few months I suck out my 9000 lines of macro code and redevelop the spreadsheet shell it fits within to get rid of the accumulated rubbish. There are almost no formulas anywhere, as I just use the sheet as a convenient GUI. My macros do all the work. Why did I write this email? It was therapeutic for me, and I hope someone in LO calc development will take me up on my offer to supply and help debug strange occurrences as they occur. Short of that, I'm going to have to rewrite this as a web app with a compiled back 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://enigmail.mozdev.org/ iEYEARECAAYFAk47TfAACgkQ7Orvev+eC8pm0QCePOi1W+ZdAK7S9OhcwVpKb2H8 qZIAoKfMAN7hJcKE5eOXXPAE5ZErf2LY =9UmO -END PGP SIGNATURE- -- 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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] LO corruption
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/04/2011 08:44 PM, Simon Cropper (The foss Workflow Guides) wrote: ... have you thought about code page errors? To answer your direct question - no I never considered code page errors. I'll check it out. Everything was developed on flavors of Fedora Linux starting on OpenOffice and now running on LO. I've blown this spreadsheet away numerous times over the years, keeping only my macros and a map of all the named cells I use as anchors. I wrote macros to reproduce the named ranges as I did that so often. I'd use one machine to bring up the old trashed spreadsheet and query it for cell widths, heights, colors, etc to reproduce the same sheet on another machine in a pristine environment. Add back my macros and go forward. That's a 2 day job of long tedious hours. Sometimes it would take months for something strange to start to happen, but it always does happen sooner or later. I'm not using any strange symbols. Its a simple POS system that accepts food orders, calculates costs, produces bills and receipts, does payroll, etc. Everything in it is mundane simple arithmetic and text. In the past, I hand massaged the xml files and pulled out huge sections of dead nested repetitive code. In one case I dropped the size of the .ods file by 110k worth of xml trash. I'm certain LO is not cleaning up after itself properly and leaving code droppings behind that cause this. I believe the IDE has some issues as it periodically does some strange things. On numerous occasions, I'd modify code in one module, switch to another module and make changes, save, reload and loose the first modules fixes. Infuriating! Am I supposed to remember to save for each module or should the IDE be smart enough to warn me I'm about to loose changes, or should it simply save everything when I say save? Something that trivial missing from the IDE says something. If you can insert a byte of data and cause LO to go berserk that only means it needs better insulation mechanisms to separate your data from its control codes. The developers should be thrilled to have you report finding a hole in their code so they can close it. If I as an end user can break it using only what was supplied to me to use, then the problem is in the LO product, and needs to be fixed. That's why I'm offering my help in supplying some pretty strange bugs 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 SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk47ZWsACgkQ7Orvev+eC8p7bwCeOR89xquRJhIYi5NJmGMm8uyq APIAnRdNKkvvv7qDqRfXVf/XBpULdaom =9NNM -END PGP SIGNATURE- -- 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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] password problem
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/04/2011 08:44 PM, Bob Stia wrote: I have a document that I have had for years. Time to time I must open it, edit it and close it again. It is Libreoffice password protected. A few days ago I opened the fdocument and then after editing closed it agaim. The other night I tried to open it again and the password failed. Bob Look at what happens carefully. Even experiment on another test doc to see a slight difference that may be significant. I've experienced password failures on password protected documents part way through the loading process after it successfully took my password and then manufactured a bogus password failure message a certain distance into the loading process. The password failure messages are different depending on if you really keyed in a wrong password or it pops up a bogus message. Create a test document, password protect it and then ATTEMPT to open it with a bad password. Is that the password message your real doc is getting or is it another one? The other one is a bogus message after the file's been corrupted. I noticed this on a large spreadsheet that takes quite a while to load. It would 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/ iEYEARECAAYFAk47aXAACgkQ7Orvev+eC8o8WwCdErYUa/D+UaQMXVCz6fhBx23d gkkAnAwrgPvGI5DvA4LzHSh6S7XlXCCC =L4Ox -END PGP SIGNATURE- -- 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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Code snippet
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/30/2011 10:57 PM, Andrew Douglas Pitonyak wrote: I expect that you need to set this from the sheets draw page Thank You Andrew. I have a copy of your book back in Texas. I wish I had it here on the island. I wrote most of the POS system we use in our restaurant by referencing your book. It's 9000 lines of macro code. I was up on your web site yesterday and noted that you're putting out a new edition. I tried wrapping my head around UNO several times and failed. I just don't get it. I've hit api.openoffice.org trying to make heads or tails out of what's there, but no joy. The API is an impenetrable collection of unrelated spare parts as far as I'm concerned, and I'm a professional programmer (IBM Mainframes Linux O/S utilities). I can't seem to get the right approach or frame of mind to understand the API set and UNO 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+eC8ouzgCg02jt9ON1ZahM4PoYQg83uHPj cosAninW5UjFnmRKHrlpKVqsGubBLjrB =tKaN -END PGP SIGNATURE- -- 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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Code snippet
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/31/2011 08:19 AM, Andrew Douglas Pitonyak wrote: If ashape.Control.Name = CName then Andrew FYI - I had to put an additional test in front of the above if statement as in: if not IsNull(aShape.Control) Some of the items 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+eC8p6wACghowvArWYqnDYmNIUnRVhWMEY 4H8An2fManqw04EYz2osfMiYhsvLVs5V =2N1t -END PGP SIGNATURE- -- 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/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Code snippet
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I've searched and can't figure out how to specify the height of a button at execution time via a basic macro. If Sheet1 contains a button name OK, how would I specify a button height of 0.5cm? The only examples I can find are for buttons on forms, 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 -END PGP SIGNATURE- -- 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/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Shrinking buttons
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have a spreadsheet containing 39 sheets, of which 21 are duplicates of one another. They represent tables in a restaurant. On an average laptop or desktop, everything is fine. When I load this up on a netbook with lousy resolution (1024x600), every time I save the file, the buttons on the 21 sheets get smaller and smaller till they some of them have a height of .06cm making them unusable. I leave the screen scaling at 100%. I manually went thru 10 of the sheets and using the forms control tool reset each button to its proper dimensions. Everything looked good as I went from sheet to sheet. I saved the file and brought it back up and the height that was .50cm is now .33cm or .31cm. Why they are different is a mystery. Another save and reload AND SOME OF THE BUTTONS are smaller still. I have no code that attempts to manipulate the buttons, so I conclude that LO is making the changes, and is making these changes permanent across saves. If I move the file back to my development laptop, its trashed. I understand scaling due to resolution issues, but rewriting my code permanently has got to be a bug. I tested this on Fedora 14 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 (No email please-IM only) -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk4xlOkACgkQ7Orvev+eC8pjqQCbBadkTrBEznB0UjH8OAM/qRAP 0mwAoLEXYNCs9dYHwuo4DZZDqqfI+WSm =0qkh -END PGP SIGNATURE- -- 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/users/ All messages sent to this list will be publicly archived and cannot be deleted