[sw-issues] [Issue 114755] very slow after hibernate

2010-09-26 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=114755
 Issue #|114755
 Summary|very slow after hibernate
   Component|Word processor
 Version|1.0.0
Platform|PC
 URL|
  OS/Version|Linux
  Status|UNCONFIRMED
   Status whiteboard|
Keywords|
  Resolution|
  Issue type|DEFECT
Priority|P3
Subcomponent|editing
 Assigned to|writerneedsconfirm
 Reported by|rnhainsworth





--- Additional comments from rnhainswo...@openoffice.org Sun Sep 26 
12:25:52 + 2010 ---
1) Writer is opened and is editing file. 
2) Computer is put into Suspend Mode.
3) Computer restarted.
Defect: input and processing of edits in Writer exceedingly slow.

This issue has only recently appeared.
I currently have:
a) Ubuntu 10.04 LTS
b) OOO320m12 (Build:9483)

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@sw.openoffice.org
For additional commands, e-mail: issues-h...@sw.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org



[sw-issues] [Issue 113407] Change choice of Cross-Re ference Display

2010-07-25 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=113407
 Issue #|113407
 Summary|Change choice of Cross-Reference Display
   Component|Word processor
 Version|1.0.0
Platform|All
 URL|
  OS/Version|All
  Status|UNCONFIRMED
   Status whiteboard|
Keywords|
  Resolution|
  Issue type|ENHANCEMENT
Priority|P3
Subcomponent|editing
 Assigned to|writerneedsconfirm
 Reported by|rnhainsworth





--- Additional comments from rnhainswo...@openoffice.org Sun Jul 25 
10:06:49 + 2010 ---
When inserting a cross-reference (eg., to Table 3), the initial dialog offers a
choice of display attributes, eg. page, type, caption, heading. However, if by
error the wrong choice is made (eg. the default page number is chosen when the
caption number was intended), there is no way to change the display attribute.
The work-around is to delete the cross-reference and then to reinsert a new one.

I would suggest that when a cross-reference field is right (double) clicked, the
original insertion dialog is redisplayed with the existing attributes as the
defaults.

Since the entry for Issue #61923 is uninformative, this may be a duplicate to
that issue.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@sw.openoffice.org
For additional commands, e-mail: issues-h...@sw.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org



[sw-issues] [Issue 112548] Cursor / focus loss when stepping into a bullet point

2010-06-20 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=112548
 Issue #|112548
 Summary|Cursor / focus loss when stepping into a bullet point
   Component|Word processor
 Version|OOO320m12
Platform|PC
 URL|
  OS/Version|Linux
  Status|UNCONFIRMED
   Status whiteboard|
Keywords|
  Resolution|
  Issue type|DEFECT
Priority|P3
Subcomponent|editing
 Assigned to|writerneedsconfirm
 Reported by|rnhainsworth





--- Additional comments from rnhainswo...@openoffice.org Sun Jun 20 
14:15:46 + 2010 ---
When stepping through text using cursor down / cursor up / pageup /pagedown and
cursor moves from text without bullet points to text with bullet points, focus
is shifted to the bullet edit dialog box and leave the edit window.

The result is that scrolling up/down with the cursor is halted. A click back to
the edit window is required.

This is so irritating and non-intuitive that I consider it to be a defect.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@sw.openoffice.org
For additional commands, e-mail: issues-h...@sw.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org



[graphics-issues] [Issue 108738] donut pie - names for mul tiple series

2010-01-28 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=108738
 Issue #|108738
 Summary|donut pie - names for multiple series
   Component|Chart
 Version|1.0.0
Platform|Unknown
 URL|
  OS/Version|All
  Status|UNCONFIRMED
   Status whiteboard|
Keywords|
  Resolution|
  Issue type|ENHANCEMENT
Priority|P3
Subcomponent|formatting
 Assigned to|kla
 Reported by|rnhainsworth





--- Additional comments from rnhainswo...@openoffice.org Thu Jan 28 
13:55:54 + 2010 ---
Chart will construct donut pie charts with multiple dataseries, showing them as
concentric circles.

The category names are placed in the legend, but there is no way of displaying
the label associated with the data series. Hence it is necessary to manually
examine the chart to determine which of the rings is associated with a
particular dataseries, and then to label it manually.

Try the following data. Select donut.

Low High
red 1   10
blue2   20
green   3   35
yellow  4   45

Interestingly, if the line chart is selected, the category values are plotted
along the axis, and the legend contains the data series names.

Suggested solution: An additional legend is needed for the data series, eg.

Inner ring: Low
Outer ring: High

[intermediate rings could be labelled R2, R3, etc]

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@graphics.openoffice.org
For additional commands, e-mail: issues-h...@graphics.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org



[graphics-issues] [Issue 28670] implement explicit resize of legend

2009-11-01 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=28670





--- Additional comments from rnhainswo...@openoffice.org Mon Nov  2 
07:18:19 + 2009 ---
The detail of the changes discussed here are hiding the wood from the trees.
When you have developed a diagram or chart that is good, you want to use it (for
us in a report in Writer). That means working with all the format options of the
chart to increase readiblity and impact (line colours/thicknesses, axis
labelling, etc).

The legends associated with lines/objects are essential to readibility. But
their main format characteristics cannot be directly edited in OpenOffice. The
format characteristics can be changed by the autoformating routines, so why is
it impossible to provide an interface for direct user interaction. I cannot get
the look I want easily, if at all. This leaves a bad taste.

I want to be able to change char size, dimensions of legend, layout of legends,
line breaks within legends, dimension of legend box. In short, I want to be able
to use the standard format tools on the legends as if they were text objects.

I first submitted requests for changes in Chart after working with Office 1, and
legend formatting was one of them. It is now Office v3.1 and the issue remains
unresolved.

Surely the time has come for Chart issues to rise in priority.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@graphics.openoffice.org
For additional commands, e-mail: issues-h...@graphics.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org



[graphics-issues] [Issue 106220] plugin in place of chart

2009-10-23 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=106220
 Issue #|106220
 Summary|plugin in place of chart
   Component|Chart
 Version|1.0.0
Platform|All
 URL|
  OS/Version|All
  Status|UNCONFIRMED
   Status whiteboard|
Keywords|
  Resolution|
  Issue type|ENHANCEMENT
Priority|P3
Subcomponent|code
 Assigned to|kla
 Reported by|rnhainsworth





--- Additional comments from rnhainswo...@openoffice.org Fri Oct 23 
11:47:07 + 2009 ---
Sophisticated charts difficult to create with Chart component, eg., multiple x.y
axes, overlapping charts, multiple graphs on same image, export of graph as sgl.

Irritations over font size / resizing in legend (issue 28670) very severe.

Graph-drawing software is available, eg., gnu-plot, ploticus, grace.

These offer more options.

Is it possible to offer plugins from OO to one or more of these tools?

Chart is adequate for most purposes, but not when a tailor-made diagram is 
needed.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@graphics.openoffice.org
For additional commands, e-mail: issues-h...@graphics.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org



[graphics-issues] [Issue 106221] plugin in place of chart

2009-10-23 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=106221
 Issue #|106221
 Summary|plugin in place of chart
   Component|Chart
 Version|1.0.0
Platform|All
 URL|
  OS/Version|All
  Status|UNCONFIRMED
   Status whiteboard|
Keywords|
  Resolution|
  Issue type|ENHANCEMENT
Priority|P3
Subcomponent|code
 Assigned to|kla
 Reported by|rnhainsworth





--- Additional comments from rnhainswo...@openoffice.org Fri Oct 23 
12:05:26 + 2009 ---
Sophisticated charts difficult to create with Chart component, eg., multiple x.y
axes, overlapping charts, multiple graphs on same image, export of graph as sgl.

Irritations over font size / resizing in legend (issue 28670) very severe.

Graph-drawing software is available, eg., gnu-plot, ploticus, grace.

These offer more options.

Is it possible to offer plugins from OO to one or more of these tools?

Chart is adequate for most purposes, but not when a tailor-made diagram is 
needed.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@graphics.openoffice.org
For additional commands, e-mail: issues-h...@graphics.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org



[graphics-issues] [Issue 11890] Ability to edit legend tex t / modify series names

2008-08-27 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=11890





--- Additional comments from [EMAIL PROTECTED] Wed Aug 27 06:43:15 + 
2008 ---
Is this issue (11890) becoming a catchall for all chart legend editing issues?
If so, then 93147 comes here.

If not, then issue 93147 should be reassigned to 28670 not 11890 as it refers to
resizing a chart legend box, not editing data series labels within the legend.

My apologies for opening 93147: my initial search of existing issues did not
show up 28670 for some reason, but I did find 11890 and decided my issue was not
related.



-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[graphics-issues] [Issue 93147] Legend in chart poor editi ng

2008-08-26 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=93147
 Issue #|93147
 Summary|Legend in chart poor editing
   Component|Chart
 Version|DEV300m3
Platform|All
 URL|
  OS/Version|Linux
  Status|UNCONFIRMED
   Status whiteboard|
Keywords|
  Resolution|
  Issue type|DEFECT
Priority|P3
Subcomponent|formatting
 Assigned to|kla
 Reported by|rnhainsworth





--- Additional comments from [EMAIL PROTECTED] Tue Aug 26 14:23:17 + 
2008 ---
create a chart where data series have legends. 
double click on chart to edit. click on legend box. legend box outlined and
handles shown.
a) cant use handles to change size, but legend box will be moved by mouse
b) right-click on legend box, select 'Position  size', no possibility to change
width/height.
c) increase font size, legends wrap. To remove wrapping, extend total graphic
box, which leaves large white space to left of legend.

Note. Bug in ooo2 where width/height of legend could be changed, but these
affected x/y position. In ooo3m3 width/height inactive.

Problem is that legend cannot be separately edited.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sw-issues] [Issue 88995] [notes2]note meta area doe s not consider author font size setting

2008-05-07 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=88995





--- Additional comments from [EMAIL PROTECTED] Wed May  7 06:49:53 + 
2008 ---
As noted in issue #85389 general solution is to crop long names adding ... to 
end

What do I download to see new behaviour? I dont want to compile.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sw-issues] [Issue 88881] comments in Word Documents invisible

2008-05-04 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=1





--- Additional comments from [EMAIL PROTECTED] Sun May  4 10:47:52 + 
2008 ---
ok
notes work in ooo3_m2

BUT ...
a) font point size of the person creating the note is too large (larger than the
font used to render the note itself
b) how do I print the notes if I want to? MS Word has this option.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sw-issues] [Issue 88995] note author font too big

2008-05-04 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=88995
 Issue #|88995
 Summary|note author font too big
   Component|Word processor
 Version|DEV300m2
Platform|All
 URL|
  OS/Version|All
  Status|UNCONFIRMED
   Status whiteboard|
Keywords|
  Resolution|
  Issue type|ENHANCEMENT
Priority|P3
Subcomponent|viewing
 Assigned to|christophnoack
 Reported by|rnhainsworth





--- Additional comments from [EMAIL PROTECTED] Sun May  4 11:50:22 + 
2008 ---
When a note is inserted into a text document, the note's author is included. On
my box, the author's name is in a font size that is larger than the note itself
and for long names, it tends to crowd out the text.

Since authors are repeated, but the note text is important, I would prefer the
note author's name to be smaller than the note's text.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sw-issues] [Issue 88995] note author font too big

2008-05-04 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=88995





--- Additional comments from [EMAIL PROTECTED] Sun May  4 12:29:34 + 
2008 ---
Created an attachment (id=53353)
note showing large author font - no time visible


-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sw-issues] [Issue 88997] notes not printing

2008-05-04 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=88997
 Issue #|88997
 Summary|notes not printing
   Component|Word processor
 Version|DEV300m2
Platform|All
 URL|
  OS/Version|All
  Status|UNCONFIRMED
   Status whiteboard|
Keywords|
  Resolution|
  Issue type|DEFECT
Priority|P3
Subcomponent|printing
 Assigned to|mru
 Reported by|rnhainsworth





--- Additional comments from [EMAIL PROTECTED] Sun May  4 13:21:51 + 
2008 ---
Notes visible on screen are not being printed.

Attached is a screen shot with two open OO windows, one with notes visible, one
in the print preview mode, and also the print options screen open to show which
options have been selected.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sw-issues] [Issue 88997] notes not printing

2008-05-04 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=88997





--- Additional comments from [EMAIL PROTECTED] Sun May  4 13:22:54 + 
2008 ---
Created an attachment (id=53354)
notes in screen and not in print view


-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sw-issues] [Issue 88997] notes not printing

2008-05-04 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=88997





--- Additional comments from [EMAIL PROTECTED] Sun May  4 13:23:22 + 
2008 ---
Created an attachment (id=53355)
test file with notes


-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sw-issues] [Issue 88881] comments in Word Documents invisible

2008-05-03 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=1





--- Additional comments from [EMAIL PROTECTED] Sun May  4 05:50:14 + 
2008 ---
Created an attachment (id=53344)
doc written in MSWord with comments/not visible in OOO


-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sw-issues] [Issue 88881] comments in Word Documents invisible

2008-05-03 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=1





--- Additional comments from [EMAIL PROTECTED] Sun May  4 05:55:22 + 
2008 ---
This is a very important defect for me / my company. Reports are written in
Russian and then translated into English. Off-site translator leaves notes about
translation issues.

I am trying to migrate company from Word to OO and I dont have Word on my box.
But this defect means I may have to reinstall Word to see comments.

Note the notes option has no effect on visibility.

I use Ubuntu Linux, this document was created in Windows.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sw-issues] [Issue 88881] comments in Word Documents invisible

2008-04-30 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=1
 Issue #|1
 Summary|comments in Word Documents invisible
   Component|Word processor
 Version|OOo 2.4.0
Platform|All
 URL|
  OS/Version|All
  Status|UNCONFIRMED
   Status whiteboard|
Keywords|
  Resolution|
  Issue type|DEFECT
Priority|P3
Subcomponent|open-import
 Assigned to|mru
 Reported by|rnhainsworth





--- Additional comments from [EMAIL PROTECTED] Wed Apr 30 10:49:39 + 
2008 ---
Comments from MS Word invisible in OO.

a) create .doc file in either OO or MSW
b) add comments to file while in MSW, save as .doc
c) open in OO, comments not visible

But if instead of c), we have d)
d) while in OO, add comments,
e) save as .doc,  comments visible.

Somehow the comments being added to by MSW are not being trapped by the import
utility.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sw-issues] [Issue 15666] Search and Replace - can't substitute regular expression subexpression i n replace

2006-08-14 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=15666





--- Additional comments from [EMAIL PROTECTED] Mon Aug 14 03:50:52 -0700 
2006 ---
It would be good to have a summary of the RegEx behaviour, viz., what is
replaced by what.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sw-issues] [Issue 15666] Search and Replace - can't substitute regular expression subexpression i n replace

2006-08-14 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=15666





--- Additional comments from [EMAIL PROTECTED] Mon Aug 14 06:14:18 -0700 
2006 ---
Sorry, my previous request (below) was too short to be meaningful.

Since there are a number of RegEx behaviours, it would be useful to have a
summary of the way the current Search and Replace patch is supposed to work.
(viz., the  replacement).

It would be good to have a summary of the RegEx behaviour, viz., what is
replaced by what. 

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[graphics-issues] [Issue 65132] New - hiding columns clobb ers chart

2006-05-06 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=65132
  Issue #:|65132
  Summary:|hiding columns clobbers chart
Component:|Chart
  Version:|OOo 2.0.2
 Platform:|PC
  URL:|
   OS/Version:|Linux
   Status:|UNCONFIRMED
Status whiteboard:|
 Keywords:|
   Resolution:|
   Issue type:|DEFECT
 Priority:|P3
 Subcomponent:|ui
  Assigned to:|kla
  Reported by:|rnhainsworth





--- Additional comments from [EMAIL PROTECTED] Sat May  6 09:51:27 -0700 
2006 ---
Hiding columns with data that are used to construct a graph clobbers the chart.

In the file where I discovered the issue, the chart uses intermediary financial
data (for quarters), while in the file to be sent out hides the quarterly data,
leaving annual data visible.

Work-around is to put links to the hidden columns into another sheet and then
generate the graph from the linked cells.

See attached file with chart. Highligh columns A-G, Format-Columns-Hide, and
the chard disappears.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[graphics-issues] [Issue 65132] hiding columns clobbers c hart

2006-05-06 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=65132





--- Additional comments from [EMAIL PROTECTED] Sat May  6 09:52:42 -0700 
2006 ---
Created an attachment (id=36300)
test file with chart that is clobbered by hiding columns


-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[graphics-issues] [Issue 37137] Tying lines/objects to sp ecified axis/coorinate positions

2006-03-11 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=37137





--- Additional comments from [EMAIL PROTECTED] Sat Mar 11 22:21:11 -0800 
2006 ---
Very pleased my suggestion being taken up.

Could not find work around when I did this. A new data series does not have the
same effect visually as it is treated as another line and put in the legend with
other series (no way of excluding series from the the legend that I can see).

Axis at solution implies secondary axis not used in graphic, but I tend to use
both axes.

I did try a variety of workarounds. Essentially, I had to put up with
reformatting each time. Problem was especially bad when a graphic is constructed
in Calc and then transferred to a presentation.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[dba-issues] [Issue 62646] Basic debug hangs on acce ssing row

2006-03-11 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=62646





--- Additional comments from [EMAIL PROTECTED] Sat Mar 11 23:09:32 -0800 
2006 ---
Agreed - biblio does not crash.

I used both mysql and postgres databases. The mysql database was set up on my
local machine and on a network, the postgres only on the network. Same behaviour
in each case.

The mysql connection was via ODBC.

The driver for the postgres was installed according to the instructions on the
openoffice site.

Both connections work and tables can be accessed via oo database files.

I only reported this as a bug after I changed from using mysql to postgres, as I
thought that had eliminated the driver as the problem source.

For some reason the crash is not generating a crash report. There is an
automatic relaunch of OO2 and recovery of the files open at the time of the
crash. However, the 'next' button to open the crash report tool is not on the
final dialog. I could not quickly see how to activate the crash report tool.

The select statement is not material to the problem. select * from mytable
produces a crash, just as the more complex select given below.

The following is a simpler test. When Bibliography (and table biblio) are used,
no crash. When RRatingBase (Bank) are used, there is a crash. I emphasis: the
code works as part of a more general application. So here, a message box with
'Got Data' appears. But when I try to use the debugger and access 'ResRows'
after it has been obtained, there is a crash.

Sub Main
Dim oDBContext as Object, oConnection as Object, ResRows as Object
REM Const DSName = Bibliography
Const DSName = RRatingBase
oDBContext = CreateUnoService(com.sun.star.sdb.DatabaseContext)
If oDBContext.HasbyName(DSName) Then
REM oConnection = 
oDBContext.GetByName(DSName).GetConnection(dummy,dummy)
oConnection = 
oDBContext.GetByName(DSName).GetConnection(richard,123)
Else
Msgbox(DataSource   DSName   is not registered)
Exit Sub
End If

REM ResRows = oConnection.createStatement.executeQuery(select * from 
biblio)
ResRows = oConnection.createStatement.executeQuery(select * from 
Bank)
if ResRows.next Then
MsgBox(Got data)
Else
MsgBox(Not got data)
End If
x=0 ' breakpoint set on this stub line
End Sub

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[dba-issues] [Issue 62646] New - Basic debug hangs on accessing row

2006-02-28 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=62646
  Issue #:|62646
  Summary:|Basic debug hangs on accessing row
Component:|Database access
  Version:|OOo 2.0.1
 Platform:|PC
  URL:|
   OS/Version:|Linux
   Status:|UNCONFIRMED
Status whiteboard:|
 Keywords:|
   Resolution:|
   Issue type:|DEFECT
 Priority:|P3
 Subcomponent:|none
  Assigned to:|dbaneedsconfirm
  Reported by:|rnhainsworth





--- Additional comments from [EMAIL PROTECTED] Tue Feb 28 07:38:54 -0800 
2006 ---
OO hangs when I try to inpect a variable in the IDE during run time.

The code is as follows and the Subroutine works, taking data from a database,
placing it in a combobox on a dialog and starting the dialog. But ...

Sub SetBankDialog
Dim mDialog as object
'get the dialog from the library
 mDialog = DialogLibraries.getByName( Standard ).getByName( DlgViewBanks )
 odialog = CreateUnoDialog(mDialog)

'get the RegN needed for the dropdown list of RegNs
oDBContext = CreateUnoService(com.sun.star.sdb.DatabaseContext)
If oDBContext.HasbyName(DSName) Then
oConnection = 
oDBContext.GetByName(DSName).GetConnection(richard,123)
Else
Msgbox(DataSource   DSName   is not registered , 16,IT)
Exit Sub
End If
sql= select RegN from   MetaTable   where 
Operating=true 
RowRes = oConnection.createStatement.executeQuery(sql)
'put the data into the fields
olist = odialog.getControl(RegNList)
while RowRes.next
count = olist.getItemCount()
olist.addItem(RowRes.getInt(1),count)
wend
' now put the finished dialog onto the screen
odialog.execute
End Sub

In order to develop the code later, I want to see what is in RowRes. If I put a
break point immediately after RowRes, put a watch on RowRes, everything is fine.
But when I try to 'open' RowRes, the whole of OO relaunches.

It only happens when accessing a database, hence I have allocated this bug here.

Richard

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sw-issues] [Issue 15666] Search and Replace - can' t substitute regular expression subexpression in replace

2006-02-13 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=15666





--- Additional comments from [EMAIL PROTECTED] Mon Feb 13 23:23:53 -0800 
2006 ---
At last someone is looking at this issue Well done cheyrich.

Whilst hacking the SR code is needed, I wondered if a macro could be written in
Python (which has reasonable regex behaviour), and then attached to a tool bar.

Since I am a Perl person (and no time to learn python now), and there is not yet
an OO/perl interface, I have not investigated this possibility.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sw-issues] [Issue 15666] Search and Replace - can' t substitute regular expression subexpression in replace

2006-01-16 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=15666





--- Additional comments from [EMAIL PROTECTED] Mon Jan 16 00:03:29 -0800 
2006 ---
MS advertises that its products are used by knowledge professionals. As a
financial analyst, I fall into that group. I use spreadsheets extensively to
handle data imported from a variety of sources. Often the data needs to be
massaged into a form that can then be manipulated by standard spreadsheet 
functions

The lack of a RegEx replace functionality is a critical defect. If I were using
Windows, I would have to revert to Excel for this single functional absence.

If OO meets its specification as given by Help and does not have a RegEx
replace, then the DEFECT is in the Help specification.

This issue is given as part of Write, but it is a part of the whole suite.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sc-issues] [Issue 60212] Row height change inconsi stently affects control

2006-01-10 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=60212





--- Additional comments from [EMAIL PROTECTED] Tue Jan 10 11:35:47 -0800 
2006 ---
The following issue may be related to this. I was trying to find a work around.
I generated an xml file (currently perl CPAN only has modules working on sxc
format, so I have been using that format) that is then zipped.

Buttons are attached linked to cells, but only giving the width and height
properties for the controls in the cell draw definitions. The reason for this is
that without OpenOffice, it is not possible to calculate the positions of the
buttons. When 'style:use-optimal-row-height=false' is used for the row style,
the buttons are correctly aligned to each cell. 

When the wrap option is set for cell styles and the
'style:use-optimal-row-height=true' is used for the row style. The controls
(buttons) become disaligned.

What seems to be happening is that when OpenOffice reads in the file, it first
assigns the row height, calculates the positions of the buttons. Then it wraps
the text when necessary and changes the row height. At this point the buttons
become disaligned with the spreadsheet.

A sample file is attached. The 'content.xml' file in the zip archive was edited
by hand to try to demonstrate the problem. 

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sc-issues] [Issue 60212] Row height change inconsi stently affects control

2006-01-10 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=60212


User rnhainsworth changed the following:

  What|Old value |New value

   Attachment data|  |Created an attachment
  |  |(id=33089) buttons and
  |  |long text generated in
  |  |content.xml, but do not
  |  |align when in oo





--- Additional comments from [EMAIL PROTECTED] Tue Jan 10 11:37:41 -0800 
2006 ---
Created an attachment (id=33089)
buttons and long text generated in content.xml, but do not align when in oo


-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sc-issues] [Issue 60212] New - Row height change in consistently affects control

2006-01-08 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=60212
  Issue #:|60212
  Summary:|Row height change inconsistently affects control
Component:|Spreadsheet
  Version:|OOo 2.0
 Platform:|PC
  URL:|
   OS/Version:|Linux
   Status:|UNCONFIRMED
Status whiteboard:|
 Keywords:|
   Resolution:|
   Issue type:|DEFECT
 Priority:|P3
 Subcomponent:|formatting
  Assigned to:|spreadsheet
  Reported by:|rnhainsworth





--- Additional comments from [EMAIL PROTECTED] Sun Jan  8 06:50:28 -0800 
2006 ---
When I change the row height in a spread sheet that has controls (pushbuttons)
in it, the effect on the button is inconsistent, depending on whether the button
is in the same row or not.

Please see attached example file.

If the row height is changed for the first text line (buttons are embedded below
the row), all the buttons move done appropriately, retaining their positions
relative to original rows.

If the row height is changed for a row that includes a button, all the buttons
below retain their position relative to the button on the row.

But the spacing between buttons is not conserved, as can be seen if the row
height is changed on a row placed between two buttons.

The issue occurs for other controls, eg. spinners.

Changing the properties of the control, eg., to protect position, does not
appear to have any effect.

My application, from which this example is derived, has several hundred lines,
most of which have buttons to contol cell contents. (A spreadsheet is used as
the contents are also linked be formulas between cells). The spread sheet is
generated from a perl program.

But row labels are sometimes too long, and we want to use spreadsheet formatting
to adjust the row heights. But then the visual linkage between the buttons and
the rows is lost.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sc-issues] [Issue 60212] Row height change inconsi stently affects control

2006-01-08 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=60212


User rnhainsworth changed the following:

  What|Old value |New value

   Attachment data|  |Created an attachment
  |  |(id=33025) long lines and
  |  |buttons in OO spreadsheet
  |  |to demonstrate
  |  |inconsistent formating





--- Additional comments from [EMAIL PROTECTED] Sun Jan  8 06:52:33 -0800 
2006 ---
Created an attachment (id=33025)
long lines and buttons in OO spreadsheet to demonstrate inconsistent formating


-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sc-issues] [Issue 60029] New - Replacing placeholde rs after finding a regular expression

2006-01-04 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=60029
  Issue #:|60029
  Summary:|Replacing placeholders after finding a regular
  |expression
Component:|Spreadsheet
  Version:|OOo 2.0 Beta
 Platform:|PC
  URL:|
   OS/Version:|Linux
   Status:|UNCONFIRMED
Status whiteboard:|
 Keywords:|
   Resolution:|
   Issue type:|DEFECT
 Priority:|P3
 Subcomponent:|editing
  Assigned to:|spreadsheet
  Reported by:|rnhainsworth





--- Additional comments from [EMAIL PROTECTED] Wed Jan  4 08:00:49 -0800 
2006 ---
OpenOffice 2 'find and replace' lacks crucial functionality

I need to be able to replace groups of characters when importing stuff into a
spreadsheet.

Find allows regular expressions. Replace will not substitute in parts of the
expression.

This was an issue mentioned when I used OO 1.

I have recently reviewed issues in OO 2 and I find no movement on the issue.

Suppose imported text has dates in the format MMM dd, '02 which are imported
(from eg. Quick Books csv files) and I want them to be interpreted as dates in
OO. I want to be able to do something like:
find string: (...) ([0-9][0-9]), '([0-9][0-9])
replace string: \2-\1-\3

The find string is possible, though note the [0-9] instead of more normal \d
which is not recognised in OO2.

There is no functionality for the replace. However, it is standard for perl.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[api-issues] [Issue 52929] Developer manual chapters slow to load

2005-08-05 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=52929





--- Additional comments from [EMAIL PROTECTED] Fri Aug  5 04:20:38 -0700 
2005 ---
It was more than 'sub-optimal'! I have spent more than half a day trying to turn
off automatic calculation. All I need to do was scroll down the file scanning
for the right part (which turned out to be in Calculatable and fairly close to
the top of the file).

Every time it hit a picture - the screen froze, leading to overjumping the
relevant section. In the end I read the chapter through twice to find the
reference I needed.

The second suggestion I made (reducing the size of the black and white diagrams)
can be implemented automatically using a script with a graphics optimiser.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[sc-issues] [Issue 52951] New - running independent macros

2005-08-05 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=52951
  Issue #:|52951
  Summary:|running independent macros
Component:|Spreadsheet
  Version:|OOo 2.0 Beta
 Platform:|PC
  URL:|
   OS/Version:|Linux
   Status:|UNCONFIRMED
Status whiteboard:|
 Keywords:|
   Resolution:|
   Issue type:|DEFECT
 Priority:|P3
 Subcomponent:|programming
  Assigned to:|spreadsheet
  Reported by:|rnhainsworth





--- Additional comments from [EMAIL PROTECTED] Fri Aug  5 06:38:25 -0700 
2005 ---
I have calc open and running a macro that is essentially a background task.

I want to develop another macro without stopping the one above.

It would appear this is not possible in a single environment or am I wrong?

Is there the possibility of running a macro in the background? Or is the need
for some objects to be singletons create a constraint over the number of
independent macros that can be run?

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[api-issues] [Issue 52929] New - Developer manual cha pters slow to load

2005-08-04 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=52929
  Issue #:|52929
  Summary:|Developer manual chapters slow to load
Component:|sdk
  Version:|680
 Platform:|PC
  URL:|
   OS/Version:|All
   Status:|NEW
Status whiteboard:|
 Keywords:|
   Resolution:|
   Issue type:|DEFECT
 Priority:|P3
 Subcomponent:|documentation
  Assigned to:|jsc
  Reported by:|rnhainsworth





--- Additional comments from [EMAIL PROTECTED] Thu Aug  4 22:38:50 -0700 
2005 ---
Using Firefox under linux I am trying to read the spread sheet sections of the
developers manual.

Firebird freezes for minutes trying to scroll through the chapter, particularly
when rendering diagrams.

Solution for me: more memory. But not really good for community.

Suggest 
a) chop manual into more html pages (eg., one per subsection, not one per 
chapter)
b) put diagrams through graphics optimiser. They are only black and wide, so
shouldnt be big.

Also look at pdf version of manual - massive.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[dba-issues] [Issue 50442] New - SQL error from query wizard

2005-06-07 Thread rnhainsworth
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=50442
  Issue #:|50442
  Summary:|SQL error from query wizard
Component:|Database access
  Version:|OOo 2.0 Beta
 Platform:|PC
  URL:|
   OS/Version:|Linux
   Status:|UNCONFIRMED
Status whiteboard:|
 Keywords:|
   Resolution:|
   Issue type:|DEFECT
 Priority:|P3
 Subcomponent:|none
  Assigned to:|dbaneedsconfirm
  Reported by:|rnhainsworth





--- Additional comments from [EMAIL PROTECTED] Tue Jun  7 12:01:15 -0700 
2005 ---
Using OpenOffice 1.9.100 database. Using MySql server
(4.0.23_Debian-3ubuntu2-log). Using ODBC connectivity.

I have three tables (with fields): bank_related(id,month,regn),
QuantData(lineN,bkmth,val), questions(lineN,QorA)

I tried using query wizard with all three tables related by two relations
bank_related.id-QuantData.bkmth
questions.lineN-QuantData.lineN

The query failed with error
SQL Status: HY000
Error code: 1000

Syntax error in SQL expression

To narrow the problem, I set up SQL queries that work in another application
(mysqlcc). The following two queries both work in mysqlcc attaching to the same
database. One works with OOffice, the second does not.

Note how the failure comes when the number of tables in the 'from' field
increases from two to three.

[works]
select questions.lineN,ExprtData.val
from questions,ExprtData
where 
ExprtData.lineN=questions.lineN
and ExprtData.bkmth=1
order by lineN

[does not work]
select questions.lineN,ExprtData.val
from questions,ExprtData,bank_related
where 
ExprtData.lineN=questions.lineN
and ExprtData.bkmth=bank_related.id
and bank_related.month=200012
and bank_related.regn = 409

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]