Re: request for data

2014-12-01 Thread Andrea Pescetti

On 30/11/2014 sushil kumar wrote:

I need the data regarding development efforts , development models used and any 
other additional
data regarding Apache Open Office.


Your best starting point for this are the development resources listed 
at https://wiki.openoffice.org/ ; some sections of the wiki (including 
the homepage) are very outdated, but for the overall structure it's a 
good resource; you can always validate that information with this 
mailing list, and we can surely create a wiki account for you to fix 
outdated pages!



Also I would like to get my questionairs to be answered by the team
members of development project.


The dev list is the best target for this too. But remember that we 
receive links to surveys almost on a weekly basis, and nobody ever 
bothers to share the results with us. So it's unlikely that a 
questionnaire can raise some interest unless the person who proposes it 
has made some interaction with the community beforehand.


Regards,
  Andrea.

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



re open office

2014-12-01 Thread Sherry Winter
I am concerned, I have used this software for years on windows. now I
guess  i cannot use on Linux. Is the software still being updated? really?

On Sun, 30 Nov 2014, Sherry Winter wrote:
 Why wont open office install? I have read about missing binaries etc.
 I am a business person. Open office software I have been an active
 community member of open office for 6 years. I am not willing to give
 up that program and switch to libra any more. Do you have a solution
 for this issue?

Almost everyone in the openoffice community switched to using
libreoffice quite a while ago. You should just install libreoffice, and
it should work (and you'll probably even forget that you aren't using
openoffice.)


Creating Chart com.sun.star.chart.XYDiagram

2014-12-01 Thread Semen Gubarev
Hello Everyone!
I read a lot of documentation about creation charts using macro BASIC
And I still can't create chart in Writer (almost all documentation describe
how to create chart in Calc). The problem with inserting series XY data
into chart (separate X values and separate Y values)

First of all I create a chart object like this:

'Prepare embedded object
Dim oEmbeddedObject
oEmbeddedObject =
oDoc.CreateInstance(com.sun.star.text.TextEmbeddedObject)
oEmbeddedObject.SetPropertyValue(CLSID,
12dcae26-281f-416f-a234-c3086127382e)
oEmbeddedObject.Name = ChartID

'Insert chart in document
oCursor.GetText().InsertTextContent(oCursor, oEmbeddedObject, False)

'The first approach inserting data like this:
oDocChart.Diagram.DataRowSource = com.sun.star.chart.ChartDataRowSource.ROWS
Dim aData(1, 3)
aData(0, 0) = 10
aData(0, 1) = 20
aData(0, 2) = 30
aData(1, 0) = 10
aData(1, 1) = 40
aData(1, 2) = 90
Dim oData as Object
oData = oDocChart.Data
oData.Data = aData
for this case I get 2 series Y data, but I need 1 series with data X-Y

'The second approach inserting data using Writer table as datasource
'I'will miss a lot of code

Dim oChartType
oChartType =
oDocChart.FirstDiagram.GetCoordinateSystems()(0).GetChartTypes()(0)

Dim oDataProv
oDataProv = oDoc.createInstance( com.sun.star.chart2.data.DataProvider )

Dim oDataSeries
oDataSeries = CreateDataSeries_XYDiagram(oDataProv, table1.A1:A10,
table1.B1:B10)

Dim oNewDataSeriesList(0) as Object 'new data series
oNewDataSeriesList(0) = oDataSeries

'Correspond with last approach I get good chart, but after reopening the
document Y values become to X values

The question is, how to right create a X-Y chart?


Vraag ivm licenties

2014-12-01 Thread Michaël Jacobs
Beste,
Ik werk momenteel bij een Autogarage en wij stappen over naar een ander 
systeem. Nu zijn wij van plan over te stappen op Openoffice. Nu krijgen wij de 
melding van de makers van het nieuwe systeem dat wij een licentie moeten 
betalen op Openoffice.org om dit te kunnen gebruiken bij het systeem. Ze raden 
dit zelfs aan om te kopen.Klopt dit dat ze er geld voor mogen vragen?
Alvast bedankt.

Mvg,

Jacobs Michaël

Re: Vraag ivm licenties

2014-12-01 Thread Rory O'Farrell
On Mon, 1 Dec 2014 12:00:23 +0100
Michaël Jacobs jacobs.mich...@hotmail.com wrote:

 Beste,
 Ik werk momenteel bij een Autogarage en wij stappen over naar een ander 
 systeem. Nu zijn wij van plan over te stappen op Openoffice. Nu krijgen wij 
 de melding van de makers van het nieuwe systeem dat wij een licentie moeten 
 betalen op Openoffice.org om dit te kunnen gebruiken bij het systeem. Ze 
 raden dit zelfs aan om te kopen.Klopt dit dat ze er geld voor mogen vragen?
 Alvast bedankt.
 
 Mvg,
 
 Jacobs Michaël

OpenOffice can be downloaded free of any charge from
www.openoffice.org/download
You will automatically be redirected to SourceForge servers where the files are 
stored.

Note: this is the official and only site from which it is advised to download 
OpenOffice. There are no unwanted add-ons, and no need for any payment,

  

-- 
Rory O'Farrell ofarr...@iol.ie

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



Re: re open office

2014-12-01 Thread Andrea Pescetti

On 01/12/2014 Sherry Winter wrote:

I am concerned, I have used this software for years on windows. now I
guess  i cannot use on Linux. Is the software still being updated? really?


OpenOffice works perfectly on Linux. You received two public answers to 
your e-mail, both explaining how to install the most recent version of 
OpenOffice on your system. Maybe you missed them since you are not 
subscribed to the list.


See http://markmail.org/message/zmz5yf5zhl6yenll for the two answers you 
received on how to install OpenOffice 4.1.1 on Debian wheezy.


And see http://openoffice.apache.org/mailing-lists.html for information 
on how to subscribe to our lists and avoid missing answers.


Regards,
  Andrea.

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



English Dictionaries updated - 2014-12-01

2014-12-01 Thread Marco A.G.Pinto

Hello!

Just to inform everyone that I have updated the English dictionaries:
en_GB - 824 new words.

I haven't updated US and CA because Kevin Atkinson couldn't release them 
today as he had planned.


Thanks!

Kind regards,
   Marco A.G.Pinto
 ---


--


RE: re open office

2014-12-01 Thread Dennis E. Hamilton
Before anyone accepts almost everyone at face value, it is useful to look at 
the download numbers and the distribution of platforms for which Apache 
OpenOffice is available and downloaded, and also what the latest release is.  
This information is available at the http://www.openoffice.org site and on the 
project blog at https://blogs.apache.org/OOo/.

It is indeed the case that LibreOffice is packaged and delivered as part of 
several Linux distributions.  Those choices, and the degree to which there is 
synchronization with latest releases (of either LibreOffice or Apache 
OpenOffice) are determined by the providers of those distributions.  However, 
Linux downloads of Apache OpenOffice are also directly available. It takes a 
little more work to bring a Linux system up-to-date by obtaining the download 
directly.  The links provided by Andrea are useful for that.

If someone has difficulty with the install procedure for a given Linux 
distribution, discussing that on an Apache OpenOffice mailing list is valuable 
in helping project members determine where information and instructions can be 
improved as well as obtaining direct assistance from knowledgeable users.  

 - Dennis

-Original Message-
From: Andrea Pescetti [mailto:pesce...@apache.org] 
Sent: Monday, December 1, 2014 03:50
To: dev@openoffice.apache.org
Subject: Re: re open office

On 01/12/2014 Sherry Winter wrote:
 I am concerned, I have used this software for years on windows. now I
 guess  i cannot use on Linux. Is the software still being updated? really?

OpenOffice works perfectly on Linux. You received two public answers to 
your e-mail, both explaining how to install the most recent version of 
OpenOffice on your system. Maybe you missed them since you are not 
subscribed to the list.

See http://markmail.org/message/zmz5yf5zhl6yenll for the two answers you 
received on how to install OpenOffice 4.1.1 on Debian wheezy.

And see http://openoffice.apache.org/mailing-lists.html for information 
on how to subscribe to our lists and avoid missing answers.

Regards,
   Andrea.

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


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



Re: Vraag ivm licenties

2014-12-01 Thread Fernand Vanrie

Michaël ,

totaal overbodig Openoffice en Libreoffice zijn GRATIS

wellicht werkt het garagesysteem niet met opensource sofware, maar 
uitsluitend met MS ??

Beste,
Ik werk momenteel bij een Autogarage en wij stappen over naar een ander 
systeem. Nu zijn wij van plan over te stappen op Openoffice. Nu krijgen wij de 
melding van de makers van het nieuwe systeem dat wij een licentie moeten 
betalen op Openoffice.org om dit te kunnen gebruiken bij het systeem. Ze raden 
dit zelfs aan om te kopen.Klopt dit dat ze er geld voor mogen vragen?
Alvast bedankt.

Mvg,

Jacobs Michaël  



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



RE: Vraag ivm licenties

2014-12-01 Thread Dennis E. Hamilton
However, if the system being used is a turn-key package under a license 
agreement, there may be constraints on what can be added and how it can be 
added.

Google translation:
Als het nieuwe systeem is een turn-key pakket onder een licentieovereenkomst, 
kunnen er beperkingen op wat kan worden toegevoegd en hoe het kan worden 
toegevoegd.

Google Translation of original request:

I currently work at a motor vehicle shop and we move on to a different system. 
Now we plan to switch to OpenOffice. Now we get the makers of the notification 
of the new system that we have to pay a license Openoffice.org to use it in the 
system. They even recommend this to buy. Is it that they are allowed to charge 
money for it?



-Original Message-
From: Rory O'Farrell [mailto:ofarr...@iol.ie] 
Sent: Monday, December 1, 2014 03:20
To: dev@openoffice.apache.org
Cc: Michaël Jacobs
Subject: Re: Vraag ivm licenties

On Mon, 1 Dec 2014 12:00:23 +0100
Michaël Jacobs jacobs.mich...@hotmail.com wrote:

 Beste,
 Ik werk momenteel bij een Autogarage en wij stappen over naar een ander 
 systeem. Nu zijn wij van plan over te stappen op Openoffice. Nu krijgen wij 
 de melding van de makers van het nieuwe systeem dat wij een licentie moeten 
 betalen op Openoffice.org om dit te kunnen gebruiken bij het systeem. Ze 
 raden dit zelfs aan om te kopen.Klopt dit dat ze er geld voor mogen vragen?
 Alvast bedankt.
 
 Mvg,
 
 Jacobs Michaël

OpenOffice can be downloaded free of any charge from
www.openoffice.org/download
You will automatically be redirected to SourceForge servers where the files are 
stored.

Note: this is the official and only site from which it is advised to download 
OpenOffice. There are no unwanted add-ons, and no need for any payment,

  

-- 
Rory O'Farrell ofarr...@iol.ie

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


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



Re: Creating Chart com.sun.star.chart.XYDiagram

2014-12-01 Thread Fernand Vanrie

Semen,

I use a hidden calc doc to produce charts

i hope this can help::

greetz

Fernand

Sub AreaChart(ChartDataArray(), LabelsArray(), CName as String, CSheet 
as String, Optional YPos as Integer,bOrders as boolean)


 Dim Length as Integer
 Dim oCharts
 Dim oRect as new com.sun.star.awt.Rectangle
 Dim loadArgs(0) as new com.sun.star.beans.PropertyValue


loadArgs(0).Name = Hidden
loadArgs(0).Value = true

oDoc = 
StarDesktop.LoadComponentFromUrl(private:factory/scalc,_default,0,loadArgs())

oSheet = oDoc.Sheets.getByIndex(0)


 oCharts = osheet.charts
 If IsMissing(ChartNum) Then ChartNum=0
 With oRect
 .X = 0
 .Y = YPos

   .Height=  12000
   .width = 12000/4 * ubound(LabelsArray())
 End With
' Remove the CName
'chart if it exists
 If oSheet.getCharts().hasByName(CName)  Then
oSheet.getCharts().removeByName(CName)
 endif
' Make Chart
 oCharts.addNewByName(CName,oRect,Array(),TRUE, TRUE)
 oChart = oCharts.getByName(CName).embeddedObject
 oChart.diagram = 
oChart.createInstance(com.sun.star.chart.AreaDiagram)

 oDiagram = ochart.getFirstDiagram()

oCoords = oDiagram.getCoordinateSystems()
oCoord = oCoords(0)

oChartTypes = oCoord.getChartTypes()
oChartType = oChartTypes(0)


REM Wanneer Array Dataseries leeg is (Bij LO 4.3), Voeg deze dan toe
If uBound(oChartType.getDataSeries()) = -1 Then
oNewDataSeries = CreateUnoService(com.sun.star.chart2.DataSeries)
oChartType.addDataSeries(oNewDataSeries)

oNewDataSeries = CreateUnoService(com.sun.star.chart2.DataSeries)
oChartType.addDataSeries(oNewDataSeries)
EndIf


oDataSeriesList = oChartType.getDataSeries()

oDataSerieOFFERTES = oDataSeriesList(0)'=' first series
oDataSerieORDERS = oDataSeriesList(1)'1=' 2nd series
oDataSerieOFFERTES.color = rgb(0,184,255)
if bOrders then
oDataSerieOFFERTES.Transparency = 80
else
oDataSerieOFFERTES.Transparency = 0
endif
oDataSerieORDERS.color = rgb(220,35,0)
'oDataSerieORDERS.Transparency = 50
oXaxis = oCoord.getAxisByDimension(0, 0)

  oXaxis.TextRotation = 90

 oChart.lockControllers()
' Data
 oChart.Data.setData(ChartDataArray())
 oChart.Data.setrowDescriptions(LabelsArray())

dim columnLabelsArray(1)

 ss = Gezien  Herinnerd  voor   sfirma   verschenen in  
 smagnaam

 columnLabelsArray(0) = OFFERTES
columnLabelsArray(1) = ORDERS

oChart.Data.setColumnDescriptions(columnLabelsArray())
' Title
 oChart.HasMainTitle=True
oChart.Title.string = ss
' Labels
 oChart.DataSourceLabelsInFirstColumn = true
 oChart.DataSourceLabelsInFirstRow= false
' Legend
 oSheet.getCharts.getByName(CName).getEmbeddedObject.hasLegend = true

' Percentages
' Last DrawPage is oSheet.getDrawPage().getCount()-1
 
oSheet.drawpage.getByIndex(oSheet.getDrawPage().getCount()-1).model.diagram.setPropertyValue(DataCaption,0)
'PERCENT = 2 and TEXT = 4
 oChart.unlockControllers()

End Sub





On 1/12/2014 11:52, Semen Gubarev wrote:

Hello Everyone!
I read a lot of documentation about creation charts using macro BASIC
And I still can't create chart in Writer (almost all documentation describe
how to create chart in Calc). The problem with inserting series XY data
into chart (separate X values and separate Y values)

First of all I create a chart object like this:

'Prepare embedded object
Dim oEmbeddedObject
oEmbeddedObject =
oDoc.CreateInstance(com.sun.star.text.TextEmbeddedObject)
oEmbeddedObject.SetPropertyValue(CLSID,
12dcae26-281f-416f-a234-c3086127382e)
oEmbeddedObject.Name = ChartID

'Insert chart in document
oCursor.GetText().InsertTextContent(oCursor, oEmbeddedObject, False)

'The first approach inserting data like this:
oDocChart.Diagram.DataRowSource = com.sun.star.chart.ChartDataRowSource.ROWS
Dim aData(1, 3)
aData(0, 0) = 10
aData(0, 1) = 20
aData(0, 2) = 30
aData(1, 0) = 10
aData(1, 1) = 40
aData(1, 2) = 90
Dim oData as Object
oData = oDocChart.Data
oData.Data = aData
for this case I get 2 series Y data, but I need 1 series with data X-Y

'The second approach inserting data using Writer table as datasource
'I'will miss a lot of code

Dim oChartType
oChartType =
oDocChart.FirstDiagram.GetCoordinateSystems()(0).GetChartTypes()(0)

Dim oDataProv
oDataProv = oDoc.createInstance( com.sun.star.chart2.data.DataProvider )

Dim oDataSeries
oDataSeries = CreateDataSeries_XYDiagram(oDataProv, table1.A1:A10,
table1.B1:B10)

Dim oNewDataSeriesList(0) as Object 'new data series
oNewDataSeriesList(0) = oDataSeries

'Correspond with last approach I get good chart, but after reopening the
document Y values become to X values

The question is, how to right create a X-Y chart?




-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional 

Proposal: Year end website updates

2014-12-01 Thread Rob Weir
We did this last year as well, I recall.   I'm assuming lazy consensus
to do the same for duration of holiday season, when many people look
to end-of-year gift giving and charitable donations.

Two changes:

1) Change alert to Help us Help the World: Donate Today (same text
as last year) and point it to our donation's page:
http://www.openoffice.org/donations.html

(or if someone has an idea for better text, let me know)

2) Change the current logo (upper left corner) to:

http://www.openoffice.org/images/AOO_logos/christmas-logo.png

Regards,

-Rob

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



HELP!!

2014-12-01 Thread jsickel
I need to avoid TMI that send my 72 year old brain into melt down!!!  [My name 
is NOT Beatrice!!]   

I work with math students at elementary level -- grades 3 to pre-calculus, and 
often NEED to write up a custom work sheet.  

HOW DO I KILL AUTO NUMBERING  and auto formatting?  I am not doing 500 
pages that need help with some esoteric insert or search.  I just want numbers 
and paragraphs to stay WERE I PUT THEM  and not mover to some spot where the 
notation does NOT belong!!!

Would you believe that I can't see how to do this  amongst all your info? How 
long would it take me to wade through volumes of stuff I do not want or need to 
get to this

You yunguns drive us old folks to the DT's!! [Do you remember what that is?]
 

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



Re: HELP!!

2014-12-01 Thread Rory O'Farrell
On Mon, 1 Dec 2014 09:38:23 -0600
jsic...@windstream.net wrote:

 I need to avoid TMI that send my 72 year old brain into melt down!!!  [My 
 name is NOT Beatrice!!]   
 
 I work with math students at elementary level -- grades 3 to pre-calculus, 
 and often NEED to write up a custom work sheet.  
 
 HOW DO I KILL AUTO NUMBERING  and auto formatting?  I am not doing 500 
 pages that need help with some esoteric insert or search.  I just want 
 numbers and paragraphs to stay WERE I PUT THEM  and not mover to some spot 
 where the notation does NOT belong!!!
 
 Would you believe that I can't see how to do this  amongst all your info? How 
 long would it take me to wade through volumes of stuff I do not want or need 
 to get to this
 
 You yunguns drive us old folks to the DT's!! [Do you remember what that is?]
  



In OpenOffice  use /Help /OpenOffice Help, Index tab, Numbering.


-- 
Rory O'Farrell ofarr...@iol.ie

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



Re: HELP!!

2014-12-01 Thread Max Merbald
Actually it's Format - AutoCorrect - AutoCorrect Options. Remove the 
checks from the little boxes next to Autonumbering and others which may 
have bothered you. It' not got anything to do with the help menu.


Max


Am 12/1/2014 um 7:08 PM schrieb Rory O'Farrell:

On Mon, 1 Dec 2014 09:38:23 -0600
jsic...@windstream.net wrote:


I need to avoid TMI that send my 72 year old brain into melt down!!!  [My name 
is NOT Beatrice!!]

I work with math students at elementary level -- grades 3 to pre-calculus, and 
often NEED to write up a custom work sheet.

HOW DO I KILL AUTO NUMBERING  and auto formatting?  I am not doing 500 
pages that need help with some esoteric insert or search.  I just want numbers 
and paragraphs to stay WERE I PUT THEM  and not mover to some spot where the 
notation does NOT belong!!!

Would you believe that I can't see how to do this  amongst all your info? How 
long would it take me to wade through volumes of stuff I do not want or need to 
get to this

You yunguns drive us old folks to the DT's!! [Do you remember what that is?]
  


In OpenOffice  use /Help /OpenOffice Help, Index tab, Numbering.





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



Re: HELP!!

2014-12-01 Thread Max Merbald
 ah, I should have said, on AutoCorrect Options chose the options tab, 
That's where the checkbox for autonumbering is.



Am 12/1/2014 um 7:20 PM schrieb Max Merbald:
Actually it's Format - AutoCorrect - AutoCorrect Options. Remove the 
checks from the little boxes next to Autonumbering and others which 
may have bothered you. It' not got anything to do with the help menu.


Max


Am 12/1/2014 um 7:08 PM schrieb Rory O'Farrell:

On Mon, 1 Dec 2014 09:38:23 -0600
jsic...@windstream.net wrote:

I need to avoid TMI that send my 72 year old brain into melt down!!! 
[My name is NOT Beatrice!!]


I work with math students at elementary level -- grades 3 to 
pre-calculus, and often NEED to write up a custom work sheet.


HOW DO I KILL AUTO NUMBERING  and auto formatting?  I am not 
doing 500 pages that need help with some esoteric insert or search.  
I just want numbers and paragraphs to stay WERE I PUT THEM  and not 
mover to some spot where the notation does NOT belong!!!


Would you believe that I can't see how to do this  amongst all your 
info? How long would it take me to wade through volumes of stuff I 
do not want or need to get to this


You yunguns drive us old folks to the DT's!! [Do you remember what 
that is?]



In OpenOffice  use /Help /OpenOffice Help, Index tab, Numbering.





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





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



Re: HELP!!

2014-12-01 Thread Rory O'Farrell
On Mon, 01 Dec 2014 19:20:27 +0100
Max Merbald max.merb...@gmx.de wrote:

 Actually it's Format - AutoCorrect - AutoCorrect Options. Remove the 
 checks from the little boxes next to Autonumbering and others which may 
 have bothered you. It' not got anything to do with the help menu.
 
 Max
 
 
 Am 12/1/2014 um 7:08 PM schrieb Rory O'Farrell:
  On Mon, 1 Dec 2014 09:38:23 -0600
  jsic...@windstream.net wrote:
 
  I need to avoid TMI that send my 72 year old brain into melt down!!!  [My 
  name is NOT Beatrice!!]
 
  I work with math students at elementary level -- grades 3 to pre-calculus, 
  and often NEED to write up a custom work sheet.
 
  HOW DO I KILL AUTO NUMBERING  and auto formatting?  I am not doing 500 
  pages that need help with some esoteric insert or search.  I just want 
  numbers and paragraphs to stay WERE I PUT THEM  and not mover to some spot 
  where the notation does NOT belong!!!
 
  Would you believe that I can't see how to do this  amongst all your info? 
  How long would it take me to wade through volumes of stuff I do not want 
  or need to get to this
 
  You yunguns drive us old folks to the DT's!! [Do you remember what that 
  is?]

 
  In OpenOffice  use /Help /OpenOffice Help, Index tab, Numbering.

He claimed he couldn't find any help on the subject  - I directed him to it,  
My practice is always to direct a querist to the source of relevant 
information, so that he can learn and sort the problem out for himself.  He is, 
after all, a teacher, and should appreciate being directed to information.
 
-- 
Rory O'Farrell ofarr...@iol.ie

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



Re: Creating Chart com.sun.star.chart.XYDiagram

2014-12-01 Thread F C. Costero
On Mon, Dec 1, 2014 at 3:52 AM, Semen Gubarev mnog...@gmail.com wrote:

 Hello Everyone!
 I read a lot of documentation about creation charts using macro BASIC
 And I still can't create chart in Writer (almost all documentation describe
 how to create chart in Calc). The problem with inserting series XY data
 into chart (separate X values and separate Y values)

 First of all I create a chart object like this:

 'Prepare embedded object
 Dim oEmbeddedObject
 oEmbeddedObject =
 oDoc.CreateInstance(com.sun.star.text.TextEmbeddedObject)
 oEmbeddedObject.SetPropertyValue(CLSID,
 12dcae26-281f-416f-a234-c3086127382e)
 oEmbeddedObject.Name = ChartID

 'Insert chart in document
 oCursor.GetText().InsertTextContent(oCursor, oEmbeddedObject, False)

 'The first approach inserting data like this:
 oDocChart.Diagram.DataRowSource =
 com.sun.star.chart.ChartDataRowSource.ROWS
 Dim aData(1, 3)
 aData(0, 0) = 10
 aData(0, 1) = 20
 aData(0, 2) = 30
 aData(1, 0) = 10
 aData(1, 1) = 40
 aData(1, 2) = 90
 Dim oData as Object
 oData = oDocChart.Data
 oData.Data = aData
 for this case I get 2 series Y data, but I need 1 series with data X-Y

 'The second approach inserting data using Writer table as datasource
 'I'will miss a lot of code

 Dim oChartType
 oChartType =
 oDocChart.FirstDiagram.GetCoordinateSystems()(0).GetChartTypes()(0)

 Dim oDataProv
 oDataProv = oDoc.createInstance( com.sun.star.chart2.data.DataProvider )

 Dim oDataSeries
 oDataSeries = CreateDataSeries_XYDiagram(oDataProv, table1.A1:A10,
 table1.B1:B10)

 Dim oNewDataSeriesList(0) as Object 'new data series
 oNewDataSeriesList(0) = oDataSeries

 'Correspond with last approach I get good chart, but after reopening the
 document Y values become to X values

 The question is, how to right create a X-Y chart?



Hello Semen,
  I find that the code below, a slight modification of yours, works for me.

oDoc = ThisComponent
oCursor = oDoc.Text.createTextCursor()
oTextObject = oDoc.CreateInstance(com.sun.star.text.TextEmbeddedObject)
oTextObject.SetPropertyValue(CLSID,
12dcae26-281f-416f-a234-c3086127382e)
oTextObject.Name = ChartID

'Insert chart in document
oCursor.GetText().InsertTextContent(oCursor, oTextObject, False)

oDocChart = oTextObject.EmbeddedObject.Component
'The first approach inserting data like this:

oDocChart.Diagram = oDocChart.createInstance(com.sun.star.chart.XYDiagram)
oDocChart.Diagram.DataRowSource = com.sun.star.chart.ChartDataRowSource.ROWS

Dim aData(1, 2)
aData(0, 0) = 10
aData(0, 1) = 20
aData(0, 2) = 30
aData(1, 0) = 10
aData(1, 1) = 40
aData(1, 2) = 90

oDocChart.Data.Data = aData

oDocChart.DataSourceLabelsInFirstRow = False

I hope that helps.
Best regards,
Francis


Re: HELP!!

2014-12-01 Thread Max Merbald

 Hi Rory,

it's my experience that it's better to provide direct help to a person 
who isn't used to a specific software. I taught using software to 
several people, including my mother who had never used a computer until 
she was 69. Today, at 81, she's fit at it. And as I understood his 
request, he wanted help to disable AutoText and not to be directed to 
someplace in the help menue. :) But I guess there's more than one way to 
help.


By the way, arent' too many of these auto things enabled by default? 
They're bound to confuse beginners.


Max


Am 12/1/2014 um 7:39 PM schrieb Rory O'Farrell:

On Mon, 01 Dec 2014 19:20:27 +0100
Max Merbald max.merb...@gmx.de wrote:


Actually it's Format - AutoCorrect - AutoCorrect Options. Remove the
checks from the little boxes next to Autonumbering and others which may
have bothered you. It' not got anything to do with the help menu.

Max


Am 12/1/2014 um 7:08 PM schrieb Rory O'Farrell:

On Mon, 1 Dec 2014 09:38:23 -0600
jsic...@windstream.net wrote:


I need to avoid TMI that send my 72 year old brain into melt down!!!  [My name 
is NOT Beatrice!!]

I work with math students at elementary level -- grades 3 to pre-calculus, and 
often NEED to write up a custom work sheet.

HOW DO I KILL AUTO NUMBERING  and auto formatting?  I am not doing 500 
pages that need help with some esoteric insert or search.  I just want numbers 
and paragraphs to stay WERE I PUT THEM  and not mover to some spot where the 
notation does NOT belong!!!

Would you believe that I can't see how to do this  amongst all your info? How 
long would it take me to wade through volumes of stuff I do not want or need to 
get to this

You yunguns drive us old folks to the DT's!! [Do you remember what that is?]
   


In OpenOffice  use /Help /OpenOffice Help, Index tab, Numbering.

He claimed he couldn't find any help on the subject  - I directed him to it,  
My practice is always to direct a querist to the source of relevant 
information, so that he can learn and sort the problem out for himself.  He is, 
after all, a teacher, and should appreciate being directed to information.
  



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



Another Basic Function that doesn't Work!!

2014-12-01 Thread Darren Myers
Didn't take me long, found another basic function that does not work in OO
 
Who on earth built this program! Seriously... needs to find another career, 
maybe hairdressing or something!
 
So when you Find  Replace select a value , and then replace it with another 
value you get the following error message..
 
Search key Not Found
 
So I can clearly see on my finance sheet I have January 2014 to  December 
2014  very clear, however the Find  replace function !!! THAT WORKS IN 
Microsoft Easily Doesn't work in OO.  Does this mean I have to spend more 
money or a team of Developers to find more code issues with OO ??
  

Re: Another Basic Function that doesn't Work!!

2014-12-01 Thread F C. Costero
On Mon, Dec 1, 2014 at 12:12 PM, Darren Myers myers_dar...@hotmail.com
wrote:

 Didn't take me long, found another basic function that does not work in OO

 Who on earth built this program! Seriously... needs to find another
 career, maybe hairdressing or something!

 So when you Find  Replace select a value , and then replace it with
 another value you get the following error message..

 Search key Not Found

 So I can clearly see on my finance sheet I have January 2014 to
 December 2014  very clear, however the Find  replace function !!! THAT
 WORKS IN Microsoft Easily Doesn't work in OO.  Does this mean I have to
 spend more money or a team of Developers to find more code issues with OO ??


Hello,
   If you can post a small example document on the user forum (
https://forum.openoffice.org/en/forum/index.php), we can take a look at why
you are not getting the expected result.  Find  Replace in OpenOffice and
MS Office are not identical and you probably just have to change a setting.
Francis


Re: Another Basic Function that doesn't Work!!

2014-12-01 Thread Rory O'Farrell
On Mon, 1 Dec 2014 19:12:08 +
Darren Myers myers_dar...@hotmail.com wrote:

 Didn't take me long, found another basic function that does not work in OO
  
 Who on earth built this program! Seriously... needs to find another career, 
 maybe hairdressing or something!
  
 So when you Find  Replace select a value , and then replace it with 
 another value you get the following error message..
  
 Search key Not Found
  
 So I can clearly see on my finance sheet I have January 2014 to  December 
 2014  very clear, however the Find  replace function !!! THAT WORKS IN 
 Microsoft Easily Doesn't work in OO.  Does this mean I have to spend more 
 money or a team of Developers to find more code issues with OO ??
  
  
Drop More options and uncheck Regular expressions
 
-- 
Rory O'Farrell ofarr...@iol.ie

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



RE: Another Basic Function that doesn't Work!!

2014-12-01 Thread Darren Myers
Thank you that worked!
 
Very frustrated why Can't that be set as a default... its such a common task to 
find and replace.??
 
 Date: Mon, 1 Dec 2014 19:24:51 +
 From: ofarr...@iol.ie
 To: dev@openoffice.apache.org
 CC: myers_dar...@hotmail.com
 Subject: Re: Another Basic Function that doesn't Work!!
 
 On Mon, 1 Dec 2014 19:12:08 +
 Darren Myers myers_dar...@hotmail.com wrote:
 
  Didn't take me long, found another basic function that does not work in OO
   
  Who on earth built this program! Seriously... needs to find another career, 
  maybe hairdressing or something!
   
  So when you Find  Replace select a value , and then replace it with 
  another value you get the following error message..
   
  Search key Not Found
   
  So I can clearly see on my finance sheet I have January 2014 to  December 
  2014  very clear, however the Find  replace function !!! THAT WORKS IN 
  Microsoft Easily Doesn't work in OO.  Does this mean I have to spend 
  more money or a team of Developers to find more code issues with OO ??
   
 
 Drop More options and uncheck Regular expressions
  
 -- 
 Rory O'Farrell ofarr...@iol.ie
  

New volunteer

2014-12-01 Thread Paul

Hi everyone,

My name is Paul, I'm an accountant who has progressively moved towards 
programming over the years.


I started with excel and vba, moved over to server-side programming like 
php and now am interested in helping with openoffice to develop basic etc.


all the best,

Paul



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



Re: HELP!!

2014-12-01 Thread jsickel
Well actually I'm a she who spent more than a decade doing analyses of 
engineering proposals of companies like Duke power Co, and spelling out the 
assumptions and concepts in language that an interested but non-technical 
person could understand.  

That was my intro to computers, back in the days of lotus and less helpful 
auto editing.  [In my school days, slide rules reigned.]  

I am focused on subject matter content, and would be happy to use the same 
program with no more auto help for the rest of my days -- I can show what I 
need to show, if I'm not sabotaged by too much helpful interference that moves 
my stuff around.

And while I personally don't want to be bothered by all the new automated 
stuff, the fact is that automated systems have provided great improvements.  
For example, the load carrying capabilities of the existing conductors in the 
electric grid, because power can be shut off or or re-routed in nanoseconds to 
prevent ground fault overload. -- I just don't need the jolt of all that while 
I am trying to write a string of equalities to illustrate the commutative law 
for a grade 4 student.

So carry on -- I just had a much better experience with the next worksheet.  
Thanks to you both.

On Monday, December 1, 2014 12:39 PM, Rory O'Farrell ofarr...@iol.ie wrote: 
 On Mon, 01 Dec 2014 19:20:27 +0100 
 Max Merbald max.merb...@gmx.de wrote: 
  
  Actually it's Format - AutoCorrect - AutoCorrect Options. Remove the 
  checks from the little boxes next to Autonumbering and others which may 
  have bothered you. It' not got anything to do with the help menu. 
  
  Max 
  
  
  Am 12/1/2014 um 7:08 PM schrieb Rory O'Farrell: 
   On Mon, 1 Dec 2014 09:38:23 -0600 
   jsic...@windstream.net wrote: 
   
   I need to avoid TMI that send my 72 year old brain into melt down!!!  
   [My 
 name is NOT Beatrice!!] 
   
   I work with math students at elementary level -- grades 3 to 
   pre-calculus, 
 and often NEED to write up a custom work sheet. 
   
   HOW DO I KILL AUTO NUMBERING  and auto formatting?  I am not doing 
   500 
 pages that need help with some esoteric insert or search.  I just want 
 numbers 
 and paragraphs to stay WERE I PUT THEM  and not mover to some spot where the 
 notation does NOT belong!!! 
   
   Would you believe that I can't see how to do this  amongst all your 
   info? 
 How long would it take me to wade through volumes of stuff I do not want or 
 need 
 to get to this 
   
   You yunguns drive us old folks to the DT's!! [Do you remember what that 
 is?] 
 
   
   In OpenOffice  use /Help /OpenOffice Help, Index tab, Numbering. 
  
 He claimed he couldn't find any help on the subject  - I directed him to it,  
 My 
 practice is always to direct a querist to the source of relevant information, 
 so 
 that he can learn and sort the problem out for himself.  He is, after all, a 
 teacher, and should appreciate being directed to information. 
  
 -- 
 Rory O'Farrell ofarr...@iol.ie 
 


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



Re: Proposal: Year end website updates

2014-12-01 Thread Kay Schenk


On 12/01/2014 08:33 AM, Rob Weir wrote:
 We did this last year as well, I recall.   I'm assuming lazy consensus
 to do the same for duration of holiday season, when many people look
 to end-of-year gift giving and charitable donations.
 
 Two changes:
 
 1) Change alert to Help us Help the World: Donate Today (same text
 as last year) and point it to our donation's page:
 http://www.openoffice.org/donations.html
 
 (or if someone has an idea for better text, let me know)
 
 2) Change the current logo (upper left corner) to:
 
 http://www.openoffice.org/images/AOO_logos/christmas-logo.png
 
 Regards,
 
 -Rob

sounds good! :)



-- 
-
MzK

One must still have chaos in oneself to be able to give birth
 to a dancing star.
 -- Friedrich Nietzsche

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



Re: re open office

2014-12-01 Thread Kay Schenk


On 12/01/2014 07:51 AM, Dennis E. Hamilton wrote:
 Before anyone accepts almost everyone at face value, it is useful
 to look at the download numbers and the distribution of platforms for
 which Apache OpenOffice is available and downloaded, and also what
 the latest release is.  This information is available at the
 http://www.openoffice.org site and on the project blog at
 https://blogs.apache.org/OOo/.
 
 It is indeed the case that LibreOffice is packaged and delivered as
 part of several Linux distributions.  Those choices, and the degree
 to which there is synchronization with latest releases (of either
 LibreOffice or Apache OpenOffice) are determined by the providers of
 those distributions.  However, Linux downloads of Apache OpenOffice
 are also directly available. It takes a little more work to bring a
 Linux system up-to-date by obtaining the download directly.  The
 links provided by Andrea are useful for that.
 
 If someone has difficulty with the install procedure for a given
 Linux distribution, discussing that on an Apache OpenOffice mailing
 list is valuable in helping project members determine where
 information and instructions can be improved as well as obtaining
 direct assistance from knowledgeable users.
 
 - Dennis

Sherry -- See also our installation instructions that covers all
platforms --

http://www.openoffice.org/download/common/instructions.html

I am still happily and successfully using Apache OpenOffice on Linux. :)

 
 -Original Message- From: Andrea Pescetti
 [mailto:pesce...@apache.org] Sent: Monday, December 1, 2014 03:50 To:
 dev@openoffice.apache.org Subject: Re: re open office
 
 On 01/12/2014 Sherry Winter wrote:
 I am concerned, I have used this software for years on windows. now
 I guess  i cannot use on Linux. Is the software still being
 updated? really?
 
 OpenOffice works perfectly on Linux. You received two public answers
 to your e-mail, both explaining how to install the most recent
 version of OpenOffice on your system. Maybe you missed them since you
 are not subscribed to the list.
 
 See http://markmail.org/message/zmz5yf5zhl6yenll for the two answers
 you received on how to install OpenOffice 4.1.1 on Debian wheezy.
 
 And see http://openoffice.apache.org/mailing-lists.html for
 information on how to subscribe to our lists and avoid missing
 answers.
 
 Regards, Andrea.
 

 

-- 
-
MzK

One must still have chaos in oneself to be able to give birth
 to a dancing star.
 -- Friedrich Nietzsche

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



Re: Another Basic Function that doesn't Work!!

2014-12-01 Thread Alain Torrens
Well, searching for a date seems not to exist in OO. It should ...regardless of 
format. For example, searching for 'December 31' should find '2002 December 
31', 'Fri, 1999 December 31', 'Friday, December 31,1999', and '2013-12-31'. 
On the other hand, if you enter 'December 31 as text, ie with a leading 
apostrophe, OO will find it. Obviously; but not usefully...TAB

  From: Rory O'Farrell ofarr...@iol.ie
 To: dev@openoffice.apache.org 
Cc: Darren Myers myers_dar...@hotmail.com 
 Sent: Monday, December 1, 2014 2:24 PM
 Subject: Re: Another Basic Function that doesn't Work!!
   
On Mon, 1 Dec 2014 19:12:08 +


Darren Myers myers_dar...@hotmail.com wrote:

 Didn't take me long, found another basic function that does not work in OO
  
 Who on earth built this program! Seriously... needs to find another career, 
 maybe hairdressing or something!
  
 So when you Find  Replace select a value , and then replace it with 
 another value you get the following error message..
  
 Search key Not Found
  
 So I can clearly see on my finance sheet I have January 2014 to  December 
 2014  very clear, however the Find  replace function !!! THAT WORKS IN 
 Microsoft Easily Doesn't work in OO.  Does this mean I have to spend more 
 money or a team of Developers to find more code issues with OO ??
  
                        
Drop More options and uncheck Regular expressions
 
-- 
Rory O'Farrell ofarr...@iol.ie

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



  

Re: Another Basic Function that doesn't Work!!

2014-12-01 Thread jonathon


On 02/12/14 01:00, Alain Torrens wrote:
 Well, searching for a date seems not to exist in OO.

It does.

 It should ...regardless of format.

10/11/12 demonstrates why format is critical, and why the only sane
default is not found.

jonathon



signature.asc
Description: OpenPGP digital signature