Re: Is Apache Open Office good for sales tax service spreadsheets?
I'd use the database component of AOO, called Base. If you've used MS Access before, you shouldn't have a problem. If you're pretty tech savvy you can probably do a tutorial or two and get a good start. Failing that, I'd get someone who knows databases to walk you through them. T-Mobile. America’s First Nationwide 4G Network Gabrielle Becker becker_gabrie...@live.com wrote: hi, I am just looking for a simple spreadsheet program where I can keep track of who I charged what, plus what sales tax there was, plus address, time and invoice number.It needs to be searchable. Etc. Is Apache open office good for this type of use? I would be getting cash or checks so no need for keeping track of bank account or credit card numbers. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
How to convert SmartSuite97 Approach files to OpenOffice
I need some help. I was able to convert my 1-2-3 files to Open Office. How do I convert my Approach files ? Email : suzannare...@aol.com Suzanna Reiff suzannare...@aol.com
Re: AOO can't open .xlsx spreadsheet at Cornell site
2013/9/26 Dick Hoffman old...@ix.netcom.com On 9/25/2013 7:54 PM, Kay Schenk wrote: On Tue, Sep 24, 2013 at 2:58 PM, Dick Hoffman old...@ix.netcom.com wrote: I downloaded a fairly large spreadsheet from this location http://www.birds.cornell.edu/clementschecklist/download/http://www.birds.cornell.edu/**clementschecklist/download/ h**ttp://www.birds.cornell.edu/**clementschecklist/download/http://www.birds.cornell.edu/clementschecklist/download/ but when I try to open it with AOO the progress line shows about a quarter of it being loaded and then AOO stalls and I have to use the Task Manager to cancel soffice. This is using AOO 4.0 on a Windows XP Pro/SP3 system. Any suggestions as to what might be wrong will be appreciated. Dick Hoffman --** --**- To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org users-unsubscribe@**openoffice.apache.orgusers-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-help@openoffice.apache.org users-help@openoffice.**apache.org users-h...@openoffice.apache.org No suggestions and yes AOO 4.0.x has a problem with it. I downloaded it as well. I hope it doesn't contain personal data. If it does, I will delete it. On the other hand, if it doesn't, can we use it as an attachment to an issue? This would be helpful to troubleshoot this problem. Thanks. The spreadsheet at the Cornell site doesn't contain any personal data; it can be used for troubleshooting purposes, or any other. I've had various suggestions and received several remedies. To summarize: the .xlsx file can apparently be read in OO 3.1.1 (someone who was able to do so saved it as a .ods and sent it on to me); the .xlsx file apparently can be read in AOO 4.0.1 (someone who was able to do so offered to save it as a .ods and send it on to me); yes, the .csv file can be taken into AOO or Excel to create an equivalent spreadsheet but you lose the color coding that is in the .xlsx which helps when scrolling through the data and the references from the second sheet of the .xlsx file don't seem to be present in the .csv file. I now have a version of the Cornell file in .ods format that serves my purposes. Thanks to all of you for your comments and suggestions. What a great group of people you are! Dick Hoffman Cleveland Heights, OH Dick, it takes about ten seconds to launch this file in LibreOffice 4.1.1.2 on my machine running 64-bit Linux Mint 15 Henri
Re: Is Apache Open Office good for sales tax service spreadsheets?
I am writing a document on a Calc guide for accountants and financial people. Tools such as Validity, Goal Seek and formulas like vlookup can help you work with many of the things you need to be done. Validity: https://www.youtube.com/watch?v=N8YHWDTUshA http://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Validating_cell_contents Goal Seek: https://www.youtube.com/watch?v=26gc9n8ZHdU http://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Goal_seek On 9/29/13, James Plante jimpla...@me.com wrote: Depends on how much data you intend to acquire. For a small shop, using AOO would be feasible. But as Tom Goldie said below, a database should be employed if you're acquiring lots of data. Spreadsheets do well on small data sets, but beyond a certain point they get unwieldly, then become unusable. You've got only 65,534 rows (records) to work with in a spreadsheet; many more records are possible in a database. Regards, Jim Plante On Sep 29, 2013, at 6:51 AM, Gabrielle Becker becker_gabrie...@live.com wrote: hi, I am just looking for a simple spreadsheet program where I can keep track of who I charged what, plus what sales tax there was, plus address, time and invoice number.It needs to be searchable. Etc. Is Apache open office good for this type of use? I would be getting cash or checks so no need for keeping track of bank account or credit card numbers. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org -- Alexandro Colorado Apache OpenOffice Contributor http://www.openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: VLOOKUP vs Macros
=ADDRESS(1, 3, 1,, sheet1) returns SHEET1.$C$1 =INDIRECT(ADDRESS(1, 3, 1,, sheet1)) returns whatever is stored in the cell referenced by SHEET1.$C$1 On 09/28/2013 11:30 AM, John Meyer wrote: I have a spreadsheet with a number of worksheets. The first worksheet has the bonuses for employees in this format ID, Sales Agent, Sales For Date, Bonus for Date, Sales for Date(N), Bonus For Date (N). . . The rest of the spreadsheets are each named for the date of sales that they contain. They are in the same format as the column header for Sales For Date. I set up each row like this ID static, Agent name static, =COUNTIF(*staticdateworksheet*!ColumnWithIDFirstRow:ColumnWithIDNthRow,Firstcolumnrowiamin),BonusCalculation What I'd like to do is change that formula around to resolve the sheet name by the first row of the salescount ID (i.e. if It's 9-27-2013 it would pull up 9-27-2013, 9-28-2013, etc.). Is this possible? It's not a pressing issue, I'd just like to see if it could be done. Thanks. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Needed: more keyboard shortcuts! (Writer at least) - Mac OSX
Not only is there no keyboard shortcut to the menubar categories [File, Edit, View, Insert…] but there are no shortcuts for insert mark - and the insert menu item doesn't have a - to open a secondary menu for insert. I find I need line breaks and column breaks regularly in some of the stuff I'm writing. It's a PITA to have to use 4 (count them, 4) mouse clicks. The OK button (once you have selected the type of mark) isn't even responsive to the enter key:-( tnx -- Julian Thomas j...@jt-mj.net - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: OpenOffice and Zotero
Sounds nice. What kind of system do you use? Tom On 29. Sep 2013, at 01:36 , Keith N. McKenna keith.mcke...@comcast.net wrote: Tom Backer Johnsen wrote: As far as I can see from the Zotero page, no plugins for AOO documents are mentioned, only Word and LibreOffice are mentioned. That seems to be a change, I am sure that AOO used to be mentioned there as well. I am currently a user of AOO version 3.4.1 on a Mac with FireFox. As far as I can se, the plugin I included some months ago works fine with version 3 text files. So I will hang on to that version for a while. But what about upgrading to AOO version 4? Will I still be able to handle references in the new version? Or do I have to change to LibreOffice in order to be able to handle references in my documents? Tom Tom; I just installed the version 3.5.8 Zotero word processor integration into Apache OpenOffice 4.0.1 RC3 and it works like a charm. Regards Keith - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org Tom Backer Johnsen Søndre Steinkjellersmauet 7 5003 Bergen Mobil: +47 9169 3346 Email: backer(at)psych.uib.no - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: OpenOffice and Zotero
OK. I'll attempt to do just that. On the other hand, I am inclined to think that AOO would carry more weight than a pensioned academic. So, why not both AOO and me? Tom On 29. Sep 2013, at 21:45 , Alexandro Colorado j...@oooes.org wrote: I think as a costumer of zotero you would be more proper to suggest that. On 9/29/13, Tom Backer Johnsen bac...@psych.uib.no wrote: Yes, you are right. On the other hand, neither OpenOffice or version 4 is mentioned on the first page for the plugins. Perhaps the Zotero people could be persuaded to be more explicit? Tom On 29. Sep 2013, at 24:19 , johnny smith ka...@krovatka.su wrote: On Sat, 28 Sep 2013 22:00:03 -, Tom Backer Johnsen bac...@psych.uib.no wrote: As far as I can see from the Zotero page, no plugins for AOO documents are mentioned, only Word and LibreOffice are mentioned. That seems to be a change, I am sure that AOO used to be mentioned there as well. description of the libreoffice plugin reads as follows: The latest version of the LibreOffice plugin for Zotero 3.0+ is 3.5.8 (compatible with all versions of LibreOffice, all versions of Apache OpenOffice, and OpenOffice.org 3.0-3.3.x). it is thus expected to be 'compatible with [...] all versions of apache openoffice'. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org -- Alexandro Colorado Apache OpenOffice Contributor http://www.openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org Tom Backer Johnsen Søndre Steinkjellersmauet 7 5003 Bergen Mobil: +47 9169 3346 Email: backer(at)psych.uib.no - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: How to convert SmartSuite97 Approach files to OpenOffice
who can help me to Unsubscribe this Massige? 发自我的小米手机 Suzanna Reiff suzannare...@aol.com编写: I need some help. I was able to convert my 1-2-3 files to Open Office. How do I convert my Approach files ? Email : suzannare...@aol.com Suzanna Reiff suzannare...@aol.com