Re: [libreoffice-users] rtf files

[Jean-Francois Nifenecker]

Hi,

Le 29/09/2014 04:26, Tim Lloyd a écrit :
> 
> FYI I removed 4.3 and installed 4.1. The problem is not apparent with
> the older version. I have some old versions stored away so I can drill
> down and find when exactly this problem occurs and report to the
> bugzilla (I can't see anything obvious there).
> 
> Let me know if we are on the same page.
> 

FYI, the older versions are available here:
http://downloadarchive.documentfoundation.org/libreoffice/old/

-- 
Jean-Francois Nifenecker, Bordeaux

-- 
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] rtf files

[Tim Lloyd]

Hi Carole,

I tried the following on Fedora Linux 4.3.1.2:

 * open a new document
 * format page to include 2 columns
 * populate the columns
 * save as .odt
 * Close and reopen - all good
 * Save the doc as .rtf
 * Close and reopen - not so good. The 2 columns are maintained but the
   contents are in different places.

Is this what you are seeing?

FYI I removed 4.3 and installed 4.1. The problem is not apparent with 
the older version. I have some old versions stored away so I can drill 
down and find when exactly this problem occurs and report to the 
bugzilla (I can't see anything obvious there).


Let me know if we are on the same page.

Regards


On 29/09/14 10:04, Carole Edwards Caruso wrote:

I am using LibreOffice 4.3.0.4 with Windows 7.

Until recently I have been saving my two column pages of text in rtf 
with no problems. I have been doing this for years with no problems. 
Now the program will only save this two column format as odt.


I can no longer save in rtf and retain these columns.

I am not sure when the problem started, but I think it might have been 
when I upgraded to v. 4.3.0.4.


I am writing a book using InDesign, which will not accept odt but will 
accept rtf. So I have years and years of work in rtf.


Right now, I am not a happy camper because I can find no way out of 
this problem


Please, can someone tell me what is going on here?

Thank you.

Carole






--
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] rtf files

[Carole Edwards Caruso]

I am using LibreOffice 4.3.0.4 with Windows 7.

Until recently I have been saving my two column pages of text in rtf 
with no problems. I have been doing this for years with no problems. Now 
the program will only save this two column format as odt.


I can no longer save in rtf and retain these columns.

I am not sure when the problem started, but I think it might have been 
when I upgraded to v. 4.3.0.4.


I am writing a book using InDesign, which will not accept odt but will 
accept rtf. So I have years and years of work in rtf.


Right now, I am not a happy camper because I can find no way out of this 
problem


Please, can someone tell me what is going on here?

Thank you.

Carole



--
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] Connector and line connector in Impress

[Kolbjørn Stuestøl]

Den 28.09.2014 19:16, skreiv Tom Davies:

Hi :)
i couldn't find it in the release notes
https://wiki.documentfoundation.org/ReleaseNotes/4.3
but experimentation surely helps figure it out.
Regards from
Tom :)

Thank you. Yes I wil have a look on it.
Kolbjoern



On 27 September 2014 11:31, Brian Barker  wrote:


At 22:53 25/09/2014 +0200, Kolbjørn Stuestøl wrote:


In Impress I can connect two objects with "connectors". This is lines
which follows the figures when moving them in opposite to ordinary lines.
But there are also "line connectors". I am not able to find any difference
between these two connectors. Are they different? If they are, in what way?


Surely you can see what sort of thing happens simply by trying out the
various forms and dragging the connected items around? The standard
connector appears to use only horizontal and vertical element, whereas the
line connector allows diagonal elements.

  In my version of LibreOffice, 4.3, only the "connectors" shows up in the

drop down menu, not the "line connectors". I found the "line connectors" in
the Impress guide (4.2) and in the UI 4.3 text files (UI.po).


o Click the down-arrow next to the Connector icon in the Drawing toolbar
to bring up the Connectors toolbar.
o Drag the toolbar off its parent using the bar at its base.
o Click the down-arrow in the Connectors toolbar and use Visible Buttons >
or Customise Toolbar... to vary the options shown. Note that Straight and
Curved Connectors are also available.

Alternatively, right-click an existing connector and go to Connector... .
You can change the type there, as well as making detailed modifications.

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] Top Window without Decoration on Ubuntu

[Tom Davies]

Hi :)
Sounds like it might be best asked through the devs irc channel or
something.  It might be a good idea to try an Ubuntu forum or mailing list
too.  Whoever gives the right answer first please give link to the other
forums/channels
Good luck and regards from
Tom :)

On 28 September 2014 19:11, X Roemer  wrote:

> Hi,
>
> I try to get rid of the window decoration on Ubuntu, but can't find a way.
>
> Here's how it looks like on Windows:
> https://www.dropbox.com/s/rvc3ftjrdeh2cx4/LO%20on%20Win7.png?dl=0
>
> and this is on Ubuntu:
> https://www.dropbox.com/s/fp4z1ceeleqxwr5/LO%20on%20Ubuntu.png?dl=0
>
> I did set the flag for the window attributes to 512 (no decoration), but
> I'm still getting close bar on top of the window.
>
> If someone wants to have a look on the code, my window is created with,
> it's here: (line 294 and below)
> https://github.com/XRoemer/Organon/blob/master/source/py/menu_bar.py
>
>
> Thanks for any help,
> Xaver
>
> --
> 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] Connector and line connector in Impress

[Tom Davies]

Hi :)
i couldn't find it in the release notes
https://wiki.documentfoundation.org/ReleaseNotes/4.3
but experimentation surely helps figure it out.
Regards from
Tom :)


On 27 September 2014 11:31, Brian Barker  wrote:

> At 22:53 25/09/2014 +0200, Kolbjørn Stuestøl wrote:
>
>> In Impress I can connect two objects with "connectors". This is lines
>> which follows the figures when moving them in opposite to ordinary lines.
>> But there are also "line connectors". I am not able to find any difference
>> between these two connectors. Are they different? If they are, in what way?
>>
>
> Surely you can see what sort of thing happens simply by trying out the
> various forms and dragging the connected items around? The standard
> connector appears to use only horizontal and vertical element, whereas the
> line connector allows diagonal elements.
>
>  In my version of LibreOffice, 4.3, only the "connectors" shows up in the
>> drop down menu, not the "line connectors". I found the "line connectors" in
>> the Impress guide (4.2) and in the UI 4.3 text files (UI.po).
>>
>
> o Click the down-arrow next to the Connector icon in the Drawing toolbar
> to bring up the Connectors toolbar.
> o Drag the toolbar off its parent using the bar at its base.
> o Click the down-arrow in the Connectors toolbar and use Visible Buttons >
> or Customise Toolbar... to vary the options shown. Note that Straight and
> Curved Connectors are also available.
>
> Alternatively, right-click an existing connector and go to Connector... .
> You can change the type there, as well as making detailed modifications.
>
> 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
>
>

-- 
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] Top Window without Decoration on Ubuntu

[X Roemer]

Hi,

I try to get rid of the window decoration on Ubuntu, but can't find a way.

Here's how it looks like on Windows:
https://www.dropbox.com/s/rvc3ftjrdeh2cx4/LO%20on%20Win7.png?dl=0

and this is on Ubuntu:
https://www.dropbox.com/s/fp4z1ceeleqxwr5/LO%20on%20Ubuntu.png?dl=0

I did set the flag for the window attributes to 512 (no decoration), but 
I'm still getting close bar on top of the window.


If someone wants to have a look on the code, my window is created with, 
it's here: (line 294 and below)

https://github.com/XRoemer/Organon/blob/master/source/py/menu_bar.py


Thanks for any help,
Xaver

--
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: [libreoffice-documentation] Re: Base Document - Forms

[Tom Davies]

Hi :)
Superb!  Thanks :)

Errr, if you are "up for it" then it would be great if you could join the
Documentation Team to help review or proof-read the Base Handbook.

For many people i suggest starting with something more familiar before
diving into Base because there is quite a lot else to get used to when
joining the Documentation Team.  We do still have a couple of chapters of
the Writer Guide left but in your case i think you could jump straight into
working on the Base Handbook.

I'm trying to keep the first few chapters available for a new person to the
team so that he can learn about Base as he goes.  The more people joining
in the better!  Especially people who have experience with databases such
as you and Peter G.

Thanks for the advice though!  On another mailing list people suggested
that it might be something wonky about the import filters for the date
format (the devs did some work on them in the 4.1 branch) or that Excel
might not be properly setting the date-field.  Your pointers give
additional options.

So, thanks and regards from
Tom :)


On 28 September 2014 12:25, Paul  wrote:

> I've got some experience with various databases, but little with
> Access, sorry.
>
> Given the OP exported the data from Access once, I'd assume that it's
> possible to export to csv format instead of Excel spreadsheets, and I'd
> recommend that. Then importing into Base should be straightforward, and
> formatting shouldn't be lost. Access might even give some options for
> the export formats, but worst case the data can be massaged in Calc
> before importing into Base, say to change the date format.
>
> If the OP is still having trouble with this, he can try posting a
> couple of lines of the exported csv file, and we can see if there is a
> reason Base is not importing it correctly.
>
> This does sound like it should be possible with the method he is using,
> but it's much harder for me to debug. If he's using plain csv files,
> just posting a couple of lines would give me an idea of how the data
> looks, and I could test on my machine, which does have Base, but not
> Access.
>
> And if he wants to go to MySQL/MariaDB/PostgreSQL, again using csv
> files should be pretty straightforward, even if it does mean command
> line and queries, and not a GUI interface. Although those exist, I'm
> just not as familiar with them.
>
> Paul
>
> On Sun, 28 Sep 2014 09:29:57 +0100
> Tom Davies  wrote:
>
> > Hi :)
> > Ok, so the Documentation Team have got an example database for Peter
> > to work with in the short-term but the question of how to migrate an
> > Access Database would still be good to get some hints and advice on.
> >
> > Is there anyone who can help with this?
> > Regards from
> > Tom :)
> >
> >
> > On 28 September 2014 09:13, Tom Davies  wrote:
> >
> > > Hi :)
> > > Errr, obviously if he's using Access then it must be Windows.  The
> > > only other platform that MS Office has been able to port to was Mac
> > > and they weren't able to port Access were they?
> > >
> > > Anyway, i think that mean Peter could use some help porting an
> > > Access database to either Postgresql, MySql/MariaDb or into Base
> > > itself and on Windows.
> > > Regards from
> > > Tom :)
> > >
> > > On 28 September 2014 09:09, Tom Davies  wrote:
> > >
> > >> Hi :)
> > >> Has anyone here got experience with migrating Access databases to
> > >> Base?
> > >>
> > >> I have a strong feeling that migrating the Tables to Postgresql or
> > >> MySql/MariDb would be a better first step.
> > >>
> > >> I'm not sure what platform Peter is on, sorry.
> > >> Regards from
> > >> Tom :)
> > >>
> > >>
> > >> On 28 September 2014 05:22, Peter Goggin 
> > >> wrote:
> > >>
> > >>> I am working through the documentation for the forms. To do this
> > >>> properly I needed a data base. As I have an access data base
> > >>> which I want to convert to Librebase I used this. I exported the
> > >>> tables from Access as Excel files, opened them in Librecalc,
> > >>> saved them in native librecalc format. I made sure the column
> > >>> definitions were correct for dates.
> > >>>
> > >>> I copied the data cells and imported them into a Base table. I
> > >>> found a problem with all fields which were created as text.  If I
> > >>> change the date columns to date format I cannot save the new
> > >>> version of the base table without losing the date data. Is there
> > >>> any way of importing data and preserving the data format?
> > >>>
> > >>> Many years ago using Oracle SQL I believe you could import text
> > >>> data into an already created table if your text data had been
> > >>> properly formatted. Is this possible with LibreBase?
> > >>>
> > >>> Thanks for an advice.
> > >>>
> > >>> This won't stop me from continuing to reviews the documentation
> > >>> but it would be good to know how to import data , retaining the
> > >>> formatting and data types.
> > >>>
> > >>> Regards
> > >>>
> > >>> Peter Goggin
> > >>>
> > >>>
> > >>>
> > >>
> > >
> >
>
>
> --
> To uns

Re: [libreoffice-users] Re: [libreoffice-documentation] Re: Base Document - Forms

[Walther Koehler]

Hi,

export tables from MSACCESS as dbase  files in a proprietary directory. 
Connect to that directory from LO-base. 

Yours

Walther


as  Am Sonntag, 28. September 2014 schrieb Tom Davies:
> Hi :)
> Ok, so the Documentation Team have got an example database for Peter to
> work with in the short-term but the question of how to migrate an Access
> Database would still be good to get some hints and advice on.
>
> Is there anyone who can help with this?
> Regards from
> Tom :)
>
> On 28 September 2014 09:13, Tom Davies  wrote:
> > Hi :)
> > Errr, obviously if he's using Access then it must be Windows.  The only
> > other platform that MS Office has been able to port to was Mac and they
> > weren't able to port Access were they?
> >
> > Anyway, i think that mean Peter could use some help porting an Access
> > database to either Postgresql, MySql/MariaDb or into Base itself and on
> > Windows.
> > Regards from
> > Tom :)
> >
> > On 28 September 2014 09:09, Tom Davies  wrote:
> >> Hi :)
> >> Has anyone here got experience with migrating Access databases to Base?
> >>
> >> I have a strong feeling that migrating the Tables to Postgresql or
> >> MySql/MariDb would be a better first step.
> >>
> >> I'm not sure what platform Peter is on, sorry.
> >> Regards from
> >> Tom :)
> >>
> >> On 28 September 2014 05:22, Peter Goggin  wrote:
> >>> I am working through the documentation for the forms. To do this
> >>> properly I needed a data base. As I have an access data base which I
> >>> want to convert to Librebase I used this. I exported the tables from
> >>> Access as Excel files, opened them in Librecalc, saved them in native
> >>> librecalc format. I made sure the column definitions were correct for
> >>> dates.
> >>>
> >>> I copied the data cells and imported them into a Base table. I found a
> >>> problem with all fields which were created as text.  If I change the
> >>> date columns to date format I cannot save the new version of the base
> >>> table without losing the date data. Is there any way of importing data
> >>> and preserving the data format?
> >>>
> >>> Many years ago using Oracle SQL I believe you could import text data
> >>> into an already created table if your text data had been properly
> >>> formatted. Is this possible with LibreBase?
> >>>
> >>> Thanks for an advice.
> >>>
> >>> This won't stop me from continuing to reviews the documentation but it
> >>> would be good to know how to import data , retaining the formatting and
> >>> data types.
> >>>
> >>> Regards
> >>>
> >>> Peter Goggin



-- 
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 Reports - Getting Monthly & YTD Averages

[Don Parris]

Sure.

The table:
  id date amount_mm  0 08/12/14 22  1 08/19/14 8  2 08/24/14 9.5  3 09/04/14
52  4 09/11/14 20  6 09/12/14 20  7 09/13/14 34  8 09/17/14 42  9 09/24/14 7
The underlying query:
SELECT MONTHNAME( "date" ) AS "Month", SUM( "amount_mm" ) AS "Total (mm)",
AVG( "amount_mm" ) AS "Avg (mm)", MAX( "amount_mm" ) AS "Max (mm)", MIN(
"amount_mm" ) AS "Min (mm)", SUM( "amount_mm" * 0.0393701 ) AS "Sum (in)",
AVG( "amount_mm" * 0.0393701 ) AS "Avg (in)", MAX( "amount_mm" * 0.0393701
) AS "Max (in)", MIN( "amount_mm" * 0.0393701 ) AS "Min (in)" FROM
"tblRain" GROUP BY MONTHNAME( "date" )

On Sat, Sep 27, 2014 at 5:49 AM, Alex Thurgood 
wrote:

> Le 26/09/2014 11:03, Don Parris a écrit :
> > Thanks Alex.  The underlying query gets the month from the date, as well
> as
> > the total, average, max and min for each month.  The results are, of
> > course, already grouped & calculated by month.  I was able to get the
> > overall total, but also wanted to see the overall average, max and min.
> I
> > somehow imagined that it would be a piece of cake.  It looks like Calc is
> > the better "report tool" in this case.
> >
>
> Having never really played around with Calc and database datasets, I
> admit to not knowing, but I imagine that the function set is broader and
> thus allows for more possibilities.
>
> Would you mind posting your initial query and table definition so that I
> could build my own little test db and have a think about it, otherwise
> its all a bit too abstract ?
>
> 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
>



-- 
D.C. Parris, FMP, Linux+, ESL Certificate
Minister, Security/FM Coordinator, Free Software Advocate
http://dcparris.net/ 

GPG Key ID: F5E179BE

-- 
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] Convertir csv en ods

[Jean-Francois Nifenecker]

Le 28/09/2014 13:19, Jean-Francois Nifenecker a écrit :
> Bonjour,
> 

sorry, this message was intended for the FR users list. Please discard.


-- 
Jean-Francois Nifenecker, Bordeaux

-- 
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] bug segnaled in 4.3

[Ian Whitfield]

On 09/28/2014 11:53 AM, Paolo Debortoli wrote:

a debian user has written on a mailing list that differently from version 4.2, in 
the last 4.3.2.1 version the ordering function (right click -> sort) in calc is 
not working yet (I haven't verified it by myself at the moment actually).


It works fine in 4.3.2.2 on PClinuxOS.

IanW
Pretoria RSA

--
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: [libreoffice-documentation] Re: Base Document - Forms

[Paul]

I've got some experience with various databases, but little with
Access, sorry.

Given the OP exported the data from Access once, I'd assume that it's
possible to export to csv format instead of Excel spreadsheets, and I'd
recommend that. Then importing into Base should be straightforward, and
formatting shouldn't be lost. Access might even give some options for
the export formats, but worst case the data can be massaged in Calc
before importing into Base, say to change the date format.

If the OP is still having trouble with this, he can try posting a
couple of lines of the exported csv file, and we can see if there is a
reason Base is not importing it correctly.

This does sound like it should be possible with the method he is using,
but it's much harder for me to debug. If he's using plain csv files,
just posting a couple of lines would give me an idea of how the data
looks, and I could test on my machine, which does have Base, but not
Access.

And if he wants to go to MySQL/MariaDB/PostgreSQL, again using csv
files should be pretty straightforward, even if it does mean command
line and queries, and not a GUI interface. Although those exist, I'm
just not as familiar with them.

Paul

On Sun, 28 Sep 2014 09:29:57 +0100
Tom Davies  wrote:

> Hi :)
> Ok, so the Documentation Team have got an example database for Peter
> to work with in the short-term but the question of how to migrate an
> Access Database would still be good to get some hints and advice on.
> 
> Is there anyone who can help with this?
> Regards from
> Tom :)
> 
> 
> On 28 September 2014 09:13, Tom Davies  wrote:
> 
> > Hi :)
> > Errr, obviously if he's using Access then it must be Windows.  The
> > only other platform that MS Office has been able to port to was Mac
> > and they weren't able to port Access were they?
> >
> > Anyway, i think that mean Peter could use some help porting an
> > Access database to either Postgresql, MySql/MariaDb or into Base
> > itself and on Windows.
> > Regards from
> > Tom :)
> >
> > On 28 September 2014 09:09, Tom Davies  wrote:
> >
> >> Hi :)
> >> Has anyone here got experience with migrating Access databases to
> >> Base?
> >>
> >> I have a strong feeling that migrating the Tables to Postgresql or
> >> MySql/MariDb would be a better first step.
> >>
> >> I'm not sure what platform Peter is on, sorry.
> >> Regards from
> >> Tom :)
> >>
> >>
> >> On 28 September 2014 05:22, Peter Goggin 
> >> wrote:
> >>
> >>> I am working through the documentation for the forms. To do this
> >>> properly I needed a data base. As I have an access data base
> >>> which I want to convert to Librebase I used this. I exported the
> >>> tables from Access as Excel files, opened them in Librecalc,
> >>> saved them in native librecalc format. I made sure the column
> >>> definitions were correct for dates.
> >>>
> >>> I copied the data cells and imported them into a Base table. I
> >>> found a problem with all fields which were created as text.  If I
> >>> change the date columns to date format I cannot save the new
> >>> version of the base table without losing the date data. Is there
> >>> any way of importing data and preserving the data format?
> >>>
> >>> Many years ago using Oracle SQL I believe you could import text
> >>> data into an already created table if your text data had been
> >>> properly formatted. Is this possible with LibreBase?
> >>>
> >>> Thanks for an advice.
> >>>
> >>> This won't stop me from continuing to reviews the documentation
> >>> but it would be good to know how to import data , retaining the
> >>> formatting and data types.
> >>>
> >>> Regards
> >>>
> >>> Peter Goggin
> >>>
> >>>
> >>>
> >>
> >
> 


-- 
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] Convertir csv en ods

[Jean-Francois Nifenecker]

Bonjour,

(Win7-64 -- LibO 4.1.4.2)

j'ai à convertir des fichiers csv (texte délimité) en ods.
Pour ce faire j'ai pensé utiliser le mode --headless de soffice.exe avec
l'option --convert-to ods
La ligne de commande est :
soffice --headless --convert-to ods monfichier.csv

Cependant je rencontre une erreur d'interprétation des données du csv :
les nombres commençant par de zéros sont interprétés en nombres, donc
perdent ce zéro de tête. Si je mets ces colonnes en délimité (par des ")
j'obtiens le même résultat. C'est gênant, puisque les départements dont
le code débute par zéro sont mal transcodés.

Exemple : soient les données suivantes
"Dept","Nom"
"01","Ain"
"09","Ariège"
"33","Gironde"

je n'arrive pas à obtenir un résultat cohérent (des codes avec leurs
zéros de tête lorsqu'il y en a).

J'ai cherché sur le net mais sans succès.

Je connais un script Python qui va bien mais si je peux j'aimerais
autant utiliser les fonctionnalités natives de soffice.


Des idées ?

Merci,
-- 
Jean-Francois Nifenecker, Bordeaux

-- 
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] bug segnaled in 4.3

[Paolo Debortoli]

a debian user has written on a mailing list that differently from version 4.2, 
in the last 4.3.2.1 version the ordering function (right click -> sort) in calc 
is not working yet (I haven't verified it by myself at the moment actually).


-- 
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] problems with the spell checker

[Tim Lloyd]

Hi,

this list does not accept attachments. However, if you nip over to the 
nabble interface:


http://nabble.documentfoundation.org/Users-f1639498.html

that does accept attachments so you can post there.

Cheers

On 28/09/14 19:31, Uwe Brauer wrote:

Hello

I am on (K)ubuntu 10.04 using libreoffice 4.2.

I have installed hunspell, ispell and the dictionaries for English and
Hebrew, (both have the corresponding mark, when I check format,
character, font)


I also checked in language setting/writing aids, that the hunspell is checked.

However when I try to run the spell checker does not start but I see the
following window which I have attached:


thanks

Uwe Brauer





--
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] problems with the spell checker

[Uwe Brauer]

Hello

I am on (K)ubuntu 10.04 using libreoffice 4.2.

I have installed hunspell, ispell and the dictionaries for English and
Hebrew, (both have the corresponding mark, when I check format,
character, font)


I also checked in language setting/writing aids, that the hunspell is checked.

However when I try to run the spell checker does not start but I see the
following window which I have attached:


thanks

Uwe Brauer 


-- 
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: [libreoffice-documentation] Re: Base Document - Forms

[Tom Davies]

Hi :)
Has anyone here got experience with migrating Access databases to Base?

I have a strong feeling that migrating the Tables to Postgresql or
MySql/MariDb would be a better first step.

I'm not sure what platform Peter is on, sorry.
Regards from
Tom :)


On 28 September 2014 05:22, Peter Goggin  wrote:

> I am working through the documentation for the forms. To do this properly
> I needed a data base. As I have an access data base which I want to convert
> to Librebase I used this. I exported the tables from Access as Excel files,
> opened them in Librecalc, saved them in native librecalc format. I made
> sure the column definitions were correct for dates.
>
> I copied the data cells and imported them into a Base table. I found a
> problem with all fields which were created as text.  If I change the date
> columns to date format I cannot save the new version of the base table
> without losing the date data. Is there any way of importing data and
> preserving the data format?
>
> Many years ago using Oracle SQL I believe you could import text data into
> an already created table if your text data had been properly formatted. Is
> this possible with LibreBase?
>
> Thanks for an advice.
>
> This won't stop me from continuing to reviews the documentation but it
> would be good to know how to import data , retaining the formatting and
> data types.
>
> Regards
>
> Peter Goggin
>
>
>

-- 
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: [libreoffice-documentation] Re: Base Document - Forms

[Tom Davies]

Hi :)
Errr, obviously if he's using Access then it must be Windows.  The only
other platform that MS Office has been able to port to was Mac and they
weren't able to port Access were they?

Anyway, i think that mean Peter could use some help porting an Access
database to either Postgresql, MySql/MariaDb or into Base itself and on
Windows.
Regards from
Tom :)

On 28 September 2014 09:09, Tom Davies  wrote:

> Hi :)
> Has anyone here got experience with migrating Access databases to Base?
>
> I have a strong feeling that migrating the Tables to Postgresql or
> MySql/MariDb would be a better first step.
>
> I'm not sure what platform Peter is on, sorry.
> Regards from
> Tom :)
>
>
> On 28 September 2014 05:22, Peter Goggin  wrote:
>
>> I am working through the documentation for the forms. To do this properly
>> I needed a data base. As I have an access data base which I want to convert
>> to Librebase I used this. I exported the tables from Access as Excel files,
>> opened them in Librecalc, saved them in native librecalc format. I made
>> sure the column definitions were correct for dates.
>>
>> I copied the data cells and imported them into a Base table. I found a
>> problem with all fields which were created as text.  If I change the date
>> columns to date format I cannot save the new version of the base table
>> without losing the date data. Is there any way of importing data and
>> preserving the data format?
>>
>> Many years ago using Oracle SQL I believe you could import text data into
>> an already created table if your text data had been properly formatted. Is
>> this possible with LibreBase?
>>
>> Thanks for an advice.
>>
>> This won't stop me from continuing to reviews the documentation but it
>> would be good to know how to import data , retaining the formatting and
>> data types.
>>
>> Regards
>>
>> Peter Goggin
>>
>>
>>
>

-- 
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: [libreoffice-documentation] Re: Base Document - Forms

[Tom Davies]

Hi :)
Ok, so the Documentation Team have got an example database for Peter to
work with in the short-term but the question of how to migrate an Access
Database would still be good to get some hints and advice on.

Is there anyone who can help with this?
Regards from
Tom :)


On 28 September 2014 09:13, Tom Davies  wrote:

> Hi :)
> Errr, obviously if he's using Access then it must be Windows.  The only
> other platform that MS Office has been able to port to was Mac and they
> weren't able to port Access were they?
>
> Anyway, i think that mean Peter could use some help porting an Access
> database to either Postgresql, MySql/MariaDb or into Base itself and on
> Windows.
> Regards from
> Tom :)
>
> On 28 September 2014 09:09, Tom Davies  wrote:
>
>> Hi :)
>> Has anyone here got experience with migrating Access databases to Base?
>>
>> I have a strong feeling that migrating the Tables to Postgresql or
>> MySql/MariDb would be a better first step.
>>
>> I'm not sure what platform Peter is on, sorry.
>> Regards from
>> Tom :)
>>
>>
>> On 28 September 2014 05:22, Peter Goggin  wrote:
>>
>>> I am working through the documentation for the forms. To do this
>>> properly I needed a data base. As I have an access data base which I want
>>> to convert to Librebase I used this. I exported the tables from Access as
>>> Excel files, opened them in Librecalc, saved them in native librecalc
>>> format. I made sure the column definitions were correct for dates.
>>>
>>> I copied the data cells and imported them into a Base table. I found a
>>> problem with all fields which were created as text.  If I change the date
>>> columns to date format I cannot save the new version of the base table
>>> without losing the date data. Is there any way of importing data and
>>> preserving the data format?
>>>
>>> Many years ago using Oracle SQL I believe you could import text data
>>> into an already created table if your text data had been properly
>>> formatted. Is this possible with LibreBase?
>>>
>>> Thanks for an advice.
>>>
>>> This won't stop me from continuing to reviews the documentation but it
>>> would be good to know how to import data , retaining the formatting and
>>> data types.
>>>
>>> Regards
>>>
>>> Peter Goggin
>>>
>>>
>>>
>>
>

-- 
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