[Issue 125672] Error "index out of bounds"

[bugzilla]

https://bz.apache.org/ooo/show_bug.cgi?id=125672

Matthias Seidel  changed:

   What|Removed |Added

 CC||msei...@apache.org

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127352] New: hii

[bugzilla]

https://bz.apache.org/ooo/show_bug.cgi?id=127352

  Issue ID: 127352
Issue Type: DEFECT
   Summary: hii
   Product: App Dev
   Version: 4.1.2
  Hardware: PC
OS: Windows 10
Status: UNCONFIRMED
  Severity: Critical
  Priority: P5 (lowest)
 Component: sdk
  Assignee: issues@openoffice.apache.org
  Reporter: gnan5...@gmail.com
  Target Milestone: ---

hi testing

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127350] New: Table design: can't change length of Postgresql char types

[bugzilla]

https://bz.apache.org/ooo/show_bug.cgi?id=127350

  Issue ID: 127350
Issue Type: DEFECT
   Summary: Table design: can't change length of Postgresql char
types
   Product: Base
   Version: 4.2.0-dev
  Hardware: All
OS: All
Status: CONFIRMED
  Severity: Normal
  Priority: P5 (lowest)
 Component: code
  Assignee: issues@openoffice.apache.org
  Reporter: dam...@apache.org
  Target Milestone: ---

Connect to a Postgresql server using its JDBC driver and the usual URL of the
form "jdbc:postgresql://127.0.0.1/database".
In "Tables", "Create Table in Design View..."
Try create a column of type "Text [varchar]", and "Length" will be frozen at
10485760.
Try create a column of type "Text (fix) [char]", and "Length" won't even
appear.

Problem is the method OFieldDescControl::DisplayData() in
main/dbaccess/source/ui/control/FieldDescControl.cxx, which will deactivate the
tpTextLen if pFieldType->nPrecision is 0, which it is for "Text (fix) [char]",
and which will call pTextLen->SetSpecialReadOnly(true) when
pFieldType->aCreateParams.getLength() is 0, which it is for "Text [varchar]".

It is possible to hack this method, but that will affect all databases. We
should rather make a Postgresql driver under main/connectivity/source/drivers
that implements such fixes for Postgresql only (like we already have for
several other databases).

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127342] Doc-97 with a table in it: other text but table not shown, as docx table shown bt not the other text

[bugzilla]

https://bz.apache.org/ooo/show_bug.cgi?id=127342

UdoF  changed:

   What|Removed |Added

 Status|CLOSED  |UNCONFIRMED
 Resolution|NOT_AN_ISSUE|---

--- Comment #2 from UdoF  ---
A bit late my comment but:
With Word 2013 on opening the file, I see the table. Then I can change to
writing mode and nobody asks for a password, and then I can edit the table.
The file is not mine but from a friend asking herself wether she needs to buy
MS Word to work with such docs or can she have hope that a future version will
have the same behaviour as MS Word, for her it's professional use.
With OO writer I see only the text and on the frame that it's write protected,
  the table is invisible.
When I export with Word 2013 to docx, the OO writer shows the table, but not
the additional text.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 109652] CDateFromIso not working for all ISO dates

[bugzilla]

https://bz.apache.org/ooo/show_bug.cgi?id=109652

--- Comment #24 from D Denny  ---
Thanks!
Best regards
David

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are on the CC list for the issue.

[Issue 109652] CDateFromIso not working for all ISO dates

[bugzilla]

https://bz.apache.org/ooo/show_bug.cgi?id=109652

oooforum (fr)  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 Resolution|--- |NOT_AN_ISSUE

--- Comment #25 from oooforum (fr)  ---
As says in comment 1: the format must be 4 digits without dashes.
Conform as F1 help

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are on the CC list for the issue.

[Issue 127351] New: SQL UPDATE query fails in SQL View w/ Native SQL Mode enabled; whereas same query using Tools->SQL... succeeds.

[bugzilla]

https://bz.apache.org/ooo/show_bug.cgi?id=127351

  Issue ID: 127351
Issue Type: DEFECT
   Summary: SQL UPDATE query fails in SQL View w/ Native SQL Mode
enabled; whereas same query using Tools->SQL...
succeeds.
   Product: Base
   Version: 4.1.3
  Hardware: PC
OS: Linux 64-bit
Status: UNCONFIRMED
  Keywords: usability
  Severity: Normal
  Priority: P5 (lowest)
 Component: code
  Assignee: issues@openoffice.apache.org
  Reporter: dawkcod...@gmail.com
  Target Milestone: ---

To reproduce:
1.  Click Create Query in SQL View... to open SQL View of Query Designer.
2.  Enter simple UPDATE query code with correct syntax/values as below:

UPDATE `fu` SET `bar` = 'x'
WHERE `fu`.`Id` = 1;

3.  Click the SQL toolbar button to enable Native SQL Mode.
4.  Click the Run SQL toolbar button to execute the query.  Query fails to
execute.
5.  Alternatively, select Edit->"Run SQL command directly".  Query Fails to
execute.

However, I was able to verify and execute the same SQL UPDATE statement (as
above) successfully using the Tools->SQL... menu option (and bypassing the
Query Designer).

Note:  I see similar issues with Status "CLOSED FIXED"; however this problem
remains.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 109652] CDateFromIso not working for all ISO dates

[bugzilla]

https://bz.apache.org/ooo/show_bug.cgi?id=109652

--- Comment #22 from D Denny  ---
(In reply to mroe from comment #21)
> (In reply to D Denny from comment #20)
> > I have run separately your sample sub and proven to myself that
> > CDateFromISO() runs perfectly happily on its own.
> 

Firstly, thanks very much for your comprehensive help and careful attention!
Gratefully received.

> The simply question is:
> Which string you get from  
> columnFinalBudget = RowSet.getString(16)
> for dates > 2021-09-30?
> 

-MM-DD : example 2021-10-05


> If the column is defined as DATE you should better read the date rather the
> string representation. So your macro will be independent from any
> uncontrolled string conversion.

please see below **

> 
> AND: Please test your macro with
> Option Explicit
> and define your variables to get sure that there is not an unwanted
> conversion!
> Dim columnFinalBudget As String

Applied

**

changed .getString to getDate as

dim columnFinalBudget as date ' string
columnFinalBudget  
= RowSet.getDate(16) ' String(16)
print columnFinalBudget

resulting in

"Incorrect Property Value"

I think that because the date returned from the SQL VIEW is -MM-DD
it will be necessary to convert it another way, by string removing the "-"
separators. 

Or, I could change the VIEW result definition. Currently specified as DATE. 

So it appears (also re your comment below) that, while SQL is writing dates in
the format -MM-DD, Basic is expecting the format MMDD.

Maybe I should be trying getXXX first. I'll have a look at that.

[... Work In Progress, BRB ...]

> 
> 
> For the original reported bug I suggest to change the help for
> »CDateFromISO«, that it awaits a String in the form of "MMDD". This is
> what the counter part »CDateToISO« supplies.

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are on the CC list for the issue.

[Issue 109652] CDateFromIso not working for all ISO dates

[bugzilla]

https://bz.apache.org/ooo/show_bug.cgi?id=109652

--- Comment #23 from mroe  ---
> > The simply question is:
> > Which string you get from  
> > columnFinalBudget = RowSet.getString(16)
> > for dates > 2021-09-30?
> > 
> 
> -MM-DD : example 2021-10-05


For
InPutBox( "Date Conversion", "Result:", "CDateFromISO( String ): " &
CDateFromISO( "2021-10-05" ) )
I get the same
“Action not supported. Invalid procedure call.”
No problem with
InPutBox( "Date Conversion", "Result:", "CDateFromISO( String ): " &
CDateFromISO( "20211005" ) )



> dim columnFinalBudget as date ' string
>   columnFinalBudget   
> = RowSet.getDate(16) ' String(16)
> print columnFinalBudget
> 
> resulting in
> 
> "Incorrect Property Value"

You will not get a value with type Date – you get a struct
com.sun.star.util.Date!

http://www.openoffice.org/api/docs/common/ref/com/sun/star/sdb/XColumn.html#getDate
http://www.openoffice.org/api/docs/common/ref/com/sun/star/util/Date.html

Dim newDate As New com.sun.star.util.Date
newDate = RowSet.getDate(16)
print newDate.Year, newDate.Month, newDate.Day

If you want to use the string representation then use
Dim columnFinalBudget As String
Dim dateString As String
columnFinalBudget = RowSet.getString(16)
'Now you can convert it first to a legal ISO representation with the functions
above
'or with string manipulations
'or simply use
dateString = CDate( columnFinalBudget )

For me at this point: EoD. Because it isn't about the issue anymore.

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are on the CC list for the issue.

[Issue 127124] saving odp file corrupts image

[bugzilla]

https://bz.apache.org/ooo/show_bug.cgi?id=127124

--- Comment #5 from oooforum (fr)  ---
Created attachment 85979
  --> https://bz.apache.org/ooo/attachment.cgi?id=85979=edit
ODP with a vectorial picture

(In reply to oo_user57 from comment #4)
> I actually don't know the origin of the vectorial file. Is there anything
> wrong with the vectorial file? 
Certainly because I don't reproduce with another SVG file.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127124] saving odp file corrupts image

[bugzilla]

https://bz.apache.org/ooo/show_bug.cgi?id=127124

oooforum (fr)  changed:

   What|Removed |Added

 Resolution|--- |NOT_AN_ISSUE
 Status|UNCONFIRMED |RESOLVED

--- Comment #6 from oooforum (fr)  ---
For me, an issue with your SVG or old build of LibO which corrupt this SVG.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127348] Database In Draw (Data Source)

[bugzilla]

https://bz.apache.org/ooo/show_bug.cgi?id=127348

mroe  changed:

   What|Removed |Added

 Issue Type|DEFECT  |ENHANCEMENT
  Component|help|editing
 OS|Windows 7   |All
Product|Base|Draw

--- Comment #3 from mroe  ---
(In reply to Regina Henschel from comment #1)
> You can already add database fields to Draw- and Impress-documents. Open the
> "Form Controls" and "Form Design" toolbars to insert fields and to define
> the connection.
> 
> I guess, that you do not mean a "database" but that you mean meta
> information. That request does already exists. It is bug 2882.

I think he doesn't mean controls rather database fields:
Insert → Fields → Other…: (Tab) Database
(mail merge/reports/lists/labels)

Draw has more possibilities for design so I can imagine that for labels,
reservations … the use of database fields that can be formatted like “normal”
text could be a good enhancement.

Maybe the OP has other suggestions fur use.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127348] Database In Draw (Data Source)

[bugzilla]

https://bz.apache.org/ooo/show_bug.cgi?id=127348

--- Comment #4 from mroe  ---
(In reply to mroe from comment #3)
> Maybe the OP has other suggestions fur use.

Typo: Maybe the OP has other suggestions for use.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127348] Database In Draw (Data Source)

[bugzilla]

https://bz.apache.org/ooo/show_bug.cgi?id=127348

--- Comment #5 from oooforum (fr)  ---
For me, Draw app must be stay a drawing app.
Writer is dedicated with database interface.
If you want objects from Draw, you could use OLE function or simply a
copy/paste.

Do not use a hammer to screw :-)

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 109652] CDateFromIso not working for all ISO dates

[bugzilla]

https://bz.apache.org/ooo/show_bug.cgi?id=109652

--- Comment #21 from mroe  ---
(In reply to D Denny from comment #20)
> I have run separately your sample sub and proven to myself that
> CDateFromISO() runs perfectly happily on its own.

The simply question is:
Which string you get from  
columnFinalBudget = RowSet.getString(16)
for dates > 2021-09-30?

If the column is defined as DATE you should better read the date rather the
string representation. So your macro will be independent from any uncontrolled
string conversion.

AND: Please test your macro with
Option Explicit
and define your variables to get sure that there is not an unwanted conversion!
Dim columnFinalBudget As String


For the original reported bug I suggest to change the help for »CDateFromISO«,
that it awaits a String in the form of "MMDD". This is what the counter
part »CDateToISO« supplies.

-- 
You are receiving this mail because:
You are on the CC list for the issue.
You are the assignee for the issue.

[Issue 127348] Database In Draw (Data Source)

[bugzilla]

https://bz.apache.org/ooo/show_bug.cgi?id=127348

oooforum (fr)  changed:

   What|Removed |Added

 CC||ooofo...@free.fr

--- Comment #2 from oooforum (fr)  ---
What do you do with database fields in ODG document?
Could you give us a real example and attach a screenshot of expected result?

-- 
You are receiving this mail because:
You are the assignee for the issue.