[dev] Re: Implementation of Row Exchange Button in Calc
Am 17.06.2011 17:38, tora - Takamichi Akiyama wrote: On 2011/06/17 16:38, Martin Hediger wrote: Its true, i havent thought of the implications of what it means to switch rows. Should references pointing to cell A1 remain pointing to A1, when the content of A1 is traded for the content of B1? What should the references follow? But apart from that, the way to exchange two rows is I believe indeed achieved most easily by a combination of the insert_row(), move_row(), delete_row() methods. If you want to swap the contents of two rows or columns but you do not want to change their references, it might be a set of 1. insert_row as a temporal space, 2. COPY_row 1 to the temporal space, 3. COPY_row from 2 to 1, 4. COPY_row from the temporal row to 2, 5. and delete_row the temporal space. Select the cell range, row or column. Drag the cell selection (not the column/row header). Hold the Alt key before you drop. -- - To unsubscribe send email to dev-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[dev] Re: [dba-dev] OOo Base further development
Am 14.01.2011 10:15, Ocke Janssen wrote: PS: Somebody (volunteering) interested in developing Java for wizards in Base (e.g. Form, Query, Table or Report)? Based on which API? You mean api.openoffice.org? No thanks! I'm done with it. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
[dev] Re: Localization error in US date convetsion
Am 17.01.2011 13:25, Eike Rathke wrote: This is about locale dependent program logic, I think it's the developers' job. However, for locale specific topics there's the d...@l10n.openoffice.org mailing list. Eike OK. We use English month names with spaces and month numbers with slashes, except for march3/7(UK and US) and 3march/7(UK). Input evaluation is a bit confusing sometimes. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
[dev] Localization error in US date convetsion
Hello, After 7 years of bug submission I still don't get familiar with that awful bug tracker. In a spreadsheet with global English(US) locale setting =VALUE(March/8/2010) fails but =VALUE(March8/2010) succeeds. With English(UK) the following strings fail to convert: 8/March/2010 8March/2010 March/8/2010 however March8/2010 does. This conversion error affects the Basic language too and possibly other components. Why is there no language group for the English locale? Do the developers do this job? Greetings, Andreas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
[dev] Re: Localization error in US date convetsion
Sorry, I use 3.3RC8 and 2.4.1 on Linux and I find the same error in both versions. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
[dev] Re: Importing Filter fixes from Symphony
Am 30.11.2010 16:44, MOULIN Camille wrote: Dear OOo Devs, During random tests with IBM's Symphony, I realized that three of the most annoying bugs in Calc's filters were actually fixed there. Issue 89232 Fill operations should not touch filtered rows. Issue 12666 autofilter works just on one sheet (only one auto-range per file) Autofilter can even work with more than one list range on the same sheet. Just invest the little extra effort to define your list ranges (DataDefine...) Issue 85305 Dynamically grow a filtered range for autofilter I know that Symphony is not an open source project, but do you think it would be possible to have those fixes upstreamed to OOo ? Like with any other spreadsheet on the market, insertion/deletion of rows will update all references to the affected range. This will grow/shrink your data ranges, all formulas refering to your data ranges, external references, conditional formatting, validation, form controls and chart ranges. As a matter of course, the database component is more adequate to work with row sets. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
[dev] Re: spreadsheet with database instead of file
Am 07.11.2010 23:14, Fons, Michael wrote: Thanks, Andreas Saeger, for your speedy reply! Where can I read more about attaching input forms to sheets? Again I appreciate your advice. On Sat, Nov 6, 2010 at 6:39 PM, Andreas Sägerville...@t-online.de wrote: Am 06.11.2010 23:22, Fons, Michael wrote: Hi. I am new here. For security issues, my boss would like me to alter some open source spreadsheet program, such that if a user of this modified spreadsheet program were to create and save a spreadsheet, it would save its contents to some database tables instead of a file. We would want to dictate what information got saved to the database, in what format, to what tables, etc. Basically the end-user wants the same spreadsheet front-end they are used to, but we need to change where it saves. Is there such an extension of OpenOffice already? If not then how do I find out what sections of the OpenOffice source apply to the spreadsheet package within OpenOffice? Thank you for your time. I am in the process of reading *OpenOffice.org Building Guide* Michael Fons 720-837-7830 You do not need any extension. You can attach input forms to sheets, bind them to a database and pull data from the database back into the spreadsheet. To some extent this works without a single line of macro code. What you can NOT do: Write arbitrary data into spreadsheet cells and expect them to appear somewhere in the database. Only forms with form controls are designed to work with row sets. Spreadsheets have no row sets. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org FileNewDatabase... [X]Connect to existing db Establish a connection to your db and add forms (embedded Writer documents) Forms can be added to any stand-alone document as well: ViewToolbarsForm Design Button #5 shows the forms hierarchy where you can add forms and subforms with form controls (ViewToolbarsForm Controls]. This works with many databases you have a driver for and with all ODF documents. [Database] - [Server] - [Client,J/ODBC] - [Base document] - [Office document] - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
[dev] Re: spreadsheet with database instead of file
See also: http://user.services.openoffice.org/en/forum/viewtopic.php?f=9t=35635p=163397#p163397 - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
[dev] Re: spreadsheet with database instead of file
Am 06.11.2010 23:22, Fons, Michael wrote: Hi. I am new here. For security issues, my boss would like me to alter some open source spreadsheet program, such that if a user of this modified spreadsheet program were to create and save a spreadsheet, it would save its contents to some database tables instead of a file. We would want to dictate what information got saved to the database, in what format, to what tables, etc. Basically the end-user wants the same spreadsheet front-end they are used to, but we need to change where it saves. Is there such an extension of OpenOffice already? If not then how do I find out what sections of the OpenOffice source apply to the spreadsheet package within OpenOffice? Thank you for your time. I am in the process of reading *OpenOffice.org Building Guide* Michael Fons 720-837-7830 You do not need any extension. You can attach input forms to sheets, bind them to a database and pull data from the database back into the spreadsheet. To some extent this works without a single line of macro code. What you can NOT do: Write arbitrary data into spreadsheet cells and expect them to appear somewhere in the database. Only forms with form controls are designed to work with row sets. Spreadsheets have no row sets. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
[dev] Old Python extension fails to install since 3.3 beta
This extension: http://sourceforge.net/projects/ooomacros/files/SpecialCells/ used to work with Python from version 1.1.4 until 3.2.1 Now the installation fails with error: (com.sun.star.uno.RundtimeException){ { Message = bad root element node in file:///home/andreas/openoffice.org/3/user/uno_packages/.../SpecialCells.0.7.1.oxt/registry/Addons.xcu, Context = (com.sun.star.uno.XInterface) @0 } } The rejected Addons.xcu starts like this: ?xml version='1.0' encoding='UTF-8'? oor:node xmlns:oor=http://openoffice.org/2001/registry; xmlns:xs=http://www.w3.org/2001/XMLSchema; oor:name=Addons oor:package=org.openoffice.Office node oor:name=AddonUI node oor:name=AddonMenu node oor:name=name.AndreasSaeger.SpecialCells oor:op=replace Any thoughts? Thank you in advance, Andreas Säger - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
[dev] Re: Old Python extension fails to install since 3.3 beta
Am 26.10.2010 01:56, Christian Lohmaier wrote: ?xml version='1.0' encoding='UTF-8'? oor:node xmlns:oor=http://openoffice.org/2001/registry; shouldn't that be oor:component-data? ciao Christian makes no difference. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
[dev] Re: Old Python extension fails to install since 3.3 beta
Am 26.10.2010 02:49, Andreas Säger wrote: Am 26.10.2010 01:56, Christian Lohmaier wrote: ?xml version='1.0' encoding='UTF-8'? oor:node xmlns:oor=http://openoffice.org/2001/registry; shouldn't that be oor:component-data? ciao Christian makes no difference. Thank you Christian. Indeed it makes some difference (after I modified the closing tag as well). Now it installs but does not start up. So there might be some other wrong tag. Some day I may study how to build modern extensions. Bye, Andreas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org