[dba-issues] [Issue 117021] Reports show zero instead of text

2011-02-19 Thread villeroy
Assigned to|dbaneedsconfirm Reported by|villeroy --- Additional comments from ville...@openoffice.org Sat Feb 19 12:49:10 + 2011 --- Drag the reports from the attached database into any of your native HSQLDBs. They do not show any information on tables, columns and indices

[dba-issues] [Issue 117021] Reports show zero instead of text

2011-02-19 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=117021 --- Additional comments from ville...@openoffice.org Sat Feb 19 12:52:44 + 2011 --- Created an attachment (id=75877) Empty HSQLDB with 2 ORB reports

[dba-issues] [Issue 117021] Reports show zero instead of text

2011-02-19 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=117021 --- Additional comments from ville...@openoffice.org Sat Feb 19 12:57:34 + 2011 --- Instead of copying the contained reports to one of your databases, you may

[framework-issues] [Issue 116934] Problematic module named CELL in Basic library Standard

2011-02-13 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=116934 User villeroy changed the following: What|Old value |New value

[framework-issues] [Issue 116934] Problematic module named CELL in Basic library Standard

2011-02-12 Thread villeroy
Subcomponent|scripting Assigned to|ab Reported by|villeroy --- Additional comments from ville...@openoffice.org Sat Feb 12 19:38:29 + 2011 --- Prepare a spreadsheet with this code: http://www.oooforum.org/forum/viewtopic.phtml?t=47340 Comment out

[sw-issues] [Issue 85105] ActualSize of com.sun.star.text.TextGraphicObject is not initialized if pic inserted programmatically.

2011-02-09 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85105 --- Additional comments from ville...@openoffice.org Wed Feb 9 15:42:40 + 2011 --- I revoke my vote for option A and vote for B now. I believe that mba is more

[graphics-issues] [Issue 116023] Microsoft patch breaks Im press/PowerPoint compatibility

2010-12-09 Thread villeroy
Subcomponent|save-export Assigned to|graphicsneedsconfirm Reported by|villeroy --- Additional comments from ville...@openoffice.org Thu Dec 9 19:45:06 + 2010 --- http://user.services.openoffice.org/en/forum/viewtopic.php?f=10t=36515

[dba-issues] [Issue 98163] Hard coded SQL in reports

2010-11-29 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=98163 --- Additional comments from ville...@openoffice.org Mon Nov 29 16:50:32 + 2010 --- Yes, I tried the report builder several times without much success. It's

[dba-issues] [Issue 115579] Crash when loading a quer y into graphic editor

2010-11-14 Thread villeroy
Assigned to|dbaneedsconfirm Reported by|villeroy --- Additional comments from ville...@openoffice.org Sun Nov 14 22:25:02 + 2010 --- Download http://user.services.openoffice.org/en/forum/download/file.php?id=9651 Open the query and the report. Both do work

[dba-issues] [Issue 115250] formatted control with da te is 2 days off

2010-10-26 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115250 --- Additional comments from ville...@openoffice.org Wed Oct 27 02:44:09 + 2010 --- The 2 day offset occurs when the formatted field has a userdefined date

[dba-issues] [Issue 115250] formatted control with da te is 2 days off

2010-10-25 Thread villeroy
Assigned to|dbaneedsconfirm Reported by|villeroy --- Additional comments from ville...@openoffice.org Tue Oct 26 00:22:23 + 2010 --- I bound a formatted control to a time stamp field because I wanted N/A rather than 1800-01-01 when the field is Null. The field

[dba-issues] [Issue 114304] Default not being set pro perly when creating a boolean field via SQL

2010-09-04 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114304 --- Additional comments from ville...@openoffice.org Sat Sep 4 19:38:59 + 2010 --- In this context I discovered that any field type except Boolean can be

[sc-issues] [Issue 114297] N(ref) returns #VALUE for text

2010-09-03 Thread villeroy
to|spreadsheet Reported by|villeroy --- Additional comments from ville...@openoffice.org Fri Sep 3 19:06:25 + 2010 --- IMHO it should return 0 for any text (even numeric text) and for #NA. Even if the ODF specification of N is somewhat unspecific, it should certainly

[sc-issues] [Issue 109726] Empty cell vs empty strin g in the spreadsheet driver

2010-06-15 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109726 --- Additional comments from ville...@openoffice.org Tue Jun 15 06:39:10 + 2010 --- First of all, I did not file an issue about spreadsheet formatting. The

[framework-issues] [Issue 110975] No Python macros

2010-04-18 Thread villeroy
Reported by|villeroy --- Additional comments from ville...@openoffice.org Sun Apr 18 21:06:38 + 2010 --- The preinstalled Python macros are not visible. User defined macros raise error The scripting language Python is not supported A Python add-on does run

[dba-issues] [Issue 110562] Text driver does not obey its own import settings

2010-04-02 Thread villeroy
Assigned to|dbaneedsconfirm Reported by|villeroy --- Additional comments from ville...@openoffice.org Fri Apr 2 10:05:30 + 2010 --- I think this is related to 70206 I've just read but let me put it this way: Connecting Base to a csv directory, you can

[dba-issues] [Issue 110562] Text driver does not obey its own import settings

2010-04-02 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110562 --- Additional comments from ville...@openoffice.org Fri Apr 2 10:09:51 + 2010 --- Even worse: Point 1 can be cured by switching to the US locale. I get all

[dba-issues] [Issue 109726] Empty cell vs empty strin g in the spreadsheet driver

2010-03-19 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109726 User villeroy changed the following: What|Old value |New value

[dba-issues] [Issue 110202] Fehler beim Schreiben des aktuellen Datensatzes

2010-03-19 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110202 --- Additional comments from ville...@openoffice.org Fri Mar 19 11:13:35 + 2010 --- This issue can not be processed as long as it is not reproducible. At least

[dba-issues] [Issue 109726] Empty cell vs empty strin g in the spreadsheet driver

2010-03-02 Thread villeroy
Subcomponent|none Assigned to|dbaneedsconfirm Reported by|villeroy --- Additional comments from ville...@openoffice.org Tue Mar 2 08:35:43 + 2010 --- The spreadsheet driver imports empty cells as empty strings. A numeric column with gaps imports as numbers or dates

[dba-issues] [Issue 109549] No data available when ed iting filtered row set.

2010-02-25 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109549 User villeroy changed the following: What|Old value |New value

[dba-issues] [Issue 109549] No data availlable when e diting filtered row set.

2010-02-23 Thread villeroy
Assigned to|dbaneedsconfirm Reported by|villeroy --- Additional comments from ville...@openoffice.org Tue Feb 23 19:34:59 + 2010 --- May be related to fixed #108390 or not. http://user.services.openoffice.org/en/forum/viewtopic.php?f=39t=27903

[dba-issues] [Issue 108390] No data availlable for subform

2010-01-19 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108390 --- Additional comments from ville...@openoffice.org Tue Jan 19 10:34:54 + 2010 --- Marked as [issue] in the user forum:

[dba-issues] [Issue 108390] No data availlable for subform

2010-01-17 Thread villeroy
to|dbaneedsconfirm Reported by|villeroy --- Additional comments from ville...@openoffice.org Sun Jan 17 12:20:55 + 2010 --- Link to draft: http://user.services.openoffice.org/en/forum/download/file.php?id=6481 Try internal form New Invoice or the same form

[dba-issues] [Issue 108390] No data availlable for subform

2010-01-17 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108390 --- Additional comments from ville...@openoffice.org Sun Jan 17 17:35:59 + 2010 --- I removed RC2 and reverted to v3.1.1 in order to test the above linked

[dba-issues] [Issue 104504] TimeField/FormattedField badly handle 24 hour time

2010-01-16 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104504 --- Additional comments from ville...@openoffice.org Sun Jan 17 07:56:21 + 2010 --- Work-around with a pattern field and the right field formatting:

[sc-issues] [Issue 108362] WEEKNUM(2010/4/1;1) ret urns 2 in English, 1 in other context

2010-01-15 Thread villeroy
Subcomponent|editing Assigned to|spreadsheet Reported by|villeroy --- Additional comments from ville...@openoffice.org Fri Jan 15 16:22:03 + 2010 --- WEEKNUM(DATE(2010;1;4);1) Number format WW with DATE(2010;1;4) TEXT(DATE(2010;1;4);WW) all

[sc-issues] [Issue 108362] WEEKNUM(2010/4/1;1) ret urns 2 in English, 1 in other context

2010-01-15 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108362 User villeroy changed the following: What|Old value |New value

[sc-issues] [Issue 108362] WEEKNUM(2010/4/1;1) ret urns 2 in English, 1 in other context

2010-01-15 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108362 --- Additional comments from ville...@openoffice.org Fri Jan 15 16:39:04 + 2010 --- Oh, Oh, Oh. Sorry it's NOT the WEEKNUM function, only TEXT and number

[dba-issues] [Issue 108229] Date/Time functions do no t work with parameters

2010-01-11 Thread villeroy
Assigned to|dbaneedsconfirm Reported by|villeroy --- Additional comments from ville...@openoffice.org Mon Jan 11 19:45:33 + 2010 --- SELECT * FROM X WHERE DAYOFWEEK( :paramDay )= X.WeekDay = wrong type Same problem with other date/time functions and :parameter

[sc-issues] [Issue 108198] OFFSET fails with externa l reference

2010-01-10 Thread villeroy
Assigned to|spreadsheet Reported by|villeroy --- Additional comments from ville...@openoffice.org Sun Jan 10 11:13:29 + 2010 --- =OFFSET('file:///tmp/source.ods'#$Sheet1.$A$1 ; $A$1-1 ; $B$1-1 ; 1 ; 1)=Err.504 http://user.services.openoffice.org/en/forum/viewtopic.php?f=9t

[dba-issues] [Issue 108199] Form control Replace W ith... List box should be drop down

2010-01-10 Thread villeroy
Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|villeroy --- Additional comments from ville...@openoffice.org Sun Jan 10 11:56:45 + 2010 --- All list boxes converted from some other control should have the drop down property

[sc-issues] [Issue 108198] OFFSET fails with externa l reference

2010-01-10 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108198 --- Additional comments from ville...@openoffice.org Sun Jan 10 20:40:24 + 2010 --- issue 103331 is registered under subcomponent programming which is why I

[dba-issues] [Issue 107281] Time field with spinner a pparently not nullable

2009-11-29 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107281 --- Additional comments from ville...@openoffice.org Sun Nov 29 11:22:38 + 2009 --- Another example: http://www.mediafire.com/?fzmjwqdyxdm Open form

[dba-issues] [Issue 107281] Time field with spinner a pparently not nullable

2009-11-28 Thread villeroy
Assigned to|dbaneedsconfirm Reported by|villeroy --- Additional comments from ville...@openoffice.org Sat Nov 28 16:17:15 + 2009 --- A time field bound to a nullable table field with property Input required=No and a spin button refuses to stay empty when you

[dba-issues] [Issue 107281] Time field with spinner a pparently not nullable

2009-11-28 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107281 --- Additional comments from ville...@openoffice.org Sat Nov 28 16:19:20 + 2009 --- Created an attachment (id=66383) Form with various nullable controls bound

[dba-issues] [Issue 107281] Time field with spinner a pparently not nullable

2009-11-28 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107281 --- Additional comments from ville...@openoffice.org Sat Nov 28 22:29:26 + 2009 --- Indeed, now it works. I can't reproduce it anymore. Oh, wait a minute!

[dba-issues] [Issue 107251] filter proposal is empty when form is bound to query

2009-11-26 Thread villeroy
|none Assigned to|dbaneedsconfirm Reported by|villeroy --- Additional comments from ville...@openoffice.org Thu Nov 26 23:41:21 + 2009 --- Bind some form to some editable query and let one text box make filter proposals for the form based filter. The filter

[dba-issues] [Issue 107251] filter proposal is empty when form is bound to query

2009-11-26 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107251 --- Additional comments from ville...@openoffice.org Thu Nov 26 23:56:38 + 2009 --- Created an attachment (id=66368) Table, query with alias and 2 forms to be

[dba-issues] [Issue 107251] filter proposal is empty when form is bound to query

2009-11-26 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107251 --- Additional comments from ville...@openoffice.org Thu Nov 26 23:58:12 + 2009 --- The alias in the query seems to be the culprit.

[dba-issues] [Issue 107104] Subform binding fails wit h stamp field.

2009-11-21 Thread villeroy
Assigned to|dbaneedsconfirm Reported by|villeroy --- Additional comments from ville...@openoffice.org Sat Nov 21 22:54:07 + 2009 --- Refer to the attached database. - Form1 lets you add integers to a list with auto-ID and auto-stamp. - Form2 fails to show the running

[dba-issues] [Issue 107104] Subform binding fails wit h stamp field.

2009-11-21 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107104 --- Additional comments from ville...@openoffice.org Sat Nov 21 22:55:33 + 2009 --- Created an attachment (id=66232) List of integer values with running totals

[sc-issues] [Issue 106706] Linked cell of a check bo x can't be removed

2009-11-08 Thread villeroy
Assigned to|spreadsheet Reported by|villeroy --- Additional comments from ville...@openoffice.org Sun Nov 8 10:51:50 + 2009 --- Draw a check box on a sheet, set linked cell to some cell. Works as expected. However, in design mode you can change but not reset

[dba-issues] [Issue 103882] Clipboard import of float ing point numbers fails due to formatting

2009-10-22 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103882 --- Additional comments from ville...@openoffice.org Thu Oct 22 09:40:35 + 2009 --- I just read that http://qa.openoffice.org/issues/show_bug.cgi?id=104318 is

[dba-issues] [Issue 105989] ORDER BY FunctionResult w ith file based DB

2009-10-17 Thread villeroy
Assigned to|dbaneedsconfirm Reported by|villeroy --- Additional comments from ville...@openoffice.org Sat Oct 17 16:29:58 + 2009 --- Get a text database with a column of ISO-dates. SELECT YEAR( Date ) AS Year, QUARTER( Date ) AS Quarter, MONTH( Date ) AS Month

[dba-issues] [Issue 105959] Query designer corrupts v alid query

2009-10-16 Thread villeroy
Assigned to|dbaneedsconfirm Reported by|villeroy --- Additional comments from ville...@openoffice.org Fri Oct 16 11:50:22 + 2009 --- I'll attach a database with 2 queries. Open any of them in SQL view, close, then open in design view, do some null-edit(append space) in any

[dba-issues] [Issue 105959] Query designer corrupts v alid query

2009-10-16 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105959 --- Additional comments from ville...@openoffice.org Fri Oct 16 11:51:55 + 2009 --- Created an attachment (id=65401) DB with queries violated by the designer

[dba-issues] [Issue 105959] Query designer corrupts v alid query

2009-10-16 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105959 --- Additional comments from ville...@openoffice.org Fri Oct 16 12:18:14 + 2009 --- By the way: What is wrong with the V column in my form? It's a numeric

[dba-issues] [Issue 105801] The nice bug. Please, ext end.

2009-10-11 Thread villeroy
to|dbaneedsconfirm Reported by|villeroy --- Additional comments from ville...@openoffice.org Sun Oct 11 08:27:58 + 2009 --- Don't know how to classify this. It behaves as desired but not specified, in the wrong place though. In the attached HSQLDB table Data has

[dba-issues] [Issue 105801] The nice bug. Please, ext end.

2009-10-11 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105801 --- Additional comments from ville...@openoffice.org Sun Oct 11 08:29:27 + 2009 --- Created an attachment (id=65293) DB with ViewDeleteDupes

[dba-issues] [Issue 105691] Append data from sheet

2009-10-07 Thread villeroy
Assigned to|dbaneedsconfirm Reported by|villeroy --- Additional comments from ville...@openoffice.org Wed Oct 7 16:52:05 + 2009 --- Many people collect data in emailed spreadsheets and it is a quite common problem that OOo does not allow to merge tables or collect records

[sc-issues] [Issue 79240] Datapilot with datasource query and named or unnamed parameters malfunct ions

2009-10-07 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=79240 --- Additional comments from ville...@openoffice.org Wed Oct 7 17:20:38 + 2009 --- Base uses named parameters and they do work with data pilots. SELECT * FROM

[sc-issues] [Issue 105692] Dialog tab order for pilo ts from data source

2009-10-07 Thread villeroy
Assigned to|spreadsheet Reported by|villeroy --- Additional comments from ville...@openoffice.org Wed Oct 7 17:30:49 + 2009 --- DataPilotStart... [X] Registered data source Next Dialog prompts for: 1. Database where you specify the data source name 2. Data

[sc-issues] [Issue 105168] Import datasource columns

2009-09-18 Thread villeroy
to|spreadsheet Reported by|villeroy --- Additional comments from ville...@openoffice.org Fri Sep 18 07:42:31 + 2009 --- Currently you can drag almost anything from a database's grid view into a spreadsheet, except for columns. To import a set of columns you have

[sc-issues] [Issue 105168] Import datasource columns

2009-09-18 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105168 --- Additional comments from ville...@openoffice.org Fri Sep 18 07:45:08 + 2009 --- Oh, and for the linked import ranges to be created by column drop: I can

[sc-issues] [Issue 104586] Evaluation of array formu la fails

2009-08-28 Thread villeroy
Assigned to|spreadsheet Reported by|villeroy --- Additional comments from ville...@openoffice.org Fri Aug 28 11:31:39 + 2009 --- Don't know the specs. Could be a request for enhancment. You can enter or edit a formula, say =NOW() and while in edit mode F9 evaluates

[dba-issues] [Issue 103882] Clipboard import of float ing point numbers fails due to formatting

2009-07-29 Thread villeroy
Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|villeroy --- Additional comments from ville...@openoffice.org Wed Jul 29 17:13:33 + 2009 --- Formatted spreadsheet values (currency with comma locale) ... Value 63,18 € 77,30

[sc-issues] [Issue 103626] Function failure with new type of URL reference

2009-07-18 Thread villeroy
Assigned to|spreadsheet Reported by|villeroy --- Additional comments from ville...@openoffice.org Sat Jul 18 19:22:09 + 2009 --- =SUMIF('file://path/doc.ods'#SheetX.A1:A99;X1) = Err:504 I'd say this is a P2 issue if SUMIF is the only function where the new shit

[sc-issues] [Issue 102570] Extends the validation of values

2009-07-16 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102570 --- Additional comments from ville...@openoffice.org Thu Jul 16 22:48:32 + 2009 --- Pick a value from the validation list and calculate with

[sc-issues] [Issue 103598] Changing a link source do es not change modified status

2009-07-16 Thread villeroy
Assigned to|spreadsheet Reported by|villeroy --- Additional comments from ville...@openoffice.org Thu Jul 16 23:29:08 + 2009 --- Create a link, such as ='file:///path/doc_A.ods'#Sheet1.A1 Save. Call menu:EditLinks... and choose another file

[sc-issues] [Issue 103291] MATCH and VLOOKUP in unor dered mode fails with large numbers

2009-07-05 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103291 --- Additional comments from ville...@openoffice.org Sun Jul 5 10:08:35 + 2009 --- Created an attachment (id=63366) Values and matches

[sc-issues] [Issue 103291] MATCH and VLOOKUP in unor dered mode fails with large numbers

2009-07-02 Thread villeroy
Subcomponent|editing Assigned to|spreadsheet Reported by|villeroy --- Additional comments from ville...@openoffice.org Thu Jul 2 18:43:08 + 2009 --- 84202070001 1 =MATCH($A1;$A$1:$A$5;0) 84202070002 1 =MATCH($A2;$A$1:$A$5;0

[sc-issues] [Issue 103215] Misleading error message about too many rows rather than columns

2009-06-30 Thread villeroy
|P3 Subcomponent|save-export Assigned to|spreadsheet Reported by|villeroy --- Additional comments from ville...@openoffice.org Tue Jun 30 12:12:13 + 2009 --- Open a new spreadsheet. Put something in IW1 (column 257). Save as xls. Error

[sc-issues] [Issue 102778] Expand references when in serting rows/columns

2009-06-15 Thread villeroy
Assigned to|spreadsheet Reported by|villeroy --- Additional comments from ville...@openoffice.org Mon Jun 15 07:53:25 + 2009 --- Define a one-row db-range of column headers. Set the above mentioned general option. Insert a first new row below the new db-range

[sc-issues] [Issue 102778] Expand references when in serting rows/columns

2009-06-15 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102778 --- Additional comments from ville...@openoffice.org Mon Jun 15 17:11:09 + 2009 --- Yes, now it's clear why it has to be 2 columns at least. Otherwise

[sw-issues] [Issue 102573] Character style SourceCo de should not be localized

2009-06-06 Thread villeroy
|formatting Assigned to|writerneedsconfirm Reported by|villeroy --- Additional comments from ville...@openoffice.org Sat Jun 6 19:45:12 + 2009 --- I don't want typographic quotes not spell checking in source code nor in other forms of written art. Character

[sc-issues] [Issue 102084] Parallel referencing in c onditional formatting

2009-05-20 Thread villeroy
Assigned to|spreadsheet Reported by|villeroy --- Additional comments from ville...@openoffice.org Wed May 20 08:25:17 + 2009 --- I don't know how it is called, but there is a mechanism which fetches the parallel values from referenced vectors: C1 =$A$1:$A$99

[sc-issues] [Issue 102084] Parallel referencing in c onditional formatting

2009-05-20 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102084 --- Additional comments from ville...@openoffice.org Wed May 20 13:33:42 + 2009 --- Thank you for testing this and providing 2 valid work-arounds. Yes, named

[sc-issues] [Issue 101162] Resizing import range cor rupts adjacent array formulas

2009-04-17 Thread villeroy
|editing Assigned to|spreadsheet Reported by|villeroy --- Additional comments from ville...@openoffice.org Fri Apr 17 12:28:41 + 2009 --- There is a handy option to expand adjacent formula ranges to imported database ranges. I encountered a strange issue when I

[sc-issues] [Issue 101162] Resizing import range cor rupts adjacent array formulas

2009-04-17 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101162 --- Additional comments from ville...@openoffice.org Fri Apr 17 12:31:10 + 2009 --- Created an attachment (id=61639) Spreadsheet with db-range

[dba-issues] [Issue 96703] Form-subform relation fail s with direct SQL

2009-03-15 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96703 --- Additional comments from ville...@openoffice.org Sun Mar 15 23:02:19 + 2009 --- Thanks for the work-around. Direct SQL-queries are read-only too. So this

[dba-issues] [Issue 99704] Turn off mouse scroll in c ells

2009-03-09 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=99704 --- Additional comments from ville...@openoffice.org Mon Mar 9 14:14:40 + 2009 --- The work-around refers to a form control. IMHO, the main issue is that all

[sw-issues] [Issue 85105] ActualSize of com.sun.star .text.TextGraphicObject is not initialized if pic inserted programmatically.

2009-02-28 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85105 --- Additional comments from ville...@openoffice.org Sat Feb 28 10:44:59 + 2009 --- Option C could be a remark in the documentation that certain properties,

[sc-issues] [Issue 98856] Reference offsets in xls i mport

2009-02-03 Thread villeroy
to|spreadsheet Reported by|villeroy --- Additional comments from ville...@openoffice.org Wed Feb 4 05:24:13 + 2009 --- Please refer to http://user.services.openoffice.org/en/forum/viewtopic.php?f=9t=15083p=70421 and the file attached therein

[dba-issues] [Issue 98701] Creation of dBase index cr ashes the office

2009-02-01 Thread villeroy
Assigned to|dbaneedsconfirm Reported by|villeroy --- Additional comments from ville...@openoffice.org Sun Feb 1 13:55:56 + 2009 --- Open table biblio of Bibilography in edit mode. Call the index designer. Add unique index on field Identifier. Try to store the index

[dba-issues] [Issue 98162] Blind list box bound to bo olean field

2009-01-16 Thread villeroy
Assigned to|dbaneedsconfirm Reported by|villeroy --- Additional comments from ville...@openoffice.org Fri Jan 16 22:10:50 + 2009 --- List box bound to field bool of SELECT strLabel, bool FROM Foo does not show the current record's field value, although it can update

[dba-issues] [Issue 98162] Blind list box bound to bo olean field

2009-01-16 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=98162 --- Additional comments from ville...@openoffice.org Fri Jan 16 22:15:14 + 2009 --- Created an attachment (id=59439) Database form with list boxes, radio

[dba-issues] [Issue 98163] Hard coded SQL in reports

2009-01-16 Thread villeroy
to|dbaneedsconfirm Reported by|villeroy --- Additional comments from ville...@openoffice.org Fri Jan 16 23:38:39 + 2009 --- Open the Bibliography database and add a query SELECT Identifier FROM biblio WHERE Identifier = 'OOO00' Create a most simple report based

[sc-issues] [Issue 97019] Select Special (empty cell s, formulae, values etc)

2009-01-03 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97019 --- Additional comments from ville...@openoffice.org Sat Jan 3 22:04:10 + 2009 --- http://ooomacros.org/user.php#221020 Download, extract oxt, ToolsPackages...

[sc-issues] [Issue 97728] Named multi-ranges incompa tible between 2.x and 3.x

2009-01-03 Thread villeroy
Assigned to|spreadsheet Reported by|villeroy --- Additional comments from ville...@openoffice.org Sat Jan 3 22:11:24 + 2009 --- In version 2 $SheetX.$A$1;$SheetX.$C$1 is a valid reference for a named reference (Ctrl+F3). In version 3 only ($SheetX.$A$1

[dba-issues] [Issue 96995] Global script events in wr ong order

2008-12-07 Thread villeroy
Assigned to|dbaneedsconfirm Reported by|villeroy --- Additional comments from [EMAIL PROTECTED] Sun Dec 7 18:40:34 + 2008 --- These 3 macros ... ## START BASIC MACROS Sub EventOpened() msgbox ThisComponent.getURL(),48 ,LOADED End Sub

[sc-issues] [Issue 85540] Insert Link to External Data applies number formatting

2008-12-07 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85540 --- Additional comments from [EMAIL PROTECTED] Mon Dec 8 00:12:55 + 2008 --- Yes, as far as I understand 71997 it's similar. Let me add a very common example:

[util-issues] [Issue 96868] Regex to replace first wor d with optional white space

2008-12-03 Thread villeroy
Assigned to|mh Reported by|villeroy --- Additional comments from [EMAIL PROTECTED] Wed Dec 3 22:46:20 + 2008 --- ^[:space:]*[:alnum:]+[:space:]+ removes all words except for the last one when you replace with nothing. With some replace string the first

[dba-issues] [Issue 96703] Form-subform relation fail s with direct SQL

2008-11-29 Thread villeroy
Assigned to|dbaneedsconfirm Reported by|villeroy --- Additional comments from [EMAIL PROTECTED] Sat Nov 29 08:27:36 + 2008 --- Load any form with a subform and change the source type of either one to some unparsed SQL query. For instance, change (sub-) form's source

[dba-issues] [Issue 96703] Form-subform relation fail s with direct SQL

2008-11-29 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96703 --- Additional comments from [EMAIL PROTECTED] Sat Nov 29 19:21:32 + 2008 --- Open the form of the attached database. Jump from item to item and watch the

[dba-issues] [Issue 96703] Form-subform relation fail s with direct SQL

2008-11-29 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96703 --- Additional comments from [EMAIL PROTECTED] Sat Nov 29 19:24:01 + 2008 --- Created an attachment (id=58393) Form and subform bound to queries.

[dba-issues] [Issue 93145] Parameter queries ignore t ype VARCHAR_IGNORECASE

2008-11-24 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93145 User villeroy changed the following: What|Old value |New value

[framework-issues] [Issue 96455] Crash when replacing form control

2008-11-22 Thread villeroy
Reported by|villeroy --- Additional comments from [EMAIL PROTECTED] Sat Nov 22 13:38:55 + 2008 --- Draw a text box form control onto a database form or any other office document having a draw page, right-click the box Replace with Listbox ... Crash

[sc-issues] [Issue 96443] Impossible to fix lost dat abase range

2008-11-21 Thread villeroy
Assigned to|spreadsheet Reported by|villeroy --- Additional comments from [EMAIL PROTECTED] Fri Nov 21 23:05:37 + 2008 --- It's a long known issue that you can not un-filter a range when the unnamed database range moved to another place. With version 2 I could fix

[sc-issues] [Issue 96443] Impossible to fix lost dat abase range

2008-11-21 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96443 --- Additional comments from [EMAIL PROTECTED] Fri Nov 21 23:08:22 + 2008 --- Created an attachment (id=58212) Sheet with lost filter descriptor. Filter is

[dba-issues] [Issue 96256] Numeric field control can not increment by decimals

2008-11-16 Thread villeroy
Assigned to|dbaneedsconfirm Reported by|villeroy --- Additional comments from [EMAIL PROTECTED] Sun Nov 16 21:12:58 + 2008 --- There is no way to let a form control of type numeric field increment by quarters, tenths or any other decimal fraction although

[sc-issues] [Issue 21280] Automatic Insert (shift do wn or shift right) of cells, columns, or rows when cut, or copied, and pasted

2008-11-03 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=21280 --- Additional comments from [EMAIL PROTECTED] Mon Nov 3 20:16:06 + 2008 --- Seemingly the issue has been resolved in v3.0 but not in v2.4.2, whereas there is

[sc-issues] [Issue 94720] References do not reflect resizing database range

2008-10-06 Thread villeroy
Assigned to|spreadsheet Reported by|villeroy --- Additional comments from [EMAIL PROTECTED] Mon Oct 6 23:09:42 + 2008 --- Functions like =ROWS(dbRange) do not update when the database range resizes on refresh. Hard recalculation does not help. Re-entering gives

[sc-issues] [Issue 94720] References do not reflect resizing database range

2008-10-06 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=94720 --- Additional comments from [EMAIL PROTECTED] Mon Oct 6 23:11:21 + 2008 --- Created an attachment (id=57043) Spreadsheet with standard filter and target range

[api-issues] [Issue 94570] DataPilot.refresh() fails silently

2008-10-02 Thread villeroy
to|jsc Reported by|villeroy --- Additional comments from [EMAIL PROTECTED] Thu Oct 2 08:47:05 + 2008 --- The user interface allows you to copy a pilot by simply defining another destination cell in the wizard of the existing pilot. The result is a fully functional pilot

[api-issues] [Issue 94570] DataPilot.refresh() fails silently

2008-10-02 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=94570 --- Additional comments from [EMAIL PROTECTED] Thu Oct 2 08:50:47 + 2008 --- Created an attachment (id=56974) Demo spreadsheet with Basic macro

[dba-issues] [Issue 94507] DAY function missing for f ile based databases

2008-09-30 Thread villeroy
Assigned to|dbaneedsconfirm Reported by|villeroy --- Additional comments from [EMAIL PROTECTED] Tue Sep 30 21:02:18 + 2008 --- http://dba.openoffice.org/specifications/file_based_functions.html mentions YEAR, MONTH but DAY is missing. It would be very useful

[dba-issues] [Issue 94507] DAY function missing for f ile based databases

2008-09-30 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=94507 --- Additional comments from [EMAIL PROTECTED] Tue Sep 30 21:04:37 + 2008 --- It's not a documentation issue. I can use YEAR and MONTH without being able to

[dba-issues] [Issue 92294] changes to relation's upda te/delete mode lost after re-starting OOo

2008-09-22 Thread villeroy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92294 --- Additional comments from [EMAIL PROTECTED] Mon Sep 22 16:32:59 + 2008 --- After editing the properties of a relation (double-click the line, update|delete

[dba-issues] [Issue 93567] Create form in design view ...

2008-09-07 Thread villeroy
to|dbaneedsconfirm Reported by|villeroy --- Additional comments from [EMAIL PROTECTED] Sun Sep 7 14:45:20 + 2008 --- Trying to create a new form from scratch, I get a blank new Writer document. From toolbar FormDesign I call the forms navigator, add a new form

  1   2   3   >