[libreoffice-users] Need confirmation about a bug

[Fernand Vanrie]

During the tranformation from LO 4  upwards LO 5 we found a nasty 
regresssion bug under Windows.


Message boxes showup empty with white background 



Can someone confirm or negate the bug for the other operating Systems ?

Thanks

Fernand


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Playing Video in LO Dialogs

[Fernand Vanrie]

We can play video (windows) using the simple set of macro's  I found in 
the cloud  (see below)
The secret to have some control over the playerwindow is in the 
misterious line:

'  oPlayer.createplayerwindow(array()) who nobody seems to can solve :-)

is there a other way to lay a video in a LO Dialog ?

Thanks for any hint
Fernand

Global video
Global oPlayer
Global Player_flag, Video_flag, Time

' --
Sub VideoPlayer
   If Video_flag = 0 Then
 video =converttoURL("C:\Users\PMG\Videos\Untitled.avi") ' La vidéo 
à charger

 Video_flag = 1
 oManager = CreateUnoService("com.sun.star.media.Manager_DirectX")
 oPlayer = oManager.createPlayer( video )
   '  oPlayer.createplayerwindow(array())
 oPlayer.start() ' Lecture
 Player_flag = 1
   Else
 oPlayer.start() ' Lecture
 Player_flag = 1
   End If
End Sub

' --
Sub VideoPlayer_pause
   If Player_flag = 1 Then
oPlayer.stop() ' Pause
Player_flag = 0
Time = oPlayer.getmediatime()
   End If
End Sub

' --
Sub VideoPlayer_avance_rapide
   If Player_flag = 0 Then
oPlayer.setmediatime(Time +1) ' Avance_rapide
Time = oPlayer.getmediatime()
   End If
End Sub

' --
Sub VideoPlayer_recul_rapide
   If Player_flag = 0 Then
oPlayer.setmediatime(Time -1) ' Recul_rapide
Time = oPlayer.getmediatime()
   End If
End Sub

' --
Sub VideoPlayer_stop
   oPlayer.stop() ' Pause
   'Video_flag = 1
   Time = 0
   oPlayer.setmediatime(Time)
End Sub



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Adding a image to a gridcontrol row using BASIC

[Fernand Vanrie]

log1"))


gcolm = CreateUnoService("com.sun.star.awt.grid.DefaultGridColumnModel")
uneColonne = CreateUnoService("com.sun.star.awt.grid.GridColumn")
uneColonne.Title = "Production"
gcolm.addColumn(uneColonne)
uneColonne = CreateUnoService("com.sun.star.awt.grid.GridColumn")
uneColonne.Title = "Info"
gcolm.addColumn(uneColonne)
uneColonne = CreateUnoService("com.sun.star.awt.grid.GridColumn")
uneColonne.Title = "Result"
gcolm.addColumn(uneColonne)

gdatam = CreateUnoService("com.sun.star.awt.grid.DefaultGridDataModel")
dim ass() as variant

gdatam.addRow("France", array(xgraphic,"", -217))
gdatam.addRow("Germany", Array(xgraphic,"", 1234))
gdatam.addRow("Sweden", Array(xgraphic,"", 951.23))
'gdatam.RowHeaderWidth = 30


km = dlg.Model.createInstance("com.sun.star.awt.grid.UnoControlGridModel")
km.PositionX = 15
km.PositionY = 15
km.Width = 200
km.Height = 150
km.Name = "Grid1"
km.GridDataModel = gdatam
km.ColumnModel = gcolm
km.GridLineColor = RGB(0, 0, 0)
km.TextColor = RGB(0,0,150)
km.ShowColumnHeader = True
km.ShowRowHeader = True
km.HeaderBackgroundColor = RGB(255, 255, 0)

dlg.Model.insertByName(km.Name, km)

dlg.execute
dlg.dispose
End Sub




Fernand Vanrie wrote:

  > Hello,
  >
  > on a Openoffice wiki page i found some JAVA code to add a image into a
  > GridControl Row
  > what i need is how to make a "Object array" in BASIC who supports
  > graphics and octher data
  >
  > thanks for any hint
  >
  > Fernand
  >

I think new  Object[]{xGraphic,"1,2",1.3}) translates to
Array(xGraphic,"1,2",1.3)



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Adding a image to a gridcontrol row using BASIC

[Fernand Vanrie]

Hello,

on a Openoffice wiki page i found some JAVA code to add a image into a 
GridControl Row
what i need is how to make a "Object array" in BASIC who supports 
graphics and octher data


thanks for any hint

Fernand

The main change in milestone 3 regarding DataModel is the possibility to 
add not only text but also images. That's why addRow-method has as 
second parameter no more string array but object array. Futher supported 
types are int, double, float.


/Java/

 Object  dataModel=  xMultiComponentFactory.createInstanceWithContext(
"com.sun.star.awt.grid.DefaultGridDataModel", m_xContext);
 XGridDataModel xGridDataModel=  (XGridDataModel)  UnoRuntime.queryInterface(
XGridDataModel.class, dataModel);
 Object  oGraphicProvider=  
xMultiComponentFactory.createInstanceWithContext("com.sun.star.graphic.GraphicProvider",
 m_xContext);
 XGraphicProvider xGraphicProvider=  (XGraphicProvider)  
UnoRuntime.queryInterface(XGraphicProvider.class, oGraphicProvider);
 // create the graphic object
 PropertyValue[]  aPropertyValues=  new  PropertyValue[1];
 PropertyValue aPropertyValue=  new  PropertyValue();
 aPropertyValue.Name  =  "URL";
 aPropertyValue.Value  =  "file:///c:/myimages/testimage.png";
 aPropertyValues[0]  =  aPropertyValue;
 XGraphic xGraphic=  xGraphicProvider.queryGraphic(aPropertyValues);
 xGridDataModel.addRow("1",new  Object[]{xGraphic,"1,2",1.3});
 //one row which contains only text
 xGridDataModel.addRow("2",new  Object[]  {"2,1","2,2","1,3"}  );



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Load files into Writer only?

[Fernand Vanrie]

Jens Tröger schreef op 15/03/2015 om 14:02:

Thank you, Fernand!


document = desktop.loadComponentFromURL("private:factory/swriter", 
"_blank", 0, ())
here you do not use any property value for opening "()"

Correct in this line, and the next few lines of code are:

>>> from com.sun.star.beans import PropertyValue
>>> propVal = PropertyValue()
>>> propVal.Name = "URL" # or "FileName"?
>>> propVal.Value = "file:///path/to/document.odt"
>>> document.load( (propVal,) )
Traceback (most recent call last):
  File "", line 1, in 
__main__.DoubleInitializationException

I have also tried to pass a property list directly to the call above,
but that just opened an empty Writer document:

>>> document = desktop.loadComponentFromURL("private:factory/swriter", 
"_blank", 0, (propVal,))

Perhaps "URL" or "FileName" are not the correct properties to open a
file?


your solution to open a writer doc is the "filter" property
there are other available like "Hiden" ect..

Yes, all documented here:

   
https://wiki.openoffice.org/wiki/Documentation/DevGuide/OfficeDev/Handling_Documents#MediaDescriptor


dim oProps(0) as new com.sun.star.beans.PropertyValue
oProps2(1).Name = "FilterName"
oProps2(1).Value = "HTML (StarWriter)"
document = desktop.loadComponentFromURL("private:factory/swriter", 
"_blank", 0, oProps())

Hope it helps

Fernand

In this your example, how do you pass the actual document file name?

just replace

"private:factory/swriter" with the URL of your document , be sure its a URL bij 
converting it

using a OO native function: example converttoURL("c:\myfile.odt")

hope it helps

Fernand



Cheers,
Jens




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] exporting calc as csv but keeping ods form

[Fernand Vanrie]

Eric ,

find the code below, you must do some googling to fin the

makePropertyValue  function made by Danny Brerwer

hope it helps

Fernand

I have an application that takes input formatted as csv.  my source 
form is calc sheet with computed cells.  if I save as csv, I need to 
re open the sheet's ods file when I make changes.  is there any way to 
export as csv but keep the original ods in calc??  macro? bit o'python?


# Now save it in CSV format.
cURL=  convertToURL(  cFile +".csv"  )  
oDoc.storeToURL(  cURL,  Array(  makePropertyValue(  "FilterName",  "Text - txt - csv (StarCalc)"  )  )  )  





--- thanks





--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Where is Base?

[Fernand Vanrie]

Andreas ,

i must strongly confirm your vision.
We must see Base  as a connector and a front end for any possible 
database server


We have 100 users, using LO as a front end  to a MySQL server without 
any problems to use the MySQL data in Writer and Calc.
The front end itself is writen with LO basic mainly using Dialogs to 
view the data and to feed the server with new and modified data.

Greetz

Fernand

Am 02.03.2015 um 19:33 schrieb Florian Reisinger:

Just a short note: Base can connect to a MySql database using a connector.
I even think, knowing not much about Base, that an external database for storage is a 
very good way to go...Am 02.03.2015 16:54 schrieb Peter Goggin 
:

External is the one and only way to go. The embedded HSQL 1.8 simply
does not work well enough. There are far too many reports of total data
losses which is inacceptable for a database product.
You can connect MySQL via ODBC, JDBC and the SDBC driver built into the
office suite.
I prefer external HSQL 2.3 via JDBC because the office frontend is
tailored around HSQL, because HSQL 2 converts formerly embedded HSQL 1.8
on the fly and because any connection to an external HSQLDB requires
only one file hsqldb.jar anywhere on the system. In server mode it takes
this file plus self made start/stop scripts and a backup script.
I just opened my oldest HSQL 2 database running in server mode on a
Windows machine, accessed during 12 hours a day by means of Writer forms
and Calc reports from 7 client machines. The first record is of
2011-Apr-28. This database never caused lost a single byte of data. Of
course we run nightly backups anyway.






--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Base: Connecting to SQLite3 .db and Working With it

[Fernand Vanrie]

Rich Shepard schreef op 19/01/2015 om 20:40:

On Mon, 19 Jan 2015, Rich Shepard wrote:


LO-4.3.5, unixODBC-2.3.2, and sqliteodbc-0.9991, and sqlite-3.8.8 on
Slackware-14.1. I use the build scripts provided on SlackBuilds.org, 
except
for sqliteodbc which I built with the usual configure; make; make 
install.


  Some progress has been made. The sticking point now is Base not 
seeing the

DSN or driver. Deleted the existing .odb and started over; here are the
steps and the results:

  1.  File -> New -> Base.
  2.  Connect to an existing database; choose ODBC from dropdown list. 
Next.

  3.  Set up connection to the ODBC database (which I thought established
  the DSN): 'Browse' offers two choice: SQLite and the SQLite3 .db
  file name. I select the latter. Next.

did you tested the connection ? (button right under)

  4.  Ignore user authentification. Next.
  5.  Save and proceed: accept defaults of registering database and 
opening

the database for editing. Finish.
  6.  Assign an .odb filename and Save.

  See this error message:

  "The connection to the data source '' could not be 
established.

  "[unixODBC][Driver Manager] Data source name not found, and no driver
specified."

  I thought the DSN was specified in step 3, above. In 
/etc/unixodbc.ini is

[SQLITE3]
Description = SQLite3 ODBC Driver
Driver  = /usr/local/lib/libsqlite3odbc.so
Setup   = /usr/local/lib/libsqlite3odbc.so
Threading   = 2

  What am I doing incorrectly here?

Rich





--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Base: Questions From Potential New User

[Fernand Vanrie]

Rich ,

Florian is pointing in to the good direction, just connect LO base tot 
SQLite, google for "Openoffice and  SLQLite" for some starting points

Greetz
Fernand

On Fri, 16 Jan 2015, Florian Reisinger wrote:


From Base you can connect to your DB.. So no need to recreate anything.
Base can be used to access the data in e.g. MySQL


Florian,

  Yes, I read that. However, I do not see support for SQLite which is 
most
appropriate for this application as it's a single-user, embedded 
rdbms. If I

wanted a multi-user client-server rdbms I'd use postgres.

Rich





--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Conditional DB-Fields

[Fernand Vanrie]

Heinrich ,
in the past i used the the "name" of the DBfield in a expression of a 
Conditional field.


something like:

suppose your DBfield is namend GENDER then

if GENDER = "Women".

hope it helps

Fernand

Hello,
I want the following to work in writer (LO 4.3.5.2, Linux-Mint 17):
if db.table.field != "" -> print db.table.field else print nothing.
In other words - if a field in a DB-tuple isn't empty I want LO
to print that field, otherwise don't print anything. I have no
problem printing "fixed text" if a condition is fulfilled. However,
I can't get it to work in case I want the DB-field itself printed.
Regards
H. Stoellinger





--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Form field reference to query in Base [?]

[Fernand Vanrie]

gordom ,

One advise: do not use forms , make your own dialogs with controls. Then 
you need to write some macro's to run the queries and fill the controls 
with the data from your queries or table contents.


Greetz

Fernand

Hallo everyone.

Background:

We are using a spreadsheet with a pivot table to generate price lists. 
The price lists show prices for some sets of products. Each time 
somebody wants to see actual price, must do 2 things:

- choose a name of the set from a drop down list and
- put a current rate in a certain cell to update the prices.

Then the spreadsheet:
1. checks what kind and how many items belong to the certain set
2. checks foreign description of each item and puts its proper 
translation
3. checks prices, multiply them by the given rate and number of items 
and sum up everything

4. runs macros to format data and present it nicely in the pivot

Everything works fine until I have to make data modifications (i.g. if 
some products are not produced any more, or the prices are changed 
etc.). At this point updating a spreadsheet becomes a complicated and 
time consuming task. I think it would be easier for me to maintain 
these data in LO Base instead of using spreadsheet. I believe 
everything could be accomplished with some tables, one or few queries 
and front-end form that will be based on these queries. This form will 
be used to retrieve and present data only (not for modifying data in 
database).


Question before I'll start designing a database (I'm a novice in Base):

Is it possible to make a field in this front-end form where users can 
put a rate to calculate prices in the table or query "on the fly" 
(like in the spreadsheet, where a certain cell is referred to a range 
of cells in another worksheet)? I'll appreciate any help.

Regards,
gordom




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] mySQL login from a form using direct connect

[Fernand Vanrie]

craig,



I am running LibreOffice 4.3.4.1 on Fedora 21.  I'm trying to run a
LibreOffice basic macro from a form using the mysql direct connect. I am
able to open tables in the database without any problem.

When I open the form, the database password is requested and I enter it, and
the form's grid is loaded with the data.  I'm having trouble connecting from
the form using a basic macro. The connection requires a password. Running
the following code produces an error at the getConnection statement:

sURL = "sdbc:mysql:mysqlc:sys76.localdomain:3306/folding"
oManager = CreateUnoService("com.sun.star.sdbc.DriverManager")


trye someting like (not sure about your username)



   Dim oParms(1) as new com.sun.star.beans.PropertyValue
oParms(0).Name = "user"
oParms(0).Value = "craig@mac.localdomain "
oParms(1).Name = "password"
oParms(1).Value = "yourpassword"
oManager = CreateUnoService("com.sun.star.sdbc.DriverManager")

oCon = oManager.getConnectionWithInfo(sURL, oParms())

getConnectionWithParameters() = oCon

hope it helps

Fernand



oCon = oManager.getConnection(sURL)

The resulting error is:

BASIC runtime error.
An exception occurred
Type: com.sun.star.sdbc.SQLException
Message: Access denied for user 'craig'@'mac.localdomain' (using password:
NO).

What do I need to change to successfully connect with the macro?

Craig




--
View this message in context: 
http://nabble.documentfoundation.org/mySQL-login-from-a-form-using-direct-connect-tp4134305.html
Sent from the Users mailing list archive at Nabble.com.




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LOBase connected to SQLite3

[Fernand Vanrie]

Pertti ,

I supose there can always been connected on Windows using ODBC or ADO 
when no native connector is available.

You can test this to connect a Base document to your SQLite server

Greetz

Fernand



Good afternoon,
May I ask for some help and advice.

My prime intention is to start building database applications using 
SQLite3. I first tried to install Apache & PHP&SQLite3 as separate 
programs but the config process was too much for me why I installed 
WAMP2.4.As you know is WAMP a package of Apache, PHP and MySQL(v.5.6.) 
and the SQLite3 is an extension in PHP(v. 5.5.).


When I have been using LibreO for many years now why it should be nice 
if I could use LOBase as a front end with SQLite as the db-engine.


My question is: is it possible to connect LOBase to SQLite3?
And if so, how shall it be done -- where can I find a guide?
Is the process similar as when connecting to MySQL?

My system is Windows7prof64bit; LO4.3.4.

Thanks in advance

Pertti Rönnberg (Finland)





--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] how to add RegressionCurves to Chart using BASIC

[Fernand Vanrie]

ok: found it myself
the clue is to add a curve to a dataserie

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)
oNewDataSeries = CreateUnoService("com.sun.star.chart2.DataSeries")
oChartType.addDataSeries(oNewDataSeries)
oDataSeriesList = oChartType.getDataSeries()
oMyDataSerie= oDataSeriesList(0)'=' first series
'creating curve
oMyCurve = 
CreateUnoService("com.sun.star.chart2.PolynomialRegressionCurve")

'add curve to DataSerie
oMyDataSerie.addregressioncurve(oMycurve)

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








I found how to add regression curves using Java, can it  been done 
using Basic ?

if found no methods to add first a RegressionCurveContainer
and to add a RegressionCurve to this container ?

Thanks for any hint



XDataSeries[] dataSeriesArr = getDataSeries(chartDoc);

XRegressionCurveContainer rcCon = UnoRuntime.queryInterface( 
XRegressionCurveContainer.class, dataSeriesArr[0]);


XRegressionCurve[] curves = rcCon.getRegressionCurves();

XRegressionCurve curve = 
Lo.createInstanceMCF(XRegressionCurve.class, 
"com.sun.star.chart2.LinearRegressionCurve");   // for a linear 
regression curve

rcCon.addRegressionCurve(curve);




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] how to add RegressionCurves to Chart using BASIC

[Fernand Vanrie]

I found how to add regression curves using Java, can it  been done using 
Basic ?

if found no methods to add first a RegressionCurveContainer
and to add a RegressionCurve to this container ?

Thanks for any hint



XDataSeries[] dataSeriesArr = getDataSeries(chartDoc);

XRegressionCurveContainer rcCon = UnoRuntime.queryInterface( 
XRegressionCurveContainer.class, dataSeriesArr[0]);


XRegressionCurve[] curves = rcCon.getRegressionCurves();

XRegressionCurve curve = 
Lo.createInstanceMCF(XRegressionCurve.class, 
"com.sun.star.chart2.LinearRegressionCurve");   // for a linear 
regression curve

rcCon.addRegressionCurve(curve);

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Export to PDF wiith CMYK

[Fernand Vanrie]

 Dries ,Dave


All (mostly) printschops can convert any RGB pdf to there own CMYK 
standard's


Greetz

Fernand

Hello Dave,

AFAIK, cmyk involves a certain patent, and isn't widely available in
opensource projects like LO. I suggest you export your drawing to .png
or .jpg, and the printshop should be able to handle that, as otherwise
they can't handle any incoming picture.

In the latter case, I'd consider to change from printshop instead ;-)



Met vriendelijke groeten, Salutations distinguées, Kind Regards,

DRIES FEYS
CORPORATE SERVICES • Specialist Software Developer

TVH GROUP NV
Brabantstraat 15 • BE-8790 WAREGEM
T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com
Watch our company movies on www.tvh.tv


On 8 December 2014 at 17:08, dave boland  wrote:

All,

I'm doing a Christmas card in LO Draw (I created the templates a few
years ago, easy to use...).  The print shop that I normally use says
that you can use RGB, which is the normal PDF export, but CMYK is much
better.  So I'm looking for a simple, straight forward way of doing this
that runs under Linux.  Any suggestions?

I'm told that Scribus can import LO files, and do CMYK, but I'm in a
time crunch and really don't want to have to learn a new program.

Thanks,
Dave
--
   dave boland
   dbola...@fastmail.fm

--
http://www.fastmail.com - Accessible with your email software
   or over the web


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: macro to add annotation to selected text range

[Fernand Vanrie]

Andreas ,

Am 19.11.2014 um 21:19 schrieb Matt Price:

Thank you Andreas.  Unfortunately I don't seem to be able to install either
version of the MRI tool -- the unreleased 1.1.4 appears not to be a valid
zipfile, whiel 1.1.2 throws this error:

(com.sun.star.uno.RuntimeException) { { Message = ":
invalid syntax (MRI.py, line 21), traceback follows\X000a
/usr/lib/libreoffice/program/pythonloader.py:102 in function
getModuleFromUrl() [codeobject = compile( src, encfile(filename), \"exec\"
)]\X000a  /usr/lib/libreoffice/program/pythonloader.py:149 in function
writeRegistryInfo() [mod = self.getModuleFromUrl( locationUrl
)]\X000a\X000a", Context = (com.sun.star.uno.XInterface) @0 } }

I suppose this could be a problem with python version? I'm not certain.  In
any case, I'd really appreciate it if you could point me to a differnt
version or to some other tools.  Much appreciated!

Matt



Sorry, I do not run any recent version of LibreOffice and this is one of
the reasons.
Install XRay instead. Nevertheless, it is inevitable to read some
hundred pages of documentation to get a clear view over the whole
architecture.
If macros are the most "natural" way how you operate an office suite, MS
Office may be one and only suite that will ever fit your needs. Macro
coding for Libre/OpenOffice is for (semi-)professional programmers.
not realy, as soon you know thename off the "object"  then you can 
Google tons off usefull examples


when googling "Openoffice 
ThisComponent.createInstance("com.sun.star.text.textfield.Annotation")"


you find several examples how to handle annotations in macro's

Greetz

Fernand






--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Is there a way for a Basic macro to detect what application is running it?

[Fernand Vanrie]

Johnny, Regina ,

under "tools" we have a function GetProductName()
who returns for me "LibreOffice4.2"

hope it helps

Fernand


Hi Johnny,

You might distinguish it with Basic function IsUnoStruct?

Kind regards
Regina

Johnny Rosenberg schrieb:

Here's my problem:

I have both Apache OpenOffice and LibreOffice installed and I use them
both. I have quite a few Calc files with Basic macros. Today I found my
first difference between the Basic API in LibreOffice vs. Apache 
OpenOffice:


Dim Dlg As Object, Ctl As Object
DialogLibraries.LoadLibrary("Standard")
Dlg=CreateUnoDialog(DialogLibraries.Standard.ElDialog)
Ctl=Dlg.getControl("DateField")

Now, I want to use Ctl.setDate(myDate) and myDate=Ctl.getDate(), and 
here's

the difference:
In Apache OpenOffice, myDate is a Long. Today's date, 2014-10-19, is
represented as 20141019. I made two functions to convert to and from the
format I needed.

When running my macro in LibreOffice, the macro was interrupted by an 
error

message, of course. After some debugging I found that the LibreOffice
version of Ctl.setDate/Ctl.getDate works with a struct:
Type DateType
Year As Long
Month As Long
Day As Long
End Type


This is of course not a big deal, I can make the macro accept both 
formats,
but the macro need to know if LibreOffice or Apache OpenOffice is 
running
it. How can I do that? I have tried to find the answer myself, both 
using

xray and searching the web, but so far nothing.








--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Restrict file dialog view to specific folders

[Fernand Vanrie]

JWC ,

yes, write some macro's and use the API to make your own filepicker dialogs
when needed i can give you the code

greetz

Fernand

Is there a way to restrict the LibreOffice Writer "Save As", "Open" file
dialog window so that it only allows users to look in specfic folders on a
system. Specifically I'm trying to prevent the user from viewing the
contents of /usr and other related system folders. I'm currently using
LibreOffice 4.0.4.2 for RHEL 6. I suspect this will have to be changed in
the code but I don't know where to start. Thanks!

-JW




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Playing mp4 video's in Libreoffice Windows

[Fernand Vanrie]

Florian ,

thanks for the quick respons ,
do you mean that after the mp4 codec is on a windows machine i can use

oManager = CreateUnoService("com.sun.star.media.Manager_DirectX")

for playing MP4 video's ?

Greetz

fernand



Hi,

You need to have the codec installed A VLC integration is planned...

Liebe Grüße, / Yours,
Florian Reisinger


Am 19.06.2014 um 12:07 schrieb Fernand Vanrie :

Wath 's the current situation and the future for playing mp4 video's in 
LibreOffice Windows ?

Mp4 can aperently been played on Mac and Ubuntu (LO 4.3)

 From related issues  i learned that there is new code  using  VLC and his 
included codec's
Will the new code also  work using the Basic and API   who is currently using 
DirectX  and limited to some older codec's (avi etc)
oManager = CreateUnoService("com.sun.star.media.Manager_DirectX")
oPlayer = oManager.createPlayer( videoURL )

Thanks for any hints

Fernand


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Playing mp4 video's in Libreoffice Windows

[Fernand Vanrie]

Wath 's the current situation and the future for playing mp4 video's in 
LibreOffice Windows ?


Mp4 can aperently been played on Mac and Ubuntu (LO 4.3)

From related issues  i learned that there is new code  using  VLC and 
his included codec's
Will the new code also  work using the Basic and API   who is currently 
using DirectX  and limited to some older codec's (avi etc)

oManager = CreateUnoService("com.sun.star.media.Manager_DirectX")
oPlayer = oManager.createPlayer( videoURL )

Thanks for any hints

Fernand


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Page Break and Page Break with new Style

[Fernand Vanrie]

On 11/06/2014 10:03, Brian Barker wrote:

At 09:24 11/06/2014 +0200, Fernand Vanrie wrote:
Found that using "Cntrl + Enter" produced a Page Break without the 
possibility to change the Page Style on the new page. Is there also a 
short cut key combination to make a Page Break with new Style ? what 
now must been done with Insert >> Manual Break >> Page Break with new 
style


Perhaps depending on your operating system, Alt+I, B should bring up 
the Insert Break dialogue. Pressing P will select "Page break" and S 
the Style drop-down. The arrow keys will then move through the list of 
available styles.


Alternatively:
o Go to Tools | Customise... | Keyboard.
o Under Functions | Category, select Insert.
o Under Function, scroll down to and select Manual Break.
o Under "Shortcut keys", select your chosen shortcut.
o Click Modify and OK.

I trust this helps.

Yes thanks


Brian Barker





--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Page Break and Page Break with new Style

[Fernand Vanrie]

Found that using "Cntrl + Enter" produced a Page Break without the 
posibilty to change the Page Style on the new page.


Is there also a short cut key combination to make a Page Break with new 
Style ? wath now must been done with  Insert >> Manual BreaK >> Page 
Break with new style


Thanks for any hints

Fernand



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Help with LO Base

[Fernand Vanrie]

On 14/05/2014 15:54, Victor wrote:

Hello.

I'm a new user of LO Base, and I have some problems that I haven't be able
to solve with tutorials.

I'm making a db with several tables with many records in each one, and I
want to retrieve records from several tables at the same time. Let me
explain my problem:

I have a "table A" with about 12000 records, with their IDs 1-12000. Then I
have other tables where some of those records have more data, and some
records are not present. I mean, in Table B, there are records 1-1000, in
table C 1001-2000, not necessary in that orther, but the point is that some
records are present in the tables are some aren't.

When I try to retrieve data from several tables, I'd want to have all the
records, no matter if they are present in all the tables or not.

I don't know what kind of relationship I need to create so when I run a
if you made a INNER JOIN then you have only the data who there are 
records in both tables
if you made a LEFT OUTER JOIN you will have all records  in the left 
table + all records (also the empty in the right table.


so start the selection (left) with the table where all records are 
present and join to tables with aditional information

query to retrieve data from many tables at the same time, if a record is not
present in a table, then the columns for that record in that table should be
empty, but instead of that i'm getting things as the correct data from table
A, but then in table B I only get one record repeating in all the rows.

I hope I've explained myself clearly enough so you can help me.

Thank you very much.





--
View this message in context: 
http://nabble.documentfoundation.org/Help-with-LO-Base-tp4108795.html
Sent from the Users mailing list archive at Nabble.com.




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Automating creation of PDF from Calc

[Fernand Vanrie]

Alex ,

using the Dispatcher is not a good idea , use te API and basic to 
automate some functions as printing to PDF under specific conditions.

Please find below the code i use to print from a Writer doc

Sub export2PDF()

dim oDoc as object

CheckReportUser()
sParent = checkparent

   OpenParams = Array(MakePropertyValue("Hidden",True),)

odoc = ThisComponent
'dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
aray = Split(Date,"/")
D = Join(aray,"-")
aray = Split(Time,":")
T = Join(aray,".")
'path = ConvertToUrl( "file:///C:/export/test " & D & "_" & T & ".pdf" )
sfilename = left(odoc.title,12)& ".pdf"
path = ConvertToUrl( "file:///H:/LowRes_" &  sfilename )
'
'all documentation about  filderdata: >>> 
http://wiki.services.openoffice.org/wiki/API/Tutorials/PDF_export#PDF_Export_filter_data

'**
pdfFilterData() = array((makepropertyvalue("UseLosslessCompression", false))
 AddPropertyValue(pdfFilterData,"Quality",90) ' only if we set 
UseLosslessCompression to FALSE ( jpg)

'AddPropertyValue(pdfFilterData,"ReduceImageResolution",false)
'AddPropertyValue(pdfFilterData,"MaxImageResolution",300) ' only if we 
set ReduceImageResolution to TRUE (only  75, 150, 300, 600 or 1200 can 
been used

AddPropertyValue(pdfFilterData,"UseTaggedPDF",false)
AddPropertyValue(pdfFilterData,"SelectPdfVersion",0) '0= pdf1.4 , 1= pdf-xa
AddPropertyValue(pdfFilterData,"ExportNotes",false)
AddPropertyValue(pdfFilterData,"ExportBookmarks",false)
AddPropertyValue(pdfFilterData,"OpenBookmarkLevels",-1)
AddPropertyValue(pdfFilterData,"UseTransitionEffects",true)
AddPropertyValue(pdfFilterData,"IsSkipEmptyPages",true)
AddPropertyValue(pdfFilterData,"IsAddStream",false)
AddPropertyValue(pdfFilterData,"EmbedStandardFonts",false)
AddPropertyValue(pdfFilterData,"FormsType",0)
AddPropertyValue(pdfFilterData,"ExportFormFields",true)
AddPropertyValue(pdfFilterData,"AllowDuplicateFieldNames",false)
AddPropertyValue(pdfFilterData,"HideViewerToolbar",false)
AddPropertyValue(pdfFilterData,"HideViewerMenubar",false)
AddPropertyValue(pdfFilterData,"HideViewerWindowControls",false)
AddPropertyValue(pdfFilterData,"ResizeWindowToInitialPage",false)
AddPropertyValue(pdfFilterData,"CenterWindow",false)
AddPropertyValue(pdfFilterData,"OpenInFullScreenMode",false)
AddPropertyValue(pdfFilterData,"DisplayPDFDocumentTitle",true)
AddPropertyValue(pdfFilterData,"InitialView",0)
AddPropertyValue(pdfFilterData,"Magnification",0)
AddPropertyValue(pdfFilterData,"Zoom",100)
AddPropertyValue(pdfFilterData,"PageLayout",0)
AddPropertyValue(pdfFilterData,"FirstPageOnLeft",false)
AddPropertyValue(pdfFilterData,"InitialPage",1)
AddPropertyValue(pdfFilterData,"Printing",2)
AddPropertyValue(pdfFilterData,"Changes",4)
AddPropertyValue(pdfFilterData,"EnableCopyingOfContent",true)
AddPropertyValue(pdfFilterData,"EnableTextAccessForAccessibilityTools",true)
AddPropertyValue(pdfFilterData,"ExportLinksRelativeFsys",false)
AddPropertyValue(pdfFilterData,"PDFViewSelection",0)
AddPropertyValue(pdfFilterData,"ConvertOOoTargetToPDFTarget",false)
AddPropertyValue(pdfFilterData,"ExportBookmarksToPDFDestination",false)
AddPropertyValue(pdfFilterData,"_OkButtonString","")
AddPropertyValue(pdfFilterData,"EncryptFile",false)
AddPropertyValue(pdfFilterData,"DocumentOpenPassword","")
AddPropertyValue(pdfFilterData,"RestrictPermissions",false)
AddPropertyValue(pdfFilterData,"PermissionPassword","")

   oExport = Array( _
  MakePropertyValue("Overwrite", True), _
  MakePropertyValue("FilterName", "writer_pdf_Export"), _
  MakePropertyValue("FilterData", pdfFilterData), _
   )

oDoc.storeTOURL(path,oExport)
 '  oDoc.close(True)
End Sub


Well eventually I seem to be getting somewhere.  There seems to be a lot of 
choice.

There are some people who use the method of hiding all the sheets except the 
sheet to be converted into a PDF. Which is the method I used below.

Another methed seems to be to use printareas. To me this only seemed useful if 
one wanted to print a specific section of a sheet. Though I didn't quite master 
the intricacies of swithing on/off print areas though thgis code started to 
look promising -

rem --
rem define variables
dim oFrame   as object
dim oDispatcher as object
Dim CellRangeAddress As New com.sun.star.table.CellRangeAddress
Dim oDoc As Object
Dim oSheet As Object
Dim oFirstSheet As Object
Dim iEndCol As Integer
Dim aPrintRanges(0) As  Object

oDoc = ThisComponent
oFirstSheet = oDoc.Sheets.getByIndex( 0 )
iEndCol = getLastUsedColumn(oFirstSheet)


rem --
rem get access to the document
oFrame   = ThisComponent.CurrentController.Frame
oDispatcher = createUnoService("com.sun.star.frame.DispatchHelper")

rem --
CellRangeAddress.Sheet = 0
CellRangeAddress.StartColumn = 0
CellRangeAddress.StartRow = 0
CellRangeAddre

Re: [libreoffice-users] Re: Need help with Base

[Fernand Vanrie]

On 6/05/2014 22:35, Girvin Herr wrote:

Tom & Milica,
No! No! No!  I am not offering to do the work.  I apologize if I 
somehow implied that.  I  have zero experience writing LO macros of 
any sort.  I was just suggesting to avoid macros wherever possible. 
Recreating data entry forms and reports when there is a need to 
migrate to another client (front end) is enough of a problem without 
having to re-write macros too.


I use the Base query editor as Tom suggests, which is a nice GUI shell 
around the SQL, to create my table data relationships, aliases and 
sorts.  It is very similar to what Access 1.1 had to define similar 
relationships.  It works great.  If you want to see the underlying 
SQL, it can switch modes to show the SQL and even test run it to see 
the resultant output in table form.


I was just suggesting to look at using a query or two rather than 
macros, wherever possible.  Another aspect of this is that a query 
should run the actions, such as a sort, on the database server 
(back-end) and should run faster than a macro running in Base.
Using a proper SQL server + Macro's + dialogs (no forms) but using the 
dialog controls to visualise the data is not the easyist way but opens a 
never ending route.
I am curious: Does the Base macro "engine" run in Java?  Has anyone 
tested this probable speed difference?
not the macro's make a difference , you just use a macro visualise the 
data and to pass the SQL statements to the server who change , update or 
delivers the data. Only the connection with your server and the data 
volumes influence the speed.

Girvin



On 05/06/2014 03:52 AM, Tom Davies wrote:

Hi :)
Can you post some of the old macros as plain text and give a rough 
idea of
what each does.  SQL is usually easier because you get a nice gui to 
do a
lot of the work in a nice point&click way.  Some of the algebraic 
formulae

might be much the same or perhaps a little less convoluted.

Plus Sql is more generic and less dependant on specific product and
versions.  On the other hand the LibreOffice/OpenOffice macro 
language is

also much less version-specific than MS macros.

I'm not certain that Girvin is offering to do the work for free.  
Knowing

him he probably is but it might be better if there was a potential for
payment for work done, unless exchange-rates make that unworkable (as 
often

happens).
Regards from
Tom :)



On 6 May 2014 07:45, milica  wrote:


Dear Girvin,
I have that base that we use in our workshop like warehouse
management,(select product, type amount that needs to be 
added/removed from

warehouse and macro does it) and also base needs to create work orders
based on calculation (for every product, how many half products 
there is to
be made) times number of products needs to be made,and then write 
that on

some report.
I pretty mush did all the work in LO Calc, and the SQL is too much 
for me

currently. And I do that for personal use, since we have to switch from
XP/Access to Ubutu/LO on our workshop computer.
I cannot ask you to do that work for me, and I'm not sure If I could 
handle

that myself.
Thanks,
Milica




On Tue, May 6, 2014 at 12:07 AM, Girvin Herr [via Document 
Foundation Mail

Archive]  wrote:

I have not been tracking MS Access system design since version 1.1, 
but
back then Access did have an external database back-end (server) 
engine
called Jet.  Jet was bundled in with Access, much like Base uses 
HSQLDB,

but I think it could be used by other front-end clients than Access.
So, the MS Access client-server  topology was not that unlike Base.
Base just allows one to get out of the MS Access proprietary "silo" 
and

allow much more control of the database system.

For the record, I am using MySQL with Base, soon to be switching to
MariaDB.  I have not needed to use any macros in my work with Base 
forms

or reports.  I have made it a point to avoid macros because they are
very client-dependent and they would lock me in to a specific client,
much as the MS Access macros in your database are causing you problems
now.  I have been able to do some of what you are needing to do with
forms, only I used queries.  Many of my forms have list boxes where I
select one of a list of options to be inserted into a database field.
Although I have not used it, there is another type of drop-down 
listbox

that presents options, but if an option not in the list is needed, the
user may enter that option into the field.  I may have misread your
posting, but that may be what you need.  I can see that there are 
times

when macros would be the only answer to a problem, such as with custom
forms, but my recommendation is to avoid them whenever you can.
Girvin Herr


On 05/05/2014 12:28 PM, milica wrote:


Thanks,
Actually, that base in ms access is kind of start point, and needs to

be

more developed,so I have to learn LO macros anyway :(
   I'm reading the book OpenOffice.org Macros Explained (great 
book!),

and

making new version in LO but in LO Calc.
Than

Re: [libreoffice-users] left/right pages

[Fernand Vanrie]

Brian , Truett

Probably there is a problem with the "default" page style where the next 
style is set to a "right" page ?


greetz

Fernand

At 19:47 28/04/2014 -0700, Truett Bobo wrote:
In the last few days, anytime I create a new LO Writer document it is 
formatted with left and right pages.  And some of my past documents 
are formatted that way as well.  I would like to return all my 
documents to single page format, but have been unsuccessful in 
discovering how to do this.


I'm not exactly sure what you mean by this. If you print something 
double-sided - as LibreOffice expects - every document will 
necessarily have left pages and right pages. Do you mean that 
alternate pages are formatted in some different way? In that case, it 
might be helpful to know what this is. But in any case, it's difficult 
to imagine how a page formatting change could modify existing 
documents, as you suggest.


I wonder whether you are merely describing the way that Writer 
displays your documents whilst you are editing them. If this is your 
problem, go to View | Zoom... . There are various settings there and 
you can experiment to find what suits you. You can also adjust these 
settings in a number of ways using controls at the right end of the 
Status Bar (at the bottom of the LibreOffice window). If, as it seems, 
you changed something inadvertently, it may be that you clicked on one 
of these controls in the Status Bar. Changes to the way you view 
documents do indeed stick for your installation of LibreOffice (or 
rather your use of it); I'm not sure whether they can affect the way 
you see existing documents.


Note that there are similar but separate controls for how you view 
documents in Page Preview mode.


Could it be related to a document which I created a while back with 
two columns?


Very probably not.

Though it does in fact have 2 columns, I discovered that it is 
identified as having only 1 column in the page format window (format 
> page > columns).


If the page format you see has only one column but the document 
genuinely prints with two columns, there are a number of explanations:
o The pages with two columns have a different page style from the one 
you checked. (Documents can have multiple page styles.)
o The material in columns is contained in a section, a structure which 
can independently have multiple columns.

o The material in columns is contained in a table.
o The columns were constructed in some other way, perhaps in frames.

I trust this helps.

Brian Barker





--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] forums, The AOO one

[Fernand Vanrie]

On 25/04/2014 13:06, Andrew ,

Its a chame, there must be a solution save all this invaluable 
information, its still te best place to start coding wint LO and OO


Greetz

Fernand


On 04/24/2014 03:05 PM, Tom Davies wrote:

Hi :)
Just popped into the Apache OpenOffice forum
https://forum.openoffice.org/en/forum/
and noticed their header claims "User community support forum for Apache
OpenOffice, LibreOffice and all the OpenOffice.org"


They were very intentional about that. Does LO even have a separate 
forum?


THe OOoForum has been plagued with spammers since the forum itself has 
not been maintained so spammers can access it at will. It seems that 
the spammers have hit it hard enough that it is always slow. When I 
connect I feel that I can be sure that I will see hundreds (or more) 
new spam messages since my last visit and not much else.


I visited one of the forum topics today and the first 4000 posts on 
that topic were spam. There are so many that it is not feasible to 
control it without some level of automation. I gave up trying to keep 
up with the spam and disabling accounts because I just do not have 
sufficient time.

The official AOO Forum, however, is well maintained and usable.




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Playing Video in a Dialog

[Fernand Vanrie]

On The French user site i found usefull code to play video on Windows 
using the API and Basic.


The code opens a MediaWindow and play any video

The player has a undocumented method "CreatePlayerWindow" who needs 
arguments (a empty array do crash LO)


Do someone knows how to use this method and how Video can been played in 
a Dialog ?


Thanks for any hints

Global video
Global oPlayer
Global Player_flag, Video_flag, Time

' --
Sub VideoPlayer
   If Video_flag = 0 Then
 video =converttoURL("C:\Users\PMG\Videos\Untitled.avi") ' La vidéo 
à charger

 Video_flag = 1
'for windows:
 oManager = CreateUnoService("com.sun.star.media.Manager_DirectX")
' for Linux
' oManager = 
CreateUnoService("com.sun.star.media.Manager_GStreamer")

End Select
 oPlayer = oManager.createPlayer( video )
   '  oPlayer.CreatePlayerwindow(array()) ' do crash LO
 oPlayer.start() ' Lecture
 Player_flag = 1
   Else
 oPlayer.start() ' Lecture
 Player_flag = 1
   End If
End Sub

' --
Sub VideoPlayer_pause
   If Player_flag = 1 Then
oPlayer.stop() ' Pause
Player_flag = 0
Time = oPlayer.getmediatime()
   End If
End Sub

' --
Sub VideoPlayer_avance_rapide
   If Player_flag = 0 Then
oPlayer.setmediatime(Time +1) ' Avance_rapide
Time = oPlayer.getmediatime()
   End If
End Sub

' --
Sub VideoPlayer_recul_rapide
   If Player_flag = 0 Then
oPlayer.setmediatime(Time -1) ' Recul_rapide
Time = oPlayer.getmediatime()
   End If
End Sub

' --
Sub VideoPlayer_stop
   oPlayer.stop() ' Pause
   'Video_flag = 1
   Time = 0
   oPlayer.setmediatime(Time)
End Sub


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Do Macros run serially or in parallel?

[Fernand Vanrie]

Noel , Andrew,

What system are you running ?

on windows the wait is doing OK

try this code


s1 = "1.  " + Now()
Wait(2000)
s2 = "2.  " + Now()
msgbox (s1 & chr(13)&  s2)

s1 an s2 differs from 2 seconds (wait 2000)

Greetz

Fernand

Hi Andrew,

Yes, that is what seems to be happening.  Even if there is a bit of code
between the Wait(2000) and the next Print #giInit, the time is the same.
Only if there is substantial code after the Wait(2000) does the time
change.  For example -
1.  04/04/2014 13:50:24
2.  04/04/2014 13:50:24
3.  04/04/2014 13:50:24
4.  04/04/2014 13:50:24
5.  B4 UpdateFundAndGenLed()  04/04/2014 13:50:24
6.  04/04/2014 13:50:28
7.  04/04/2014 13:50:28

After 5. the Init macro calls another macro.

Something odd seems to be happening with the Wait command.  Perhaps I am
missing something.  You can see why I was wanting to get fractions of a
second in the print statements.

Noel

--
Marion & Noel Lodge
lodg...@gmail.com


On 4 April 2014 03:06, Andrew Douglas Pitonyak  wrote:


So, are you saying that you have:


Print #giInit, "1.  " + Now()
Wait(2000)
Print #giInit, "2.  " + Now()

And it prints the same value for now?



On 04/03/2014 09:12 AM, Marion & Noel Lodge wrote:


Thanks for the replies to my original post.

They gave me something to work on and I have made some progress.  I think
that the macros run in series, but I am not yet sure of that.

For some reason the wait(2000) commands that I inserted into the the
macros
don't seem to work and I am getting several lines with the identical time
stamps, like this -
1.  03/04/2014 23:44:57
2.  03/04/2014 23:44:57
3.  03/04/2014 23:44:57

I looked up the formatting for time stamps and
DD:MM: hh:mm:ss.00 is supposed to give fractions of a second, but I
don't know how to apply this to the Now() function.

The code I am using to print to the text files is -

   giInit = FreeFile()
   Open "D:\LibreOffice\InitfTransEntry.txt" for Output as giInit
   Print #giInit, "1.  " + Now()

Any suggestions as to how I can format Now(), or should I use a different
function to get more accurate timing?

Thanks,

Noel
--
Noel Lodge
lodg...@gmail.com


On 2 April 2014 00:05, Andrew Douglas Pitonyak 
wrote:

  Sadly, I do not have a definitive answer to your question, but I do have

some thoughts... (see inline)


On 04/01/2014 06:57 AM, Marion & Noel Lodge wrote:

  Hi,

In opening my database accounting system, I trigger via the Form: When
loading event, a macro, (Sub Init()), containing the database
initialisation routines.

As the Form loads it displays the first record in the database,
including
the account number.   To make things easier for the user, the Text
modified
event on the account number control, triggers a macro, (Sub AccName()),
that displays the account name.

  And I assume that this is built into the form.


   Sometimes the system has crashed because it seems that Sub AccName()
has


fired before Sub Init() has finished.  (Sub AccName() depends on some of
the structures that Sub Init() sets up.)

Is it possible that both Subs are running in parallel or do they always
run
in series on a first come first served basis?

  Warning: Speculation... So insert the following text before each

statement
below:  "I am making a wild unsubstantiated guess that"

1. The form is populated before Init() finishes
2. AccName() is called as soon as text is pushed into the control.

So, if this is the case, then AccName may be called before Init()
finishes. If you really want to know if they run at the same time, you
could do a not so quick test and modify each routine so that the macro
does
something like this:

Sub Init()
Write current time to a file
delay a second or two
Do the work
delay a second or two
Write the current time to a file
End Sub

Use a different file for each subroutine, then compare the start and end
time to see if they overlap. You can probably get away with using a
simple
print statement at the start and end.


   If the latter, are there coding techniques that can be used to ensure
that


Sub Init() always runs first?

  If things run serially and AccName is called based on something done in

Init(), it may be possible that Init() cannot complete until after
   AccName() finishes.


I suppose that another possibility is to set a "Global" variable such as
"InitComplete". set to false when Init() starts, and set to true when it
completes. Modify AccName to check for InitComplete. If things are
serial,
then you may need to simply return. If not, then have AccName wait for a
few seconds and try again. If things are truly serial, then I would
expect
them to fail every time, and they don't fail every time, so it is likely
not the case.



  If the former, how can I ensure that Sub AccName() waits until Sub

Init()
has finished?

  Oh wait, see above! :-)



  Can someone point me to any articles on this subject?

Thanks,

Noel
--
Noel Lodge
lodg...@gmail.com


  --

Andrew Pitonyak
My Macro Document

[libreoffice-users] Re: How to put Basic IDE code completion to work

[Fernand Vanrie]

hallo Miklos
thanks but
only """ and "(" are auto clossing
dot operator is not functioning at all (maybe a keyboard problem ?)
tab do nothing
sub and Function not closing

do i something wrong ?

using Windows 7 (4.2.2.1)

 On Tue, Mar 18, 2014 at 10:26:08PM +0100, Fernand Vanrie 
 wrote:

Found new Basic IDE options in 4.2 , but where to find some
documentation how this new stuff works ?

In worst case, https://speakerdeck.com/vmiklos/gsoc-students-panel
starting from slide 53 talks about this topic.

Gergo, did you have some wiki page or so describing the new features?

Thanks,

Miklos



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] How to put Basic IDE code completion to work

[Fernand Vanrie]

Found new Basic IDE options in 4.2 , but where to find some 
documentation how this new stuff works ?


Thanks for any hint

Fernand

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] need CONFIRMATION about images linked to a http location

[Fernand Vanrie]

Dries , all,

Thanks, ist a bug , found it  myself now , only when using the option 
"Use LibreOffice Dialogs" the bug is happening , when using System 
dialogs , the Http locations can been used


i fill a issue

Greetz

Fernandnd

Fernand,

I just tried this in 4.2.2.1 as well, and this works just fine: I
created a new file and inserted an image through insert image from
file.

Met vriendelijke groeten, Salutations distinguées, Kind Regards,

DRIES FEYS
CORPORATE SERVICES • Specialist Software Developer

TVH GROUP NV
Brabantstraat 15 • BE-8790 WAREGEM
T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com
Watch our company movies on www.tvh.tv


On 17 March 2014 17:30, Fernand Vanrie  wrote:

With 4.2.2.1 windows

Pictures in Writer and Html documents linked to a http location no longer
opens and can no longer been inserted what makes the use of images in a HTML
doc imposible

A picture "linked" to "http://pmg.pmgroup.be/enews/idb/grafiek9.jpg"; can
been opened and viewed in a writer and Html doc until 4.0 but no longer
since  4.2

you can use the link to test

is it a bug or wanted behaviour ?

Greetz

Fernand



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] need CONFIRMATION about images linked to a http location

[Fernand Vanrie]

With 4.2.2.1 windows

Pictures in Writer and Html documents linked to a http location no 
longer opens and can no longer been inserted what makes the use of 
images in a HTML doc imposible


A picture "linked" to "http://pmg.pmgroup.be/enews/idb/grafiek9.jpg"; can 
been opened and viewed in a writer and Html doc until 4.0 but no longer 
since  4.2


you can use the link to test

is it a bug or wanted behaviour ?

Greetz

Fernand



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Need confirmation about Menus in StartModule

[Fernand Vanrie]

Since 4.2 uses a different StartModule my  Private Menus made by 
Extentions no longer appear on the new StartModule


Until 4.0  the menus are placed in "com.sun.star.frame.StartModule" but 
i found no  indications that this name was changed


Stabel version 4.2 windows all versions

Thanks

Fernand

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Need confirmation about Date type confusions

[Fernand Vanrie]

Since 4.1 the Date property from a 
"com.sun.star.awt.UnoControlDateFieldModel" returns no longer a 
"Isodate" but a "Unodate".


Since its stay like that in 4.2 is started to correct all or BASIC code 
who uses a "com.sun.star.awt.UnoControlDateFieldModel".


But i runed by accident in a  bug where as soon we have a "ss = Date" 
(who normaly returns today date as  a string) the Date property of a 
"com.sun.star.awt.UnoControlDateFieldModel" is corrupted with a BASIC 
syntax error.

"Symbol date already defined differently"
 as soon i left out the "ss = Date" the error disappeared
The error is not in 4.0
4.1 ?
The error is there in 4.2 under Windows all versions.

To reproduce the bug run the code below, who opens a dialog. The dialog 
has a Datecontrol who can been filed with todays date using a listener 
on the button.

Run the code and you run in the error
cancel the first row ("ss = date" ) to run without error

sub testDateError
  ss = date


   oDialogModel = createUnoService( 
"com.sun.star.awt.UnoControlDialogModel" )

   oDialogModel.PositionX = 10
   oDialogModel.PositionY = 10
   oDialogModel.Width = 100
   oDialogModel.Height = 100
   oDialogModel.Title = "test datecontrol"
   oDialogControl = createUnoService( "com.sun.star.awt.UnoControlDialog" )
   oDialogControl.setModel( oDialogModel )
   odialogModel = odialogcontrol.model
   oDateModel = oDialogModel.createInstance( 
"com.sun.star.awt.UnoControlDateFieldModel" )

   oDateModel.PositionX = 20
   oDateModel.PositionY = 20
   oDateModel.Width = 40
   oDateModel.Height = 14
   oDateModel.dropdown = true
   oDateModel.Name = "test1"
   oDateModel.TabIndex = nNumControls
   oDialogModel.insertByName( "test1", oDateModel )
   oDateControl = oDialogControl.getControl( "test1" )
   odialogModel = odialogcontrol.model
   oButtonModel = oDialogModel.createInstance( 
"com.sun.star.awt.UnoControlButtonModel" )

   oButtonModel.PositionX = 40
   oButtonModel.PositionY = 70
   oButtonModel.Width = 60
   oButtonModel.Height = 14
   oButtonModel.Name = "pressbuton"
   oButtonModel.Label = "press to fill with date"
   oDialogModel.insertByName( "pressbuton", oButtonModel )
   oButtonControl = oDialogControl.getControl( "pressbuton" )
   oActionListener = CreateUnoListener("pressbuton" + "_", 
"com.sun.star.awt.XActionListener" )

   oButtonControl.addActionListener( oActionListener )
   oDialogcontrol.setVISIBLE(true)
   oDialogcontrol.execute()

end sub
sub pressbuton_actionPerformed( oEvent As com.sun.star.awt.ActionEvent )

 oevent.source.context.getcontrol("test1").date = cdatetounodate(date)
dim dStart as New com.sun.star.util.Date
dStart.year = oevent.source.context.getcontrol("test1").date.year
dStart.day = oevent.source.context.getcontrol("test1").date.day
dStart.month = oevent.source.context.getcontrol("test1").date.month
end sub

Sub Main

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Connection to SQL database

[Fernand Vanrie]

Carl ,

Use a mySQL database and connect over the Native Connector

then google for the book "DataBase Programming" writen by Roberto 
Benitez  for Openoffice but also for LibreOffice

a lot of code can been found on the Book-website

Greetz

Fernand


On 15/01/2014 16:55, Ryan Ashley wrote:
SQL files are normally SQL scripts which are backups or scripts that 
create a database on a SQL server. If you need something in that 
script, you would need to setup a MySQL server, execute the SQL file 
on that server, and then get the data out that you need. I know that 
is a mouthful, and the process varies based on your operating system 
(Linux, Windows, Mac, etc).


After you do the above, you can connect with base, but you could also 
get your data out using the MySQL Workbench tool or even a 
command-line if you are using Linux. I can help you if somebody else 
doesn't help first, but I need to know what OS you are running to be 
able to help you further.


On 01/15/2014 10:51 AM, Carl Paulsen wrote:
I have a project for which I need to extract data that is in a .sql 
file (presumably a SQL database).  I've done very little with SQL so 
I need some guidance on doing this.  One route would be to open it 
with Base or Access (I now finally have access to MSAccess on a 
Windows machine but would prefer Base), but I don't understand the 
basics of doing this.


So...can someone point me to a tutorial on how to do this, 
step-by-step and from the very beginning?  For instance, do I need to 
set up a SQL server and if so, how?  (I've tried installing XAMP with 
MySQL on the Windows machine but haven't gotten it to connect to the 
file yet.)  Can I access a .sql file directly or via other methods?  
I'd like to eventually learn how to use SQL but I'm also on a pretty 
limited timeframe on accessing this data.


Or does someone want to outline the steps here for me to research on 
my own?


Thanks very much,
Carl






--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] problem with table header colors in ms word

[Fernand Vanrie]

Dries ,

Same behavior here , but the troubles are coming from the way the doc is 
build.


Kill the "picture" with the company  logo's and the tables are colored.

greetz

Fernand

We just accountered a problem where colored tables in a .doc file aren't 
shown correctly in LO, though they are shown correctly in ms word. I 
filed a bug, but it would be nice if some of you could confirm the 
existence. https://www.libreoffice.org/bugzilla/show_bug.cgi?id=73319 
Met vriendelijke groeten, Salutations distinguées, Kind Regards, DRIES 
FEYS CORPORATE SERVICES • Specialist Software Developer TVH GROUP NV 
Brabantstraat 15 • BE-8790 WAREGEM T +32 56 43 42 11 • F +32 56 43 44 88 
• www.tvh.com Watch our company movies on www.tvh.tv



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Second opening of Database

[Fernand Vanrie]

On 5/12/2013 11:52, Bob Lineker wrote:

By "SHutting down" I mean saving then data entered and then closing the LO
database by clicking on the big X top right!
The programme then closes (as confirmed by Task Manager.

If I then try to open the same database nothing happens - and Task Manager
shows "Libre Office - not responding"

strange ?
can you check if the LO hidden lockfiles are deleted after you close the 
database document ?




--
View this message in context: 
http://nabble.documentfoundation.org/Second-opening-of-Database-tp4086286p4086627.html
Sent from the Users mailing list archive at Nabble.com.




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Second opening of Database

[Fernand Vanrie]

On 3/12/2013 17:25, Bob Lineker wrote:

I am Running Libreoffice under windows 7 64bit. Opening a database is fine.

do you mean a LO database file ?

If I then shut it down,

you shut down the connection or the database file ?

I cannot open it again! I have to restart the pc th
enable me to open it - again only the once!

After shutting down I have checked with Task Manager and this shows the
programme is indeed closed.
Any ideas?



--
View this message in context: 
http://nabble.documentfoundation.org/Second-opening-of-Database-tp4086286.html
Sent from the Users mailing list archive at Nabble.com.




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] BASE refuse TIMESTAMPDIFF syntax

[Fernand Vanrie]

polch,
 dit you try this in "native' mode (LO just send the statement)

Hi.

I would like to build an SQL request that use TIMESTAMPDIFF. As i encounter
some problems of rejected syntax i try a minimal example in sql editor :

SELECT TIMESTAMPDIFF(MONTH,'2003-02-01','2003-05-01')

But either with this example, the sql editor doesn't want to save the
request neither execute it.

I'm running ooo version 4.0.1.2 on linux.

Do you think it comes from a misuse ?

Regards.

Paul.



--
View this message in context: 
http://nabble.documentfoundation.org/BASE-refuse-TIMESTAMPDIFF-syntax-tp4083921.html
Sent from the Users mailing list archive at Nabble.com.




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Base/MySQL use

[Fernand Vanrie]

Taylor ,

We are Using LO as frontend for a mySQL server, up to 50 users acces te 
data using LO.


I build my own FrontEnd using Dialogs  an basic bundled in a extension 
to acces the data using Basic macro's and the native mySQL connector , 
works also from home using as VPN connection to the server
Basic + dialogs are fery powerfull but you can use also a Database 
document with forms to have acces to Mysql.

Then you must have a copy off the dabasedoc on all your machines .

Hope it helps

Fernand

Mt patents want a database to manage their small business. My plan is to
have mySQL on a computer in the office contain the database and use LO Base
be the front end interface. 4 computers would access mySQL over the office
network. 1 computer would have access from the home computer.
Can I  (empty) the database from mySQL workbench, connect base and then
build it from there? Then copy the base file to the other computers so all
the forms and reports are available everywhere.




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Time Values - LO 4.1.3.2

[Fernand Vanrie]

On 29/10/2013 10:12, Heinrich Stoellinger wrote:
Thanks for the prompt answer! By the way, I am using the  Linux 
.deb-Version
of LO. This is NOT a show stopper for me. I will continue to use the 
Java-

connector until this problem is fixed...

what about speed and MySQL language changes due to the JDBC connector ?

Regards
H.S.

On Tue, 29 Oct 2013 09:20:18 +0100, Fernand Vanrie  
wrote:



Heinrich ,

Lionel is working on it he changed the internal MariaDB code back to the
MySQL code i am not sure if this changes go's into the version you uses
?, on Windows we have the same situation, when using ODBC no date
problems and Jésús is working on a new Windows compile.
Greetz



Hello,
I just downloaded pre-release LO 4.1.3.2. It includes a native MySQL
connector.
However, the same as in previous LO 4.1.x "shipments", time values are
still
handled incorrectly. What I see is that - for a time value of
"20:00:00" - the
column is shown as "12:20:00" for example. ALL time values are shown
this way.
When accessing the database through JDBC everything is o.k.
Regards
H.S.









--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Time Values - LO 4.1.3.2

[Fernand Vanrie]

Heinrich ,

Lionel is working on it he changed the internal MariaDB code back to the 
MySQL code i am not sure if this changes go's into the version you uses 
?, on Windows we have the same situation, when using ODBC no date 
problems and Jésús is working on a new Windows compile.

Greetz



Hello,
I just downloaded pre-release LO 4.1.3.2. It includes a native MySQL 
connector.
However, the same as in previous LO 4.1.x "shipments", time values are 
still
handled incorrectly. What I see is that - for a time value of 
"20:00:00" - the
column is shown as "12:20:00" for example. ALL time values are shown 
this way.

When accessing the database through JDBC everything is o.k.
Regards
H.S.



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] MySQL Native C Connector Extension for Linux 32, 64 and OSX 64 bit versions of LibreOffice - built against future LO 4.2

[Fernand Vanrie]

On 14/10/2013 17:30, Heinrich Stoellinger wrote:

Hi Alex,
Thanks for your work! However, the connector you built does 
unfortunately NOT

work on my Linux-Mint-15-LO-4.1.2.3,MySQL 5.5 system.
The one that comes integrated with LO 4.1.2.3 works in principle, but 
garbles up


is this due to the Extension or is it a problem after changing the 
datetime stuff in the API ?


Jésus Corius build a new Windows version for 4.1 , works not for XP , 
works fine for Win7 and Win8 but crasches on some (big 90.000 records)) 
tables with Timestamps and Datetime rfileds?
time fields. E.g., a time (Central Europe) of 20:30:00 is shown in 
LO-Base as
12:20:30, while it is perfectly o.k. when looking at it through the 
MySQL command-

line client.
I had to "revert" back to using the Java Connector for the time being. 
Unfortunately
I really don't have the time to go into the matter myself - at least 
not for the time

being.
Regards
Heinrich


On Mon, 14 Oct 2013 11:56:53 +0200, Alexander Thurgood 
 wrote:



Just a heads up to let you all know that you know that if you :

- can get your hands on a 64bit daily build of LO for OSX (this doesn't
seem available anywhere I can find at the moment);

- or a 32bit or 64bit Linux daily build ;

you might want to try the mysql native C connector extensions I have
managed to build from the current master repo, and which are available
here :

http://sourceforge.net/projects/lomysqlconnectorextension/

Note that the Linux versions were built on Ubuntu/Debian based systems.


These extensions may or may not work with current 4.1.x versions of
LibreOffice, I haven't tested them so wouldn't know.

I have not built for Windows, as I have no build machine for that and
learning to cross-compile for that particular OS does not yet represent
an itch I'm dying to scratch. I believe Jésus Corrius is preparing new
Windows-built connector extensions which should be made available via
the LO extensions website.




Alex








--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Testing when developing LO Base Applications

[Fernand Vanrie]

On 23/09/2013 3:07, James B. Byrne wrote:

I am tasked with writing a quick fix replacement for a very old dbase
application running on WinXP.  I am considering using LO Base with ODBC(SDBC?)
to connect to a Postgresql-9.1 RDBMS hosted on a Linux server.

Assuming that I can get the connectivity between LO on the MS-Win desktops and
the PostgreSQL-9.1 instance on the Linux server host I intend to use the forms
capability of LO to provide the user interface.  Which leads me to my
question.  Is there any testunit-like or Rspec-like framework for designing
and building LO user interfaces;  particularly for testing input forms and
such?

I am not aware of any testing tool at all.
The only advice i can give, is not to use Forms as a user interface.
Make your connection with your server, then use Dialogs, macros and SQL 
statements to build your users interfaces.

Do your printing to spreadsheets instead off Reports
Use the book (and the include macro code) from Roberto Benitez + the 
Base Document from Andrew Pitonyak as a starting point


Hope it helps

Fernand


Are there any issues with respect to Multi-User access via LO forms across
ODBC/SDBC to PostgreSQL that I should be made aware of?




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Macro from command line: ThisComponent.CurrentController not found

[Fernand Vanrie]

On 16/09/2013 18:29, greyspammer wrote:

Hello!

I have a macro which I want to be executed whenever a Writer document is
being converted to a PDF. So I wrote my macro and assigned it to the
appropriate event. And it works. At least, from within a running
GUI-Session.

If I try to do the conversion via command line, I get this error message:
<- snip ->
BASIC runtime error.
Property or method not found: CurrentController
<- snap ->

The command I use to invoke LibreOffice is:
<- snip ->
lowriter --convert-to pdf:writer_pdf_Export  test.odt
<- snap ->

It is later planned to have it run in headless mode on a machine with no X
server, but I removed those options to get an error message.

I assume that in this mode, there is no "CurrentController" (because there
is no Writer window?) and hence, the error. But what can I do about it?
for printing to PDF i assume there must be a "opened" document (who can 
been hidden) as soon the document is open it becomes "ThisComponent" who 
has its "CurrentController"


Hope it helps

Fernand



Create one myself? How?

System is Kubuntu 13.04 with LibreOffice 4.0.2.



--
View this message in context: 
http://nabble.documentfoundation.org/Macro-from-command-line-ThisComponent-CurrentController-not-found-tp4074374.html
Sent from the Users mailing list archive at Nabble.com.




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Incorrect handling of time values in O 4.1.1

[Fernand Vanrie]

Heinrich ,

btw its Flemish (like Dutch) :-)

Bon Soir, Fernand,
I connect to the database using the native MySQL connector.
the connector must at least been recompiled against the 4.1 code maybe , 
just maybe the the dattime problems sould been gone.

I am waiting for a recompiled windows connector to do further tests

Regards
H.S.

On Mon, 09 Sep 2013 19:30:24 +0200, Fernand Vanrie  
wrote:



Heinrich ,
same sort of problems with Windows,  datetime values are scrambled 
sinds 4.1

it is still not defined if this problem is comming from the MySQL
Connector or its due to 

how do you connect to your MySQL server ?

Hello,
I have just filed a bug report regarding erroneous handling of
MySQL-time values
in LO 4.1.1. It happens both when entering data into a table through
Base as well
as later on looking at tables/views. This is QUITE serious in my view.
On top of
that, report builder doesn't run when time values occur in a report.
Date values
are actually han116dled correctly. The same report executed quite o.k.
under 3.6.7.
This certainly blocks me from going to 4.1 for production purposes.

+1

Please look at
bugzilla, bug No. 69116. I am running LO under Debian-Wheezy, 32-bit.
Anybody with
the same problem?
Regards
H.S.










--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Incorrect handling of time values in O 4.1.1

[Fernand Vanrie]

Heinrich ,
same sort of problems with Windows,  datetime values are scrambled sinds 4.1
it is still not defined if this problem is comming from the MySQL 
Connector or its due to 


how do you connect to your MySQL server ?

Hello,
I have just filed a bug report regarding erroneous handling of 
MySQL-time values
in LO 4.1.1. It happens both when entering data into a table through 
Base as well
as later on looking at tables/views. This is QUITE serious in my view. 
On top of
that, report builder doesn't run when time values occur in a report. 
Date values
are actually han116dled correctly. The same report executed quite o.k. 
under 3.6.7.

This certainly blocks me from going to 4.1 for production purposes.

+1

Please look at
bugzilla, bug No. 69116. I am running LO under Debian-Wheezy, 32-bit. 
Anybody with

the same problem?
Regards
H.S.




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: SQLException when using ADO driver and prepared statements

[Fernand Vanrie]

hei,
did some test in the past and found only troubles using ADO, for a MS 
SQL server ODBC is the best option

Replying to myself to add that this is with LibreOffice 4.1.0.4 on Windows
XP.



--
View this message in context: 
http://nabble.documentfoundation.org/SQLException-when-using-ADO-driver-and-prepared-statements-tp4070605p4070606.html
Sent from the Users mailing list archive at Nabble.com.




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LO WRITER BASIC: insert an image, put a drawing-text on top and jump to next page

[Fernand Vanrie]

Dag Alain ,
vlaming ja !

i see you use only the dispatcher you write your macro,
some actions can not been recorded, what not mean there is no dispatch 
action for it, there is a list for all dispatch actions 


on this "hermione" website you find nearly all code you need
do some more Googling for examples and try to use the API based Basic Code.
so google for
Openoffice basixc API insert Image
Openoffice basixc API insert textframe
etc

Groeten Fernand
(maandag ben ik terug op kantoor en daar heb ik ook alle code 
voorbeelden die je nodig hebt)

Hello all,

I'm writing a macro to create a document entirely based on 
database-contents.
I have an image (page-sized) that should come on the first page, and 
then I should put the title on top of it and the jump to the next 
page. The part that follows (TOC + further contents of the document) 
is about finished and working but I have trouble with my title-page.


I tried to record the inserting of the image, then add text on top of 
it using the drawing toolbar, then set the properties of that text to 
centered (horizontal and vertical), size it to the text and then jump 
to the next page.


This resulted in this:

sub afbeelding_en_titel
rem 
--

rem define variables
dim document   as object
dim dispatcher as object
rem 
--

rem get access to the document
document   = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")

rem 
--

dim args2(3) as new com.sun.star.beans.PropertyValue
args2(0).Name = "FileName"
args2(0).Value = 
"file:///home/alain/Data/Indiegroup/Cover%20Offerte%20Site%20Builder.jpg"

args2(1).Name = "FilterName"
args2(1).Value = ""
args2(2).Name = "AsLink"
args2(2).Value = false
args2(3).Name = "Style"
args2(3).Value = "Afbeeldingen"

dispatcher.executeDispatch(document, ".uno:InsertGraphic", "", 0, 
args2())


rem 
--
rem dispatcher.executeDispatch(document, ".uno:InsertDraw", "", 0, 
Array())


rem 
--
rem dispatcher.executeDispatch(document, ".uno:TransformDialog", "", 
0, Array())


rem 
--
dispatcher.executeDispatch(document, ".uno:TextAttributes", "", 0, 
Array())


rem 
--
dispatcher.executeDispatch(document, ".uno:InsertLinebreak", "", 0, 
Array())


As you can see the recording didn't work after the inserting of the 
image and I find no documentation that accurately helps me figure it 
out the InsertDraw, TransformDialog and TextAttributes myself.


Could anybody help me on this one?
Any suggestion is welcome...

Thanks in advance,
Alain






--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Book-writing with Writer

[Fernand Vanrie]

trie the Elaix extension

On 13/08/2013, Virgil Arrington  wrote:

I just did a couple experiments with LO and Writer2epub. I tried converting

the entire 390 page Getting Started book to EPUB. It choked. I then tried
doing the same with just the 18 page introduction. Same result. No EPUB
output file was generated.

I noticed that Writer2epub doesn't like custom styles. It is apparently
designed for fairly simple documents, using LO's built-in styles. It can't
handle the elaborate formatting of the LO User Guides.


That was an ambitious test! Perhaps LaTeX might be better: convert to
(x)html using tex4ht and then compile the epub. Personally, would edit
the xml using a text editor and compile the epub via the command
terminal; compilation is surprisingly easy.




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Problem with eLAIX extension on LibO 4.0

[Fernand Vanrie]

Op 08/08/2013 14:26, Joaquín Lameiro schreef:

i would start with opening de basic code and iliminate the error handlers,
change
On Local Error Goto ErrorHandler
to
rem  On Local Error Goto ErrorHandler

 so on a error you can see on wath code  line there is a error occuring

hope it helps

fernand



Hello.

I have installed the eLAIX extension for Libre Office and it won't work. No 
matter what action I try to perform, I get a message of this kind:
"BASIC runtime error.
An exception of
Type: com.sun.star.container.NoSuchElementException
Message: occurred."

(the message occurs in Swedish, this is a quick translation).

I used eLAIX for Libre Office in other computers and systems, and it worked 
perfectly, so I have no idea what the problem might be.
This time, I am running Libre Office 4.0.4.2 on Windows Vista 32 bits SP 2 and 
I've tried eLAIX versions 4.0.3 (current stable version) and 4.0.1 (first 
version supporting LibO 4.0). I had previously tried eLAIX 4.0.3 on LibO 4.1.0, 
and I thought the problem was due to eLAIX not supporting LibO 4.1, so I 
uninstalled LibO 4.1 and returned to 4.0. Anyway, the problem still the same: 
no matter what version of LibO or eLAIX I use, I get the above error message or 
something similar.

Could you give me a hand on this? Thanks for your kindness.

Best regards,
Joaquín




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Base: In basic, how do you open a form to a particular record number?

[Fernand Vanrie]

Jason ,

this links opens a pdf 
<http://www.baseprogramming.com/OOBasicDatabaseDev.pdf>

As far as I can tell, this website only (and I mean only) has two blog
posts about Java programming. No references, nor anything else that
seems useful. Perhaps the website has changed owner recently?

On Tue, Aug 6, 2013 at 10:05 AM, Fernand Vanrie  wrote:

Jason ,

on the website from Roberto Benitez <http://www.baseprogramming.com/> you
wil find what you are looking for !


This is some example code I'm using that opens a form. How do set set
the current record number of the newly opened form from the basic
script.

Sub OpenDataEntry(oEvent As Object)
  Dim FrmName as string
  FrmName = "Finalization - Data Entry"
  ThisDatabaseDocument.FormDocuments.getByName(FrmName).open()
End Sub

I'm a programmer. Does anyone know where a useable API reference is
for libreoffice basic? I have looked at the "documentation" and there
is no apparent reference to ThisDatabaseDocument , FormDocuments ,
getByName , and etc. Surely there is a real API reference or some
trick I'm missing out there

Thanks
Jason White



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted







--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Base: In basic, how do you open a form to a particular record number?

[Fernand Vanrie]

Jason ,

on the website from Roberto Benitez  
you wil find what you are looking for !

This is some example code I'm using that opens a form. How do set set
the current record number of the newly opened form from the basic
script.

Sub OpenDataEntry(oEvent As Object)
 Dim FrmName as string
 FrmName = "Finalization - Data Entry"
 ThisDatabaseDocument.FormDocuments.getByName(FrmName).open()
End Sub

I'm a programmer. Does anyone know where a useable API reference is
for libreoffice basic? I have looked at the "documentation" and there
is no apparent reference to ThisDatabaseDocument , FormDocuments ,
getByName , and etc. Surely there is a real API reference or some
trick I'm missing out there

Thanks
Jason White




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Book-writing with Writer

[Fernand Vanrie]

Virgil ,

the secret of styles for ebook publishing is the "OutLineLevel" you can 
uses any style but change your paragraph styles to the correct OutlineLevel


TITEL = OutlineLevel 1

Subtitel = OutlineLevel 2

Subsubtitel = OutlineLevel 3 etc...to 9

Wolfgang,

I don't believe I've heard of "structure markup style concept" and I'm 
not sure I understand what you mean. I used WordPerfect for years and 
could never quite get the hang of WP's styles, all the while I took to 
Word's and OO's (now LO's) styles quite easily. When I used WP, 
everything was very typewriter-like, with commands being inserted in a 
linear fashion until they were changed by a later command. Hence the 
reason  was so essential with WP.


Virgil

-Original Message- From: Wolfgang Keller
Sent: Thursday, July 11, 2013 12:17 PM
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Book-writing with Writer


For example, several years ago, my 14 year old son challenged himself
to type a 50,000 word novel in November, which is National Novel
Writers Month. He met his goal, and quickly dropped the project.

As a proud papa, I wanted to put his document to paper. He wrote the
original in WordPerfect, and it was a formatting mess, with stray
tabs, carriage returns, and inconsistent formatting across chapter
and section headings. I began the task of reformatting his 127 page
novel using WordPerfect, the original program. It didn't take long
for me to realize it would take days and days to wade through all of
the formatting codes inserted by WP.


I have to say that unlike MS Word and its clones OO and LO, Wordperfect
*does* allow proper use of styles for "structure markup". Among the
dozens of different document processing applications I have used over
the past 25 years, Wordperfect was one of the best for authoring
strongly structured documents, at par with Framemaker. Unfortunately it
fell into the hands of an incompentent company (at Corel).

Obivously, nothing (besides Indesign with a *competent* typographer
in front of it) beats the typographic output of LyX/LaTeX, so if you
want to produce a PDF ready for print, there's no other choice. I even
use it for letters.

Until they get redesigned to implement a proper "structure markup"
style concept and correct typographic features (all line- and
page-breaking algorithms from LaTeX are open-source), LO and OO have
their value mostly for "generating" documents from databases.

Sincerely,

Wolfgang




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Need Confirmation: since 4.1 MySQL datetime fields are wrangled in LO base tables

[Fernand Vanrie]

I connect with the Windows Native MYSQL connector  (compiled against 
4.0) to a MySQL database


since 4.1 all "DateTime" fields are wrangled  when showing  a table in 
LO base, when changing the values using LO then they are also wrangled 
in the original MySQL table

"date" values seems to be OK

can that been confirmed on other than windows machines and maybe other 
connectors ?


Lionel Elie Mamane suggested  that due to some changes in the base code 
the Windows Connector has to been recompiled against 4.1  ?


Greetz

Fernand

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Book-writing with Writer

[Fernand Vanrie]

On 10/07/2013 5:20, Urmas wrote:

"Pablo Dotro":
I am beginning a large writing project, that will most probably take the
form of a self published, free ebook. 
please dowload the eLAIX extension, there is a manuel for how to start a 
ebook with LO

And while I have created very
long, complex documents before, I have never formatted them as a book.

But I find that there is a gap between
the techniques described there for working with templates, styles and
master documents... and the actual craft needed to make them work.

The tool that you use does not matter. Everything thay you write will 
be decomposed and virtually remade in the DTP program, most likely 
InDesign.






--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Creating EPUB e-books

[Fernand Vanrie]

On 30/05/2013 23:09, Daniel A. Rodriguez wrote:

There has been some discussion about creating EPUB e-books from
OpenOffice and LibreOffice.  One method I recently came across is to
use Sigil to create the EPUB from HTML.  OpenOffice and LibreOffice
can save in HTML format, which can then be used as a source for this
application.

http://code.google.com/p/sigil/

Perhaps better solutions can be found in using the elaix extension or by
saving as docxml and thenfeeding the result through pandoc

what about this extension
http://extensions.services.openoffice.org/en/project/Writer2ePub
as eLaix also a extension who makes a faire export of Writerdoc to a 
Epub document , both extensions are written in Basic who makes them easy 
to change some code to your personal needs. Both extensions lacks a good 
handling of the exported images. (loss of cropping and color 
corrections) I am bussy to paste some code who can make them have a 
better image handling.

greetz
Fernand



--~--~-~--~~~---~--~~
Escuelas Libres :: Porque la educación es mucho mejor cuando es libre
www.escuelaslibres.org.ar
---
Para entrenar, cualquier programa sirve. Para educar, sólo Software Libre.
(Federico Heinz)
---




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Creating EPUB e-books

[Fernand Vanrie]

James ,

there is also a exellent extension around, eLAIX , who creates from 
Writerdocs , Elaix learning modules but also ePUB documents
There has been some discussion about creating EPUB e-books from 
OpenOffice and LibreOffice.  One method I recently came across is to 
use Sigil to create the EPUB from HTML.  OpenOffice and LibreOffice 
can save in HTML format, which can then be used as a source for this 
application.


http://code.google.com/p/sigil/




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] first article on LibreOffice/OpenOffice little known features online

[Fernand Vanrie]

Marco,

There is a lot more:

- With SVG native handled + some macro's + the PDF export,  LO/OO is 
now  a full DTP production tool

- Using the Elaix extension make it also a full EPUP/HTML5 production tool

Greetz

Fernand

On 24/05/2013 13:54, M. Fioretti wrote:

Greetings,
you may remind that a couple months ago I had asked your opinion on what
are the least known features of the free office suites. That project was a
bit delayed, but in case you missed it, the first article is now finally
online at:

http://www.techrepublic.com/blog/opensource/seven-great-features-of-openoffice-and-libre-office-that-you-probably-ignore/4372?tag=mantle_skin;content

you're obviously very welcome to join the discussion at TechRepublic and
to provide even more tips for future articles.

Thanks again for your input,
Marco Fioretti




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] gettextfields

[Fernand Vanrie]

On 9/05/2013 9:13, Vieri wrote:


--- On Thu, 5/9/13, mcmurchy1917-libreoff...@yahoo.co.uk 
 wrote:


Hi Vieri

The form you've created contains a set of controls of which
one or more of
them are of the "Text box" variety.


You may also have other controls on the form such as a
"Check Box", "Label" or
"Push Button" these latter controls don't have the ability
to hold text or
edit text so don't have the .Text property. So for these
controls the code
x.Text will fail.


Try this

Sub EnumerateFields

 oDoc = ThisComponent
 oDrawPage = oDoc.DrawPage
 oForm = oDrawPage.Forms.GetByIndex(0)
   For i = 0 To oForm.getCount()-1
  x =
oForm.getByIndex(i)
  if
x.supportsService("com.sun.star.form.component.TextField")
then
  
   
Print x.getName() & " : " & x.Text
  
End If

   Next
   
End Sub

Thanks Iain.
Your help is much appreciated. The macro works.
Now I'm trying to send HTTPS POST requests to my web server (not succeeding but 
that's another story).
i use a "create a Windows" object to do the posting 
"WinHttp.WinHttpRequest.5.1"


hope it helps
greetz
Fernand


Function MicrosoftTranslate(sLanguageFrom As String, sLanguageTo As 
String, sText As String) As String


  '  On Error Goto err_catch0

Dim ID As String
Dim sURL As String
Dim oH As object
Dim sToken As String

ID = ""
sURL = 
"http://api.microsofttranslator.com/V2/Ajax.svc/Translate?oncomplete=&appId="; 
& ID & "&from=" & sLanguageFrom & "&to=" & sLanguageTo & "&text=" & 
JSencodeURLpart(sText)

sToken = GetAccessToken()
oH = CreateObject("WinHttp.WinHttpRequest.5.1")
oH.Open "POST", sURL, False
oH.setRequestHeader "Authorization", "Bearer " & sToken
oH.send
t = oH.ResponseText

MicrosoftTranslate = mid(t,3,len(t)-3)

Set oH = Nothing

exit_sub:
Exit Function

err_catch0:
  msgbox("err_catch0 " & Err & Error & Erl,48)

Resume exit_sub
End Function

Function GetAccessToken() As String

On Error Goto err_catch2


Dim mtToken As String
webRequest = CreateObject("WinHttp.WinHttpRequest.5.1")
Dim URI As String
Dim txtToken As String

URI = "https://datamarket.accesscontrol.windows.net/v2/OAuth2-13";

'Client ID from https://datamarket.azure.com/developer/applications
Dim clientId As String
clientId = "myclientid"

'Client secret from https://datamarket.azure.com/developer/applications
Dim clientSecret As String
clientSecret = "JTEGDEb1OViegnPz0kzkvRWhOSeNRJpmPgjqauyeV8k="

Dim sRequest As String
sRequest = "grant_type=client_credentials" & _
"&client_id=" & JSencodeURLpart(clientId, false) & _
"&client_secret=" & JSencodeURLpart(clientSecret, False) & _
"&scope=http://api.microsofttranslator.com";

webRequest.Open("POST",URI, False)
webRequest.setRequestHeader "Content-Type", 
"application/x-www-form-urlencoded"

webRequest.send (srequest)
mttoken = WebRequest.ResponseText


   Dim arr As Variant, header As String

header = """access_token"":""" '"&HMACSHA256="
footer = """,""expires_in"":"""
  headerpos = instr(mttoken, header)+len(header)
  footerpos = instr(mttoken, footer)
  tokenl = footerpos-headerpos
txtToken = mid(mttoken ,headerpos , tokenl)
'xray txttoken
'If txtToken = "_request" Then Resume err_catch:

GetAccessToken = txtToken


exit_sub:
 Exit Function

err_catch2:
beep
msgbox("err_catch2 " & Err & Error & Erl, 48)
Resume exit_sub
End Function


Function URLEncode(StringToEncode As String, 
UsePlusRatherThanHexForSpace As Boolean ) As String


On Error Goto err_catch3

Dim TempAns As String
Dim CurChr As Integer

CurChr = 1
Do Until CurChr - 1 = Len(StringToEncode)
 Select Case Asc(Mid(StringToEncode, CurChr, 1))
Case 48 To 57, 65 To 90, 97 To 122
TempAns = TempAns & Mid(StringToEncode, CurChr, 1)
Case 32
If UsePlusRatherThanHexForSpace = True Then
TempAns = TempAns & "+"
Else
TempAns = TempAns & "%" & Hex(32)
End If
Case Else
TempAns = TempAns & "%" & _
Right("0" & Hex(Asc(Mid(StringToEncode, _
CurChr, 1))), 2)
End Select

CurChr = CurChr + 1
Loop
URLEncode = TempAns

exit_sub:
Exit Function

err_catch3:
beep
   msgbox("err_catch3 " & Err & Error & Erl ,48)
Resume exit_sub

End Function



Thanks again!

Vieri






--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] gettextfields

[Fernand Vanrie]

Vieri ,

pleasqe find some working code below

hope it helps:

so every field has a "Placeholder" property  who correspondents with the 
data who commes here from a beamer


Dim aTextFields as Object
Dim i as integer
Dim CurElement as Object
'xray.xray oDocument
aTextfields = oDocument.getTextfields.CreateEnumeration
While aTextFields.hasmoreElements'
CurElement = aTextField.NextElement

If 
CurElement.PropertySetInfo.hasPropertybyName("PlaceHolder")Then

If (CurElement.PlaceHolder = "Lezers") Then
CurElement.getAnchor.setString(sLezers)
ElseIf (CurElement.PlaceHolder = "Mag") Then
CurElement.getAnchor.setString(sNaam)
ElseIf (CurElement.PlaceHolder = "Half") Then
CurElement.getAnchor.setString(sHalf)
Elseif (CurElement.PlaceHolder = "Voll") Then
CurElement.getAnchor.setString(sVoll)
Elseif (CurElement.PlaceHolder = "pr1") Then
CurElement.getAnchor.setString(sPr1)
Elseif (CurElement.PlaceHolder = "prH") Then
CurElement.getAnchor.setString(sPrH)
Elseif (CurElement.PlaceHolder = "prV") Then
CurElement.getAnchor.setString(sPrV)
Elseif (CurElement.PlaceHolder = "advprijs1") Then
CurElement.getAnchor.setString(sadvprijs1)
Elseif (CurElement.PlaceHolder = "ipvprijs1") Then
CurElement.getAnchor.setString(sipvprijs1)
Elseif (CurElement.PlaceHolder = "1jaargang") Then
CurElement.getAnchor.setString(s1jaargang)
Elseif (CurElement.PlaceHolder = "btw6_1") Then
CurElement.getAnchor.setString(sbtw6_1)
Elseif (CurElement.PlaceHolder = "totaal1") Then
CurElement.getAnchor.setString(stotaal1)
Elseif (CurElement.PlaceHolder = "advprijs2") Then
CurElement.getAnchor.setString(sadvprijs2)
Elseif (CurElement.PlaceHolder = "ipvprijs2") Then
CurElement.getAnchor.setString(sipvprijs2)
Elseif (CurElement.PlaceHolder = "2jaargang") Then
CurElement.getAnchor.setString(s2jaargang)
Elseif (CurElement.PlaceHolder = "btw6_2") Then
CurElement.getAnchor.setString(sbtw6_2)
Elseif (CurElement.PlaceHolder = "totaal2") Then
CurElement.getAnchor.setString(stotaal2)


Endif
End if
Wend
Endif


Thanks!

Making progress... finally.

Your code actually retrieved the text within my first "text box" (which is at 
least something!) but then it fails with the error:

LibreOffice 4.0.2.2
BASIC runtime error.
'423'
Text

it points to line:
  Print x.getName() & " : " & x.Text

It may be choking on a "formatted field" within the document.

Just out of curiosity, how did you know that you had to use ThisComponent.DrawPage.Forms? 
As a novice, I find the documentation to be quite confusing and a supposedly 
"simple" task such as getting text field values seems to be quite difficult. I 
mean, I found examples on the net and they all start with something like:

   vEnum = ThisComponent.getTextFields().createEnumeration()
   If Not IsNull(vEnum) Then
 Do While vEnum.hasMoreElements()
   vVal = vEnum.nextElement()

but then I either don't know how to continue or the examples I found on the net 
don't work (maybe outdated OO or LO versions).

BTW, is there an IDE that can auto-complete Basic code (eg. vVal.??? as in the 
example above).

Thanks,

Vieri

--- On Wed, 5/8/13, mcmurchy1917-libreoff...@yahoo.co.uk 
 wrote:


I've created two "Text Boxes" in a
form in a writer document.

I can iterate over them like this grabbing the text as I go


Sub EnumerateFields

 oDoc = ThisComponent
 oDrawPage = oDoc.DrawPage
 oForm = oDrawPage.Forms.GetByIndex(0)
   For i = 0 To oForm.getCount()-1
  x =
oForm.getByIndex(i)
  Print
x.getName() & " : " & x.Text
   Next
   
End Sub



Does this help in anyway?

Iain


On Wednesday 08 May 2013 01:50:02 Vieri wrote:

--- On Tue, 5/7/13, Vieri 

wrote:

--- On Mon, 5/6/13, Andrew Douglas
Pitonyak 

wrote:

On 05/06/2013 05:21 AM, Vieri wrote:

Hi,

I have an odt writer document with 2

input text

fields


(added with the form designer toolbar). I

manually type

text


into one of the fields. I copy/pasted a macro

to see if

I


could grab the text within the input field

but haven't

had


any luck. This is the test macro in Basic:

Sub EnumerateFields

 vEnum =



ThisComponent.getTextFields().createEnumeration()

 If Not IsNull(vEnum) Then
   If

vEnum.hasMoreElements() Then

 Print "OK"
   Else
 Print "NOT

OK"

   End If
 End If

End S

Re: [libreoffice-users] Check Box size in LO Base

[Fernand Vanrie]

On 30/04/2013 12:43, Ian Whitfield wrote:

Hi All

Question regarding LO Base, (being used as a Front End to a MySQL 
Database). (PCLOS, LO 3.6.5.2)


I have eight 'Check Boxes' on my Form that work just fine but I find 
them a little small and can find no way to make them larger. I tried 
"pulling them out"  and changing the Font size but neither of these 
work!!

the model must have a Height and Width property ?


Is there a way of adjusting the size at all?

Thanks for any help.

IanW
Pretoria RSA




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Importing PDF problem

[Fernand Vanrie]

Op 05/04/2013 22:18, David Ronis schreef:

I'm currently working on a large project that requires me to import many
documents from my colleagues, some in word or PDF formats, into a single
file.  Libreoffice doesn't work if I try Insert->File... on a PDF file
(I get an error popup saying Error rereading the file).

I can open the PDF file (in draw) and cut and paste each PDF page into
the document, but that is painful.

Is there a way to make File->Insert work, perhaps via a macro?
it can surly been automated, import the PDF in draw and then export the 
elements to a writerdoc, you will find a lot of code in the "Gimmicks" 
library (gettexts>>getdrawstrings)


hope it helps

Fernand

  If not,
consider this a feature request.

David





--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: BasIe - connecting through JDBC

[Fernand Vanrie]

On 4/03/2013 11:02, Alexander Thurgood wrote:

Le 04/03/13 10:55, Fernand Vanrie a écrit :

Hi Fernand,


On 4/03/2013 10:49, Fernand Vanrie wrote:

Heinrich ,

oeps typo : read : Sinds we uses for all our tables UTF-8 we  have no
encoding problems using OO via ODBC


Yes, I have had better results with UTF-8 too, at least insofar as
accented characters are concerned.

seems logic as LO is totaly UTF-8 based

For "local" sensitive stuff as date  and  time we convert  to there iso 
values  before passing to a MySQL table



Alex





--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: BasIe - connecting through JDBC

[Fernand Vanrie]

On 4/03/2013 10:49, Fernand Vanrie wrote:

Heinrich ,
oeps typo : read : Sinds we uses for all our tables UTF-8 we  have no 
encoding problems using OO via ODBC


Sinds we uses for all ore tables UTF-8 we (never) have encoding 
problems using OO via ODBC

Hello Alex,
I create ALL tables with
.
.
CHARACTER SET latin1 COLLATE latin1_german1_ci
.
This should obviously allow for o-Umlaut etc
In LO I specify ISO-8859-15/EURO for the codepage within the properties
dialogue for the .odb files.
You are most likely right about the "display glitsch" in both JDBC 
and ODBS.

And, yes, it seems to happen more under ODBC.
Regards
H


On Mon, 04 Mar 2013 09:00:27 +0100, Alex Thurgood 
 wrote:



Le 02/03/2013 14:10, Heinrich Stoellinger a écrit :

Hi Heinrich,


Hello,
Seeing as the Native MySQL-connector seems to be a "difficult" birth -
I tried both ODBC and JDBC lately. Unfortunately both seem to be 
unusable!
JDBC: I cannot get it to accept German special characters (even 
though I

specify codepage ISO-8859-15/EURO).


Where did you specify the codepage ? In the connection string ? Or 
is it

simply an option of the table to which you are writing ?

Also, when inserting you rows into the database, both with JDBC and 
ODBC,
string default values are shown with apostrophies at the beginning 
and end.

If one then re-selects the row, the fields are shown correctly
(i.e. without the apostrophies). This might be kind of o.k. for me 
as I
have around 30 years of IT-experience behind me, but certainly NOT 
o.k. for

the average uninitiated user...


Seems like a display glitch/bug...reported bug ?


ODBC: default values as specified within a table creation show kind of
"random"
values in columns of inserted tuples. When refreshing the display or
re-selecting
the tuplethe values are displayed correctly.


Could be the same or similar bug to the one your describe above.
Refreshing datasets still seems to be a problem sometimes. I have
noticed that more so with ODBC than JDBC.


Alex











--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: BasIe - connecting through JDBC

[Fernand Vanrie]

Heinrich ,

Sinds we uses for all ore tables UTF-8 we (never) have encoding problems 
using OO via ODBC

Hello Alex,
I create ALL tables with
.
.
CHARACTER SET latin1 COLLATE latin1_german1_ci
.
This should obviously allow for o-Umlaut etc
In LO I specify ISO-8859-15/EURO for the codepage within the properties
dialogue for the .odb files.
You are most likely right about the "display glitsch" in both JDBC and 
ODBS.

And, yes, it seems to happen more under ODBC.
Regards
H


On Mon, 04 Mar 2013 09:00:27 +0100, Alex Thurgood 
 wrote:



Le 02/03/2013 14:10, Heinrich Stoellinger a écrit :

Hi Heinrich,


Hello,
Seeing as the Native MySQL-connector seems to be a "difficult" birth -
I tried both ODBC and JDBC lately. Unfortunately both seem to be 
unusable!
JDBC: I cannot get it to accept German special characters (even 
though I

specify codepage ISO-8859-15/EURO).


Where did you specify the codepage ? In the connection string ? Or is it
simply an option of the table to which you are writing ?

Also, when inserting you rows into the database, both with JDBC and 
ODBC,
string default values are shown with apostrophies at the beginning 
and end.

If one then re-selects the row, the fields are shown correctly
(i.e. without the apostrophies). This might be kind of o.k. for me as I
have around 30 years of IT-experience behind me, but certainly NOT 
o.k. for

the average uninitiated user...


Seems like a display glitch/bug...reported bug ?


ODBC: default values as specified within a table creation show kind of
"random"
values in columns of inserted tuples. When refreshing the display or
re-selecting
the tuplethe values are displayed correctly.


Could be the same or similar bug to the one your describe above.
Refreshing datasets still seems to be a problem sometimes. I have
noticed that more so with ODBC than JDBC.


Alex








--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Vector Graphics in PDF

[Fernand Vanrie]

Op 03/03/2013 23:09, Ferry Toth schreef:

Berengar Lehr wrote:


Hy,

I'm asking if anyone could provide me with a list of vector graphics
formats that can be used in ODT _and_ that will be exported as vector
graphic.
SVG e.g. is not a valid example: while it can be used in ODT, SVG will be
rasterized during conversion to PDF. ODG on the other hand works for both.
WMF/EMF work for both but I could not find *nix libs for these microsoft
formats.
Any other ideas?

In the ideal case the source would be svg and I would import that into Draw.
Currently this conversions does not goes 100% perfect
sinds 4.0 most problems are solved and no need to uses Draw, place the 
SVG directly in writer

(like closed shapes
become open and because of that don't fill).

At this time importing pdf goes pretty good in most cases. If needed I do
some touch ups in Draw and then paste the whole thing into Writer (as a Draw
object, so you need to 'paste as').

This procedure seems to work well even for complex stuff like Autocad
drawings (dxf), and PCB layouts (gerber files)


Thank you,
waiting patiently,
Ber







--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] BasIe - connecting through JDBC

[Fernand Vanrie]

 Dan ,

Any interest to build a Windows Version ?

My compagny is willing to provide the hardware an pay for your time ?

Greetz

Fernand

On 03/02/2013 08:10 AM, Heinrich Stoellinger wrote:

Hello,
Seeing as the Native MySQL-connector seems to be a "difficult" birth -
I tried both ODBC and JDBC lately. Unfortunately both seem to be 
unusable!

JDBC: I cannot get it to accept German special characters (even though I
specify codepage ISO-8859-15/EURO).
Also, when inserting you rows into the database, both with JDBC and 
ODBC,
string default values are shown with apostrophies at the beginning 
and end.

If one then re-selects the row, the fields are shown correctly
(i.e. without the apostrophies). This might be kind of o.k. for me as I
have around 30 years of IT-experience behind me, but certainly NOT 
o.k. for

the average uninitiated user...
ODBC: default values as specified within a table creation show kind 
of "random"
values in columns of inserted tuples. When refreshing the display or 
re-selecting

the tuplethe values are displayed correctly.
I yearn for the native connector but unfortunately really DON't have 
the time

to build it myself...
Regards
Heinr
 What OS are you using? I have built a mysql-connector-ooo.oxt 
(1.0.2) on Ubuntu 12.04. With it I have connected to a MySQL server 
5.5 both locally and remotely. I did this using LO 4.0.0.3, LO 
4.0.1.1, and 4.1.0.0+alpha (the build created with the connector. 
Today I plan to install Mandriva to see whether it will work with it. 
It is alpha until sufficient testing is done.


--Dan




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] BasIe - connecting through JDBC

[Fernand Vanrie]

Heinrich,

diid you trie the native aOO connector made by Ariel C.H.
it seems it works fine on LO 3.6 nut alos no longer on 4.0
Ariel told me his extension can been recompilid using the SDK (without 
the whole code base) but i simply do not know how to this. My compagny 
is willing to pay for this services, any Volunteer ?


Greetz

Fernand

Hello,
Seeing as the Native MySQL-connector seems to be a "difficult" birth -
I tried both ODBC and JDBC lately. Unfortunately both seem to be 
unusable!

JDBC: I cannot get it to accept German special characters (even though I
specify codepage ISO-8859-15/EURO).
Also, when inserting you rows into the database, both with JDBC and ODBC,
string default values are shown with apostrophies at the beginning and 
end.

If one then re-selects the row, the fields are shown correctly
(i.e. without the apostrophies). This might be kind of o.k. for me as I
have around 30 years of IT-experience behind me, but certainly NOT 
o.k. for

the average uninitiated user...
ODBC: default values as specified within a table creation show kind of 
"random"
values in columns of inserted tuples. When refreshing the display or 
re-selecting

the tuplethe values are displayed correctly.
I yearn for the native connector but unfortunately really DON't have 
the time

to build it myself...
Regards
Heinr




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Vector Graphics in PDF

[Fernand Vanrie]

On 28/02/2013 23:27, Berengar Lehr wrote:

So thank you for your answeres!

What I do is automatically produce PDF reports using xml-templates, I'll
just write down, what I do:

1. ODT --extract--> multiple XML files
2. content.xml --via python-script--> content.xml.template
3. content.xml.template --via go-binary--> parsed content.xml
4. multiple XML files --compress--> ODT
5. ODT --via libreoffice--> PDF

Diagrams are generate from data and templates…
a) graphic.svg.template --via go-binary--> graphic.svg
b) graphic.svg --via inkscape--> graphic.pdf
c) graphic.pdf --via libreoffice--> graphic.odg
…and odg-files are included


this have no sence anymore, just place your SVG (after opening  and 
resaving in InScape) in your ODT and export tot PDF


Having a working process, I now try to speed up PDF generation by
canceling out the most time consuming process: c) libreoffice pdf2odg
So yeah, I could probably convert svg2png which would cost either space
or image details. But I was looking (perhaps just for the sake of
"doing-it-right") for better, more universial usable graphics format.

But I'll probalby just wait for LO 4.0.
trie to open the SVG first in Draw, then copy the Shape not as Picture) 
into the ODT and you will have also Vector output in your PDF

Thanks and I'd still be happy to share experience combining vector
graphics in ODT and PDF


Am 28.02.2013 22:08, schrieb Doug:

On 02/28/2013 02:44 PM, webmaster-Kracked_P_P wrote:

On 02/28/2013 02:24 PM, Berengar Lehr wrote:

Hy,

I'm asking if anyone could provide me with a list of vector graphics
formats that can be used in ODT _and_ that will be exported as vector
graphic.
SVG e.g. is not a valid example: while it can be used in ODT, SVG
will be
rasterized during conversion to PDF. ODG on the other hand works for
both.
WMF/EMF work for both but I could not find *nix libs for these microsoft
formats.
Any other ideas?

Thank you,
waiting patiently,
Ber


The problem, it seems to me, is that Word Processor packages are not
really built to handle "vector" graphics.

Could you tell us why you need the PDF file to not have any
"conversion" to "raster. . ." when creating a PDF file?

I tend to have the vector graphics opened in Inkscape [or similar] and
export the image to PNG, GIF, or JPG, that LO can use.  I almost never
try to include vector graphics in a text document. It just never works
out.


I assume you can save your vector graphics file that you made in a cad
program in some format like .dwg or .dxf, so why not just attach it to
your LO/OO message?

--doug




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Is LO BASIC Limited to Only 1 Dialog Box at a Time?

[Fernand Vanrie]

Hal ,

It can be done!

I don't know if it's dangerous or not, but the link on oooforum.org (when it's up) either 
had a link to another post or I found this by searching for "modal dialog" on 
that site.  This example (http://www.oooforum.org/forum/viewtopic.phtml?t=8481) uses AWT, 
going through LO, to make windows.  You can't use the Dialog Designer in the LO IDE, but 
you get full control over your window.

I took this example, ran it, and it opened a window.  So I copied the code in 
the Main routine, pasted it in at the end of that routine, and it created 
another window with some differences I edited in.

So, as best I can tell, you can't create multiple dialog windows with "normal" 
dialogs in LO,



Yes you can, but it depends how you construct the dialog

1: Modal
oDialogcontrol.setvisible(true)
oDialogControl.execute

here the dialog is opened and only after closing your code comes back to 
just behind the "excute", so al new dialogs (and other actions) have to 
been opened from a button on the first dialog, the user can only works 
in the last opened dialog


2: Non Modal
public bEnd1 as boolean
odialogControl1.setvisible(true)
Do
Wait 100
Loop while not bEnd1

here the dialog is opened and your code is avancing after the setting 
of  bEnd1, the dialog is closed when setting bEnd1 to true.. The user 
can now working outside the dialog  and open different dialogs  ect..

every bEnd and every dialog object have to have different namens.
Minus  is that Throbers an taskbars and time keeping not works because 
the machine is confused with the bEnd loops...

public bEnd2 as boolean
odialogControl2.setvisible(true)
Do
Wait 100
Loop while not bEnd2
3: AWT
   is non-modal and  Throbbers and task bars and time keeping are working

hope it helps

Fernand

but you can do it if you use the AWT toolkit.

But for my own stuff - this got me thinking about what I wanted to do and in 
that time I've had to think, I'm beginning to wonder if I shouldn't just use my 
other idea, which would store notes in a LO document and on the computer hard 
drive, too - it'd basically be a stick notes program that integrates with LO so 
notes can be associated with a document.  But that's just a side not that, in 
the time it took to research this, I may have found a different way to do 
things that doesn't need two dialogs open at once.


Hal

On Feb 25, 2013, at 7:01 PM, Andrew Douglas Pitonyak  
wrote:


On 02/25/2013 01:52 PM, Hal Vaughan wrote:

I've been experimenting because I want to write a sticky-note program that will 
allow a user to write sticky notes that accompany a document.  When you switch 
from one document window to another, the notes from the 1st would close and the 
notes from the 2nd would open (if you've already opened them).

The problem I'm running into is that if I display a dialog (with 
oDialog.setVisible(True)), I can display one, but then the next one I try to 
display doesn't appear.  I even tried to display a dialog then put up a message 
box, and that won't work.

Is this a limit with LO BASIC?  Can only one dialog be open at a time?  Or is 
there a way to get around this?

(I'm thinking if I can't, then I might write a program in another language to 
do this, but that would be tougher and would be like almost any sticky note 
program.)



Hal

http://forum.openoffice.org/en/forum/viewtopic.php?f=20&t=5815

THis link used to have something useful, so, if this forum is up, it should be 
useful!

http://www.oooforum.org/forum/viewtopic.phtml?t=14095

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted







--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] oooforum.org

[Fernand Vanrie]

 Andrew ,

when this "site" is gone then its also a terible lost of knowledge and 
code examples for both communities,


Greetz

Fernand


On 02/24/2013 10:17 PM, Tim Lloyd wrote:
I am just flicking through the LO4.0 "getting started" guide and 
there is a reference to http://www.oooforum.org/. When I click on 
that link (fedora/firefox/seamonkey) the browser just sits there and 
eventually times out. Is this address still valid?


I understand that the LO folks are standing up their own forum, but it 
is still in test mode.


http://forum.libreoffice.org/

Apache hosts the user forum now, so it should stay reliable

http://forum.openoffice.org/

As for the oooforum.org, It is no longer reliable. I hear reports that 
it comes and goes. Lately, when I go there it seems to be more likely 
that it is down than up. I should probably ping Ed and see if he still 
pays lip service to making it function.





--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Going to an "OnExit' Routine On Dialog Button Event

[Fernand Vanrie]

Op 24/02/2013 15:32, Andrew Douglas Pitonyak schreef:


On 02/23/2013 03:24 AM, Hal Vaughan wrote:
I have a macro in LO BASIC that sets up a dialog, then, instead of 
executing it, I do:


oDialog.setVisible(TRUE)

This dialog box contains a progress bar and, while testing it, I 
realized it's frustrating for longer documents to have a progress bar 
and force me to sit and wait without a way to cancel it.  So I added 
a Cancel button.
set in your loop who is running he progress bar, a "halt" who sould(on 
reglar times) check the state of your Cancel button

hope it helps

Fernand


This dialog is in my library and I'd like to find a way to set up the 
"Cancel" button so it can either stop the script or possibly even 
call a clean up routine when it's been pressed - or have it change 
the state of a global variable so a routine could see if it's been 
pressed.


I know there are event handlers so I can do something on events like 
MouseOver and so on.


And if I were not putting this in a library, I could easily specify, 
in the Dialog Settings, which routine to call on Cancel.


But if I want the dialog in a library, is there a way, when calling 
the function that sets it up, to specify a routine to call when the 
Cancel button is pressed?  Or is there some way to create a global 
variable or any kind of flag that I could have changed when the 
button is pressed?


In other words, other than putting in a "Stop" command, or specifying 
one routine name to call when an event triggers it, can I pass on the 
name or pointer to a routine that would be called when the button is 
pressed?



Hal
Disclaimer: I have never tried or considered what you desire to do, 
but. I suppose that I would first test this (should be easy to do).


First, what is it that you are doing that you desire to interrupt? 
Specifically, is it your macro code that is running for a long time, 
or, did it make a call that is running for a long time? If it is your 
own macro, I would try setting a global in an event handler and check 
that global in your code. You could create a quick test



while the "cancel requested global is not true" and two minutes has 
not elapsed

  do something like add zero to a variable

Print "I am out and finished"


Then, you can check to see if you can set the global variable by 
clicking on a cancel button and having the event handler be called. I 
am not optimistic that this will work, but, it is worth a try. I am 
very interested in your results.






--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] MySQL Native Connector for 32 bit LibreOffice on Ubuntu 12.04

[Fernand Vanrie]

 Heinrich ,

Trie to install the connector with the latest working version
then update this version to 4.0 and with a bit of luck you end up 
with a working connector in 4.0


hope it helps

BUT: we need to find a solution for this problem, for aOO there is also 
a connector, it works fine with LO 3.6 , for using it in LO 4.0 we need 
to re-compile the extension using the SDK and not the whole code base 
who looks a less complex task


Greetz

Fernand

Hello,
Just to confuse things a bit...
When I installed LO 4.0.0.3 on my Debian-Wheezy system, the native 
connector
worked fine from the beginning. It does NOT work on Mint-Nadia or 
Windows/Vista.

Both are 32-bit systems.

Obviously - as somebody posted earlier - the connector is VERY 
"sensitive"
to the underlying OS, MySQL and LO-versions. I suspect it must be a 
nightmare
to maintain so as to make it work "independent" of which OS etc you 
use...


By the way, I tried "reverting" to ODBC/JDBC - not really usable for 
connecting
with LO. E.g., when entering new tuples into a table, default values 
are not
shown as defined (in create/alter table). However, when selecting the 
tuple
thereafter espectially so as to see what has happened, the values are 
shown
correctly (in SOME cases, not so in others). Under an ODBC connection, 
after

a while of working with Base, the CPU consumption increases considerably.
It becomes "normal" again only after saving LO/Base. So, at this point 
in time

there really is no choice but to get the native connector going.

I can try to install libmysqlclient18 and libmysqlcppconn5 on my 
Mint-system
and see what happens. Where did you download the AOO-native connector 
from

and which version? The version I found is from 2011.
Regards
H.S.


On Thu, 21 Feb 2013 04:21:30 +0100, Dan Lewis 
 wrote:



  I have a 32 bit laptop running Ubuntu 12.04. On it I have
installed LO 3.6.5.2 and 4.0.0.3.
  This evening I was going to built LO 4.0.0 with the native
connector for MySQL. In the process I had to download some files needed
for autogen.sh to work properly. Among these are two groups.
  These were the ones that autogen.sh had to have before it stopped
with an error message at line 201: libgnomevfs2-common,
libgnomevfs2-bin, libgnomevfs2-0, libgnomevfs2-dev, libgnomevfs2-extra,
libgnomevfs2-0-dbg.
  Prior to downloading the master build, I installed two files that
Alex Thurgood suggested: libmysqlclient18 and libmysqlcppconn5 using
synaptic. I also noticed these files were available: libmysqlclient-dev
and libmysqlcppconn-dev. So I installed these also.
  I had run autogen.sh a couple of times with an error stopping it
at line 201. The error led me to the first group of files which I also
installed using synaptic. Then I ran (at Alex' suggestion):
autogen.sh --with-ext-mysql-connector --with-system-mysql. (It should
have also had an option containing the path to the external mysql
connector.) So, it ignored the first option I gave it.
  Since then, I have installed the MySQL Native Connector that I had
downloaded from AOO a couple of months ago. I did this to both LO
3.6.5.2 and 4.0.0.3. I have a Base file which I use to connect to my
MySQL server using the native connector. Now I can access MySQL using
this file with both 3.6.5.2 and 4.0.0.3.
  So the reason for this email including the QA people is that I
would like a simple test done by someone with a 32 bit Debian system and
MySQL server. Please install the AOO MySQL native connector. Also
install these two files: libmysqlclient18 and libmysqlcppconn5. With
these installed, can you connect to MySQL? If so, part of our problem is
solved.
  Tomorrow, I am going to run autogen.sh with the three needed
options. Hopefully, I will build a native connector for LibreOffice.

--Dan







--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] head format does not change

[Fernand Vanrie]

Jaap ,

probably, the "depends on property" of the format is involved in this 
behaviour


hope it helps

Fernand

In a document is a Head 1 preformated and in Arial font

Now I come across a Head 1 in Verbena. So I do change the Head 1 into 
an other format and than back to Head 1
Now I expect this Head 1 to be in Arial (because that is the way Head 
1 in this doc is preformatted)

But nothing has changed.

How come, what to do?






--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] MySQL on a network

[Fernand Vanrie]

 Heinrich ,

fine, in the past there where some issues about "remote" connections, 
but how do you manage the "security" of your connection


greetz

Fernand
On Sat, 16 Feb 2013 23:44:09 +0100, Dan Lewis 
 wrote:



   I can connect to the MySQL server (5.5) on the same computer
using localhost. But how do I connect to a MySQL server on another
computer on the same network? I can not find it in the MySQL manual, or
I don't know where to look in it.
  I use MySQL Workbench for administrative purposes.

--Dan


Hi Dan,
When you define your MySQL-database under LO-Base, specify the 
hostname (or the
IP-address) of the server as well as the port (usually 3306) instead 
of "localhost".

I am actually using a MySQL-server over the internet. It works o.k
Regards H




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] How do I change the case of a field in writer?

[Fernand Vanrie]

 paul,

add a style to the text in the field

I'm using writer to import data from a database.   Can I set the format on
the field so some entries will be all caps and some will only capitalize the
first letter of a word?  I want to insert names from the database.   Most
entries I want to have only the first letter of the name capitalized, but
some entries I want the name to be all caps.

Thanks,
Paul Whitehurst
whan...@aol.com



--
View this message in context: 
http://nabble.documentfoundation.org/How-do-I-change-the-case-of-a-field-in-writer-tp4035156.html
Sent from the Users mailing list archive at Nabble.com.




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Base Form Q: Default a field from a macro

[Fernand Vanrie]

Adam ,

do the macro run by a event from the field

sub runfromevent(oevnt)
' the field

ofield =oevnt.source
 etc.

hope it helps

fernand


Is it possible to assign a form control [field] a default value from a
Macro?

I need to have a field that defaults to a value generated by calling a
macro [function].
'



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Need comfirmation about no function of Modeless Dialogs in 4.0

[Fernand Vanrie]

Leif,

Thanks, the grey window can now have a container with controls who acts 
like a dialog.


so Linux is OK,

it helps and it points to Windows :-)

It works for me (I see an emty grey window but not with a title).

Running LibreOffice 4.0.0.2 on 32bit deb_Linux.

Hopes this can help ;-)

Chhers,
Leif Lodahl


2013/1/29 Fernand Vanrie 


We uses the Basic codelines below to make Modeless Dialogs, sinds 4.0 we
end up with a non-visible window
is this a Windows only problem or a more general regression due to changes
in the API ?,
it was working until 3.6.4  Windows

Greetz

Fernand

Sub Main
   oDoc = ThisComponent
   oParentFrame = oDoc.CurrentController.Frame
   oPeer = oParentFrame.ContainerWindow
   oToolkit = oPeer.Toolkit

   oWindow = CreateNewWindow(oToolkit,**oPeer,150,150,200,200)
   oFrame = CreateUnoService("com.sun.**star.frame.Frame")
   oFrame.initialize(oWindow)
   oFrame.setCreator(**oParentFrame)
   oFrame.setName("NewFrame")
   oFrame.Title = "New Frame"

   oParentFrame.getFrames().**append(oFrame)

   oWindow.setVisible(True)
End Sub


Function CreateNewWindow( _
   oToolkit,oParent,nX,nY,nWidth,**nHeight) As Object
   aRect = CreateUnoStruct("com.sun.star.**awt.Rectangle")
   With aRect
 .X = nX
 .Y = nY
 .Width = nWidth
 .Height = nHeight
   End With
   aWinDesc = CreateUnoStruct("com.sun.star.**awt.WindowDescriptor")
   With aWinDesc
 .Type = com.sun.star.awt.WindowClass.**TOP
 .WindowServiceName = "dialog"
 .ParentIndex = -1
 .Bounds = aRect
 .Parent = oParent
 .WindowAttributes = _
   com.sun.star.awt.**WindowAttribute.MOVEABLE + _
   com.sun.star.awt.**WindowAttribute.CLOSEABLE
   End With
   CreateNewWindow = oToolkit.createWindow(**aWinDesc)
End Function


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
org 
Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
Posting guidelines + more: http://wiki.**documentfoundation.org/**
Netiquette <http://wiki.documentfoundation.org/Netiquette>
List archive: 
http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/>
All messages sent to this list will be publicly archived and cannot be
deleted





--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Need comfirmation about no function of Modeless Dialogs in 4.0

[Fernand Vanrie]

We uses the Basic codelines below to make Modeless Dialogs, sinds 4.0 we 
end up with a non-visible window
is this a Windows only problem or a more general regression due to 
changes in the API ?,

it was working until 3.6.4  Windows

Greetz

Fernand

Sub Main
  oDoc = ThisComponent
  oParentFrame = oDoc.CurrentController.Frame
  oPeer = oParentFrame.ContainerWindow
  oToolkit = oPeer.Toolkit

  oWindow = CreateNewWindow(oToolkit,oPeer,150,150,200,200)
  oFrame = CreateUnoService("com.sun.star.frame.Frame")
  oFrame.initialize(oWindow)
  oFrame.setCreator(oParentFrame)
  oFrame.setName("NewFrame")
  oFrame.Title = "New Frame"

  oParentFrame.getFrames().append(oFrame)

  oWindow.setVisible(True)
End Sub


Function CreateNewWindow( _
  oToolkit,oParent,nX,nY,nWidth,nHeight) As Object
  aRect = CreateUnoStruct("com.sun.star.awt.Rectangle")
  With aRect
.X = nX
.Y = nY
.Width = nWidth
.Height = nHeight
  End With
  aWinDesc = CreateUnoStruct("com.sun.star.awt.WindowDescriptor")
  With aWinDesc
.Type = com.sun.star.awt.WindowClass.TOP
.WindowServiceName = "dialog"
.ParentIndex = -1
.Bounds = aRect
.Parent = oParent
.WindowAttributes = _
  com.sun.star.awt.WindowAttribute.MOVEABLE + _
  com.sun.star.awt.WindowAttribute.CLOSEABLE
  End With
  CreateNewWindow = oToolkit.createWindow(aWinDesc)
End Function


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] MySQL-Native Connector for 4.0

[Fernand Vanrie]

Who is filling the issue ?

Michael , others,

 the MySQL native connector is installing and working well on LO 4.0 
dev with Windows XP


but as Michael says, not on LO 4.0 rc1 with Windows 7 (LO 3.6 is working)

and also  NOT on LO rc1 with  Windows 8, failed to install due to some 
pathsettings.


the latest Connector made for OO apache fails also under LO 4.0
I can confirm that the MySQL native connector will not install with 
Windows

7 64bit but gives the error message listed below by Heinrich. The
connector continued to work with LO3 versions.
regards
Mike

On Tue, Jan 15, 2013 at 7:44 PM, Heinrich Stoellinger 

wrote:
Hello, Has somebody compiled/tested the native connector under 4.0?
For me it does work using it with 4.0.0.1, build ID:527, running
under Debian-Wheezy. It does NOT work under Linux-Mint-Maya or
Windows/Vista
(I cannot activate it, keep getting the message
loading component library failed:
file:///home/rainermusik/.**config/libreoffice/4/user/uno_**
packages/cache/uno_packages/**luh0h0m4.tmp_/mysql-connector-**
ooo-1.0.1-linux-intel.oxt/**mysqlc.uno.s
Regards
Heinrich
--
Erstellt mit Operas revolutionärem E-Mail-Modul:
http://www.opera.com/mail/

--
For unsubscribe instructions e-mail to: 
users+help@global.libreoffice.**

org 
Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
unsubscribe/ 


Posting guidelines + more: http://wiki.**documentfoundation.org/**
Netiquette 
List archive: 
http://listarchives.**libreoffice.org/global/users/

All messages sent to this list will be publicly archived and cannot be
deleted








--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] MySQL-Native Connector for 4.0

[Fernand Vanrie]

Michael , others,

 the MySQL native connector is installing and working well on LO 4.0 
dev with Windows XP


but as Michael says, not on LO 4.0 rc1 with Windows 7 (LO 3.6 is working)

and also  NOT on LO rc1 with  Windows 8, failed to install due to some 
pathsettings.


the latest Connector made for OO apache fails also under LO 4.0

I can confirm that the MySQL native connector will not install with Windows
7 64bit but gives the error message listed below by Heinrich.  The
connector continued to work with LO3 versions.
regards
Mike

On Tue, Jan 15, 2013 at 7:44 PM, Heinrich Stoellinger 
wrote:
Hello, Has somebody compiled/tested the native connector under 4.0?
For me it does work using it with 4.0.0.1, build ID:527, running
under Debian-Wheezy. It does NOT work under Linux-Mint-Maya or
Windows/Vista
(I cannot activate it, keep getting the message
loading component library failed:
file:///home/rainermusik/.**config/libreoffice/4/user/uno_**
packages/cache/uno_packages/**luh0h0m4.tmp_/mysql-connector-**
ooo-1.0.1-linux-intel.oxt/**mysqlc.uno.s
Regards
Heinrich
--
Erstellt mit Operas revolutionärem E-Mail-Modul:
http://www.opera.com/mail/

--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
org 
Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
unsubscribe/
Posting guidelines + more: http://wiki.**documentfoundation.org/**
Netiquette 
List archive: 
http://listarchives.**libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted





--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: MySQL-Native Connector for 4.0

[Fernand Vanrie]

On 15/01/2013 17:36, Alexander Thurgood wrote:

Le 15/01/13 16:39, Fernand Vanrie a écrit :

Hi Fernand,


Connector works fine for LOdev4.0 and windows XP

Thanks for the info. Do you build it yourself, or did you get it from
the AOO project ?

i still use a extension MySQL Connector 1.0.1  made by oracle :-)




Alex






--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: MySQL-Native Connector for 4.0

[Fernand Vanrie]

Alexander ,

Connector works fine for LOdev4.0 and windows XP

Hi Tom,


I would not advise attempting to build it on XP or anything Windows
unless you really know what you are doing. Building on Linux is far
easier on the whole, as everything is more or less either pre-installed,
or easy to add in the right place via the package management system.
Virtually anything based on Ubuntu 12.04 works, not sure about 10.04
though, as that is getting on a bit now and some of the library versions
will probably be too old.

Alex




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] polish characters PDF problem

[Fernand Vanrie]

Gerard ,

maybe you are hit with the problem ( found for Windows XP) that LO only 
UTF-8 encoding support


some fonts do not have this UFT-8 code page,

so start to trie to use a font who is 100% compatible with UTF-8 or trie 
later Windows versions (7-8)


hop it helps

Fernand

Hi everybody

i have problem with PDF exporting in my Liebreofice version.

i have problem with PDF exporting in my Libreoffice version.
When I type dokument everything work properly and i have polish characters eg. 
ą  ł ó
but when I try to export document such as PDF, polish characters disappear, and 
i have blank fields between normal letters.


anybody know what problem is?

thansk


Gerard Lebik

http://gerardlebik.com/






--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: [Writer] Regular expressions

[Fernand Vanrie]

gordom,

a macro can do the job , have a look at the standard LibreOffice macro's 
you find in every document)


you can also tranfer the text to a spreadsheet and  use formula like 
if(left(cellstring,3) = 'set:');'nothing', cellstring)

then recopy to spreadsheet to a writerdoc and replace 'nothing'

hope it helps

Fernand

W dniu 2013-01-08 21:17, Nino Novak pisze:

Am 08.01.2013 21:11, schrieb gordom:

W dniu 2013-01-08 20:20, Mirosław Zalewski pisze:

Since LibreOffice regex engine is crippled and don't support
lookaheads, the
short answer is:
no, you can't do that.


That's a pity.


but only if it's really true ;-)



BUT do lines you want to delete happen to fall into some common
pattern? In
your sample (which may or may not be representative for entire text)
they
does. In fact you want to delete all lines that start with number
followed by
letter. You can use this regexp to match these lines:

^[0-9]+.*



Unfortunately my sample wasn't very accurate and can't be regarded as
fully representative. The pattern is more complex actually.


Then you should try to show a better example as Regex are pattern
matching and without knowing the pattern we cannot guess how to match it
;-)

Nino



In "real" life :-) there are lines starting with letters also. Only 
these with "Set:" at the beginning should be left, rest is going to be 
deleted.


Set:   01SA34509
0109SA
011017B
S01020207B
010902B
01090002
011007B
01090001
090110
Set:   0134501
011101
HB01110102
01110103
080908
Set:   0111679SE
0111SE

I'm surprised that there is no simple way to find everything except 
"Set:.+$"


gordom




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] LibreOffice no longer works with Windows 1252 encoding ?

[Fernand Vanrie]

Maybe not the right forum ?
but is this new encoding behaviour intentional or a issue ?
since 3.6.3 LO no longer shows correctly non-standard-ascii characters 
with text imported from a database using Windows 1252 encoding(during 
the import), UTF-8 encoding now works fine but gives problems when 
exporting to PDF.


Older an recent files with text imported with a Windows 1252 encoding 
give problems when exporting to PDF,
Some fonts like Futura Sdt (Opentype)  has only  the  "Latin 1252" code 
page and do not shows up when opening in a standard PDF viewer an do not 
print when using a PDF engine.
the Adobe Viewers gives the famous  error "Can not extract the embedded 
fond 'FA+FuturaStdMedium' some characters"
We found this behaviour  on Windows XP machines, PDF exported on Windows 
7 do not have this problem ?


The faulty PDF export is a regression starting from  LO 3.6.3 and also 
present in LO 3.4 beta.


ok: Window XP is a ending story, but maybe someone has the same problems 
with non-Windows machines


Greetz

Fernand




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LO Base Colour settings in Form design.

[Fernand Vanrie]

Ian ,

or maybe just place a listener on the filed who contains "Cat" data.
on changing the field content place a event who run a macro:

The eventlistner produce a oEvent object who contains the "source" = 
field object and the source.context = Form object


IF Oevent.source.model.text = "abc" THEN Oevent.source. context . 
backgroundcolor == "" OR ...


hope it helps

Hi All

I have a Membership Database running on MySQL 5.1 with an LO Base 
Front end Ver 3.6.2.2. All running on PCLOS 2012.
My Members fall into two or three different Categories and I would 
like to be able to show this on screen.


SO - Is it possible to add in a statement to the Form design so that 
the background colour of the Form will change depending on the value 
set in a field called 'Cat'?


Something like
IF 'Cat'="abc" THEN Bgd Colour = "" OR
IF 'Cat'="cde" THEN Bgd Colour = ""

Thanks for any help!!

IanW
Pretoria RSA




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LO Base Colour settings in Form design.

[Fernand Vanrie]

 Ian ,

When using macro's to add the data to your form it can easly been done, 
without macro's ??


Greetz

Fernand

Hi All

I have a Membership Database running on MySQL 5.1 with an LO Base 
Front end Ver 3.6.2.2. All running on PCLOS 2012.
My Members fall into two or three different Categories and I would 
like to be able to show this on screen.


SO - Is it possible to add in a statement to the Form design so that 
the background colour of the Form will change depending on the value 
set in a field called 'Cat'?


Something like
IF 'Cat'="abc" THEN Bgd Colour = "" OR
IF 'Cat'="cde" THEN Bgd Colour = ""

Thanks for any help!!

IanW
Pretoria RSA




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Adding .pdf Images to Document

[Fernand Vanrie]

Steve ,

I use a lot of EPSs in my documents.
We did also, but PostScript is slowly dying because of "no 
transparency". LO and OO handles well EPS, but you need a eps with 
"previeuw" to show a bitamp representation off the content. Making a 
native-PDF (using PDF-export) export the bitamp representation and not 
the vector data.
Making PDF with a Postscript application like(PS2PDF) works very well 
and here the vector data are used, not the bitmaps.
Using SVG is the future, Both LO and OO are fast advancing in there use 
of it, the major problem is that the current PDF  export also export a 
bitmap representation and not the vector data, this was not so  in older 
versions, LO promeses to fix this issue in 3.7 = (4.0) no news from OO.

These are usually the first to drop out with the lost image problem
(resolved by turning auto save off). I have linux and mac, so not sure
if EPS compatibility is reduced on win. I have a feeling on windows
the thumbnail image in many EPSs  is used instead of the actual EPS
vector data producing poor looking results. LO wasn't producing PDFs
well with EPSs (doing the same as win) so I print to PS and use PS2PDF.
steve

On 2012-11-21 06:34, Tom Davies wrote:

Hi :)
Eps??  Are you sure?  I seem to have trouble with my Epses but that
is probably either my fault or some weirdness of the program
producing the Eps (i think Adobe Creative something, an expensive
product that tries to force other people into buying it.)  So, is
there somewhere i can test an Eps to see how well it conforms to what
it should be?
Regards from
Tom :)



*From:* Steve Edmonds 
*To:* Rich Shepard 
*Cc:* users@global.libreoffice.org
*Sent:* Tuesday, 20 November 2012, 1:38
*Subject:* Re: [libreoffice-users] Adding .pdf Images to Document

Hi.
PDF is not listed as a type of image to insert in my LO 3.5. EPS
is if
you can convert the PDF's.
Steve

On 2012-11-20 13:45, Rich Shepard wrote:
> On Mon, 19 Nov 2012, Girvin R. Herr wrote:
>
>> Insert -> Picture -> From file
>> Hope this helps.
>
> Girvin,
>
>  That's what I kept trying but it would not open a file dialog
box and
> would not accept the file name in the text entry widget on the
"picture"
> tab.
>
> Rich
>
>


-- For unsubscribe instructions e-mail to:
users+h...@global.libreoffice.org

Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more:
http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and
cannot be deleted









--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Adding .pdf Images to Document

[Fernand Vanrie]

Rich ,

.pdf is not a accepted graphic format for LO or OO

surly we urgent need that... in the mean time convert the PDF images to 
SVG (using Inskape) and then place the SVG in your writer Doc. For 
non-complex PDF files it works fine.

  I need to provide a client with a Word version of a report written in
LaTeX. Exporting the text to LO format works just fine, but all the 
images

in the document are .pdf files generated by GRASS or R. I'm having
difficulty finding how to insert these images in the LO document.

  Please point me in the right direction.

TIA,

Rich





--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Anchoring multiple images in Writer Tables

[Fernand Vanrie]

On 23/09/2012 19:06, Mirosław Zalewski wrote:

On 23/09/2012 at 18:43, AndrewB  wrote:


Do I really have to do them one-at-a-time?

You can write a macro or unzip ODT file and modify one of XML files in there.

hope this code will help

greetz

fernand

sub changeanchoring
odocument = thiscomponent
Dim oDocGraphics as Object
dim oGraphic1 as Object
dim sGfilename as string
dim vAlleFotos as variant

GlobalScope.BasicLibraries.loadLibrary("Tools")
oDocGraphics = odocument.GraphicObjects

 vAlleFotos = oDocGraphics.getElementNames()
 For iG = 0 to oDocGraphics.count - 1
 iFotNr = ig + 1

sFotMetNr = vAlleFotos(iG)
oGraphic1 = oDocGraphics.GetbyName(sFotMetNr)
 if oGraphic1.AnchorType <> 
com.sun.star.text.TextContentAnchorType.AS_CHARACTER
 oGraphic1.AnchorType = 
com.sun.star.text.TextContentAnchorType.AS_CHARACTER

 endif
next
end sub



But if you don't have any programming background, then I am afraid that doing
them one-by-one will be easiest solution. Quite tiresome, though.



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] How to determine FilterName of loaded document?

[Fernand Vanrie]

On 29/08/2012 17:00, Walther Koehler wrote:

Hi,

how to find out the FilterName of a loaded document?
(other than try to "save under" and look what is marked)
I would like to find it by a Basic Makro, but didnt find a hint even in Andrew
Pitonyaks marvellous guide.

a sequelae: Does anybody know, how a document is stored in memory? Is it
different i.e. for a Word.doc and an vnd.oasis Dokument?

Thanks for your help

Walther

you can find the file extention at the endof  the location url 
(Thiscomponent.location)


Hope it helps

fernand

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Searching for ”empty” cell (LibreOffice BASIC macro)

[Fernand Vanrie]

 Johnny,

found this stuf on a French forum:

Sub PysTests
dim PysSel as object, FormulaRetour, EmptyRetour as object
dim PysFlag

PysFlag  = com.sun.star.sheet.FormulaResult.VALUE + 
com.sun.star.sheet.FormulaResult.STRING + 
com.sun.star.sheet.FormulaResult.ERROR


PysSel = thiscomponent.currentSelection
FormulaRetour = PysSel.queryFormulaCells(PysFlag)
xray FormulaRetour
EmptyRetour = PysSel.queryEmptyCells(PysFlag)
xray EmptyRetour
End Sub

hope it helps also :-)

2012/7/20 Fernand Vanrie:

Op 20/07/2012 13:31, Johnny Rosenberg schreef:


2012/7/20 Fernand Vanrie:

   Johnny,
I suppose you have to run the check 2 Times, first SearchType = 0  here
we
find if there is a formula use  "."

What do you mean? Use "." as the search string? Regular expressions
set to what? True?

yep looking for not empty you need regular expressions

I did some brutal experimenting and after hundreds of swearwords (the
damned crap freeze all the time) I actually found something. Have a
look at this descriptor:

With SearchDescriptor
.SearchByRow=False
.SearchRegularExpression=True
.SearchString="^[^.]$"
.SearchType=1 ' Search values.
End With

First it didn't work as I expected, but it found another cell in
another column. That cell has a semi complicated formula with nested
IF's and in this case it returns F2+STYLE("Hide"). F2 in this case is
an empty cell, so now I changed the formula in the cell I wanted to
find, by just replacing the two quotes ("") with F2, and now it finds
the cell!

So "" is not good enough for making a cell empty, but I can reference
to a cell that actually is empty!

So what I need to do now, is to change all the formulas in one column,
and the search descriptor above will work, as it seems!


At least I'll try that.


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ


then SearchType 1 on the found area

Area? You mean what's found when setting ”search all”?

no you can define the "erea" (cells) you want to searched so when you found
that 1 cell has a formula, you need to check only this cell on a value


the SearchString has a different meaning , depending on the .SearchType
= 1 then the SearchString is the is the result of the formula or the
value
content

Okay, that's not very well designed… at least not in my opinion.


= 0 then the SearchString is the formula string

Meaning what if a cell contains only a value?

hope it helps

I don't know, will do some tests later, but it certainly feels
confusing at the moment, because when I use the Search/Replace
dialogue, it doesn't work like that at all. Selecting ”Values” in the
dialogue give me the result I want, it finds the first cell with an
empty value (in this case a cell with a formula that returns that
empty value – ""). So one question that comes to my mind is why the
LibreOffice Basic Search doesn't work the same way as the dialogue.
Maybe it's just fun to confuse the users…

As I said, I will do some more tests and come back here later.


Thanks for replying.

Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ


Fernand


Just can't figure it out. I have a column of 2000 formulas and values.
Right now, A1:A1620 contains values, and A1621:A2000 contains
formulas. The formulas in A1621:A2000, at the moment, return empty
strings, all of them, so it looks like only the 1620 first rows
contains data.
So the formulas looks something like =IF(this and that;"";something
else) (but a bit more complicated). The point is that if I input
something on a ”new” row in one of the other columns, the A column
shall, in some cases, display something.

Okay, that's what the spreadsheet looks like, roughly.

Now I use a couple of macros to do things for me a lot faster than I
could ever do myself. One small part of a new macro I'm trying to
write needs to search for the first ”empty” row, which means the first
row where the A column contains a formula that returns an empty
string.

Here's what I tried:
Function FindCurrentRow(Sheet As Object) As Integer
  Dim SearchDescriptor As Object
  SearchDescriptor=Sheet.createSearchDescriptor()
  With SearchDescriptor
  .SearchByRow=False ' I want to search by column,
starting
at A.
  .SearchRegularExpression=False
  .SearchString=""
  .SearchType=1 ' 0=Search in formulae, 1=Search values.
  End With

  Dim Found As Object
  Found=Sheet.findFirst(SearchDescriptor)
  FindCurrentRow=Found.getCellAddress().Row
End Function

In this example I expect the function to return 1620 (which is the row
address for the cell A1621). Instead 2000 is returned, so for some
reason, when my cell formula returns "", that doesn't seem to be the
same as .SearchStri

Re: [libreoffice-users] Searching for ”empty” cell (LibreOffice BASIC macro)

[Fernand Vanrie]

Op 20/07/2012 13:31, Johnny Rosenberg schreef:

2012/7/20 Fernand Vanrie:

  Johnny,
I suppose you have to run the check 2 Times, first SearchType = 0  here we
find if there is a formula use  "."

What do you mean? Use "." as the search string? Regular expressions
set to what? True?

yep looking for not empty you need regular expressions

then SearchType 1 on the found area

Area? You mean what's found when setting ”search all”?
no you can define the "erea" (cells) you want to searched so when you 
found that 1 cell has a formula, you need to check only this cell on a value

the SearchString has a different meaning , depending on the .SearchType
= 1 then the SearchString is the is the result of the formula or the value
content

Okay, that's not very well designed… at least not in my opinion.


= 0 then the SearchString is the formula string

Meaning what if a cell contains only a value?

hope it helps

I don't know, will do some tests later, but it certainly feels
confusing at the moment, because when I use the Search/Replace
dialogue, it doesn't work like that at all. Selecting ”Values” in the
dialogue give me the result I want, it finds the first cell with an
empty value (in this case a cell with a formula that returns that
empty value – ""). So one question that comes to my mind is why the
LibreOffice Basic Search doesn't work the same way as the dialogue.
Maybe it's just fun to confuse the users…

As I said, I will do some more tests and come back here later.


Thanks for replying.

Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ


Fernand


Just can't figure it out. I have a column of 2000 formulas and values.
Right now, A1:A1620 contains values, and A1621:A2000 contains
formulas. The formulas in A1621:A2000, at the moment, return empty
strings, all of them, so it looks like only the 1620 first rows
contains data.
So the formulas looks something like =IF(this and that;"";something
else) (but a bit more complicated). The point is that if I input
something on a ”new” row in one of the other columns, the A column
shall, in some cases, display something.

Okay, that's what the spreadsheet looks like, roughly.

Now I use a couple of macros to do things for me a lot faster than I
could ever do myself. One small part of a new macro I'm trying to
write needs to search for the first ”empty” row, which means the first
row where the A column contains a formula that returns an empty
string.

Here's what I tried:
Function FindCurrentRow(Sheet As Object) As Integer
 Dim SearchDescriptor As Object
 SearchDescriptor=Sheet.createSearchDescriptor()
 With SearchDescriptor
 .SearchByRow=False ' I want to search by column, starting
at A.
 .SearchRegularExpression=False
 .SearchString=""
 .SearchType=1 ' 0=Search in formulae, 1=Search values.
 End With

 Dim Found As Object
 Found=Sheet.findFirst(SearchDescriptor)
 FindCurrentRow=Found.getCellAddress().Row
End Function

In this example I expect the function to return 1620 (which is the row
address for the cell A1621). Instead 2000 is returned, so for some
reason, when my cell formula returns "", that doesn't seem to be the
same as .SearchString="".
I also tried different values of .SearchValue, still with the same
result: 2000 instead of 1620. So it only finds the first cell in the A
column that is REALLY empty – no formula, no value.

To me this seems like a bug, but for someone else, hopefully, it might
seem like I'm just stupid, so feel free to call me stupid and, more
important, tell me what I'm doing wrong and how I should do instead…



Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Searching for ”empty” cell (LibreOffice BASIC macro)

[Fernand Vanrie]

 Johnny,
I suppose you have to run the check 2 Times, first SearchType = 0  here 
we find if there is a formula use  "."

then SearchType 1 on the found area

the SearchString has a different meaning , depending on the .SearchType
= 1 then the SearchString is the is the result of the formula or the 
value content

= 0 then the SearchString is the formula string

hope it helps

Fernand

Just can't figure it out. I have a column of 2000 formulas and values.
Right now, A1:A1620 contains values, and A1621:A2000 contains
formulas. The formulas in A1621:A2000, at the moment, return empty
strings, all of them, so it looks like only the 1620 first rows
contains data.
So the formulas looks something like =IF(this and that;"";something
else) (but a bit more complicated). The point is that if I input
something on a ”new” row in one of the other columns, the A column
shall, in some cases, display something.

Okay, that's what the spreadsheet looks like, roughly.

Now I use a couple of macros to do things for me a lot faster than I
could ever do myself. One small part of a new macro I'm trying to
write needs to search for the first ”empty” row, which means the first
row where the A column contains a formula that returns an empty
string.

Here's what I tried:
Function FindCurrentRow(Sheet As Object) As Integer
Dim SearchDescriptor As Object
SearchDescriptor=Sheet.createSearchDescriptor()
With SearchDescriptor
.SearchByRow=False ' I want to search by column, starting at A.
.SearchRegularExpression=False
.SearchString=""
.SearchType=1 ' 0=Search in formulae, 1=Search values.
End With

Dim Found As Object
Found=Sheet.findFirst(SearchDescriptor)
FindCurrentRow=Found.getCellAddress().Row
End Function

In this example I expect the function to return 1620 (which is the row
address for the cell A1621). Instead 2000 is returned, so for some
reason, when my cell formula returns "", that doesn't seem to be the
same as .SearchString="".
I also tried different values of .SearchValue, still with the same
result: 2000 instead of 1620. So it only finds the first cell in the A
column that is REALLY empty – no formula, no value.

To me this seems like a bug, but for someone else, hopefully, it might
seem like I'm just stupid, so feel free to call me stupid and, more
important, tell me what I'm doing wrong and how I should do instead…



Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LOW: uncontrollable line spacing in PDF output???

[Fernand Vanrie]

Rogier ,

There are some macro's or a extention around who makes the formating 
tags visible, just like we had with the good old WordPerfect, do some 
googling on "Iannz, RevealCodes"


hope it helps
Fernand

Hmm, disappointing though. I cannot see how these kinds of things can be
avoided if you are editing a manuscript, and I never had such problems in
the past with OO in 2002, with a book that certainly went through just as
many revisions.

I am clueless anymore how to fix it. If I fix one, another one pops up...

On Thu, Jul 5, 2012 at 1:12 PM, Fernand Vanrie  wrote:


Rogier ,

Its not worth a issue, its user related due to serial direct formating,
spaces folowd by spaces etc..When checking the underlying XML you can sea
lots of unused tags and sometimes the PDF-creator is confused :-)


The solution and the probable cause...

In the end, this problem was fixable, by using 'clear direct formatting'
in
the areas affected. (Could not do whole doc lest we wipe out italics and
such).

The amazing fact was that the problem did not manifest in a PDF at the
subdocument level, it just showed up in PDF output from the masterdoc.
Very
likely it was some kind of imperfection with the process of switching
fonts
somewhere in mid project. Unclear if it is substantial enough to rise to
the level of a reportable issue. It probably is, but I would not know how
to duplicate it.



On Wed, Jul 4, 2012 at 3:37 AM, Fernand Vanrie  wrote:

  Rogier ,

We produce about 8000 full color magazine pages a year using OO-LO on
Windows, without any PDF anomalies

- are you using Windows ?

- what Fonts ?

you can also send some problematic pages to my personal emailadress

Groeten

Fernand

  Back in 2002 I produced a book, going straight to print off a Open

Office
PDF, and the results were thoroughly satisfactory. In fact, my book at
that
time was probably the first production book that was fully produced
straight from OO, skipping DTP altogether.

Today, 10 years later I'm doing a tentative layout for a book in Libre
Office, though this time without the intention of going to print from
the
PDF, but I'm finding out I could not do it if I wanted to for there are
some unpredictable anomalies happening in the PDF in LIbre Office. (I
have
not tried OO yet. Today I would probably use Scribus or Adobe Indesign
to
prepare a proper print layout.) What is happening is that there are
completely unpredictable irregularities in the LO PDF output for which I
cannot find any evident cause.


  - There is irregular line spacing happening in the PDF output for

  reasons that are entirely unclear in the original.
  - In some cases opening smart quotes seem to display at a point
size

  about 5 times the size of the text in the PDF (not in the actual
document
  files), which at least provides a visual clue for the irregular
line
  spacing.

Does anyone have similar experience, and has anyone perhaps found a
workaround, or is this an "issue."





--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
**
org 

Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-*
*** <http://www.libreoffice.org/**get-help/mailing-lists/how-to-**>
unsubscribe/<http://www.**libreoffice.org/get-help/**
mailing-lists/how-to-**unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
Posting guidelines + more: 
http://wiki.**documentfoundati**on.org/**<http://documentfoundation.org/**>
Netiquette 
<http://wiki.**documentfoundation.org/**Netiquette<http://wiki.documentfoundation.org/Netiquette>
List archive: 
http://listarchives.**libreoff**ice.org/global/users/<http://libreoffice.org/global/users/>
<http://**listarchives.libreoffice.org/**global/users/<http://listarchives.libreoffice.org/global/users/>
All messages sent to this list will be publicly archived and cannot be
deleted





--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
org 
Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
Posting guidelines + more: http://wiki.**documentfoundation.org/**
Netiquette <http://wiki.documentfoundation.org/Netiquette>
List archive: 
http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/>
All messages sent to this list will be publicly archived and cannot be
deleted








--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LOW: uncontrollable line spacing in PDF output???

[Fernand Vanrie]

Rogier ,

Its not worth a issue, its user related due to serial direct formating, 
spaces folowd by spaces etc..When checking the underlying XML you can 
sea lots of unused tags and sometimes the PDF-creator is confused :-)

The solution and the probable cause...

In the end, this problem was fixable, by using 'clear direct formatting' in
the areas affected. (Could not do whole doc lest we wipe out italics and
such).

The amazing fact was that the problem did not manifest in a PDF at the
subdocument level, it just showed up in PDF output from the masterdoc. Very
likely it was some kind of imperfection with the process of switching fonts
somewhere in mid project. Unclear if it is substantial enough to rise to
the level of a reportable issue. It probably is, but I would not know how
to duplicate it.



On Wed, Jul 4, 2012 at 3:37 AM, Fernand Vanrie  wrote:


Rogier ,

We produce about 8000 full color magazine pages a year using OO-LO on
Windows, without any PDF anomalies

- are you using Windows ?

- what Fonts ?

you can also send some problematic pages to my personal emailadress

Groeten

Fernand


Back in 2002 I produced a book, going straight to print off a Open Office
PDF, and the results were thoroughly satisfactory. In fact, my book at
that
time was probably the first production book that was fully produced
straight from OO, skipping DTP altogether.

Today, 10 years later I'm doing a tentative layout for a book in Libre
Office, though this time without the intention of going to print from the
PDF, but I'm finding out I could not do it if I wanted to for there are
some unpredictable anomalies happening in the PDF in LIbre Office. (I have
not tried OO yet. Today I would probably use Scribus or Adobe Indesign to
prepare a proper print layout.) What is happening is that there are
completely unpredictable irregularities in the LO PDF output for which I
cannot find any evident cause.


 - There is irregular line spacing happening in the PDF output for

 reasons that are entirely unclear in the original.
 - In some cases opening smart quotes seem to display at a point size

 about 5 times the size of the text in the PDF (not in the actual
document
 files), which at least provides a visual clue for the irregular line
 spacing.

Does anyone have similar experience, and has anyone perhaps found a
workaround, or is this an "issue."





--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
org 
Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
Posting guidelines + more: http://wiki.**documentfoundation.org/**
Netiquette <http://wiki.documentfoundation.org/Netiquette>
List archive: 
http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/>
All messages sent to this list will be publicly archived and cannot be
deleted








--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted