[libreoffice-users] Re: Issues with date fields in dialogues

[Andreas Säger]

[Tutorial] Date-Time Conversion in StarBasic
  
including a spreadsheet document and a Basic function which converts all 
types of dates, times, timestamps into any other type. Date-times can be
represented by UNO structs, integers, doubles, Basic type Date,  ISO-strings
and localized strings.



--
View this message in context: 
http://nabble.documentfoundation.org/Issues-with-date-fields-in-dialogues-tp4204266p4204607.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

[libreoffice-users] Re: Issues with date fields in dialogues

[Andreas Säger]

Hit the push button which is attached to the sheet. It opens a dialog with a
date and time control. The two controls read and write the A1 cell. It works
with all versions of Libre/OpenOffice and it works correctly with different
NullDate settings. 
Function convertDateTime is designed to convert any type of date/time into
any other type of date/time.



--
View this message in context: 
http://nabble.documentfoundation.org/Issues-with-date-fields-in-dialogues-tp4204266p4204614.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

[libreoffice-users] Re: Calculating hours using spin button - simplified - answered

[Andreas Säger]

There is a control named "DateField" writing to a cell named "DateField"
There is a control named "TimeField" writing to a cell named "TimeField"
There is a control named "CurrencyField" writing to a cell named
"CurrencyField"
etc.
Each control has a "Text Modified" event which calls the macro.
The macro checks if a cell has the same name as the calling control. If so,
it writes an appropriate cell value into that cell.

This is a dirty hack. It applies to single cells only, e.g. you can't fill
columns of time data with this.
I always recommend databases. Most spreadsheet users try to simulate
databases in spreadsheets. Spreadsheet cells are NOT the normal target of
form controls. The controls are made for database records where one control
applies to all records of a whole column.



--
View this message in context: 
http://nabble.documentfoundation.org/Calculating-hours-using-spin-button-tp4203752p4204604.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

[libreoffice-users] Re: Problems exporting and importing a dialogue

[Andreas Säger]

Importing/exporting Basic modules and dialogs is easy when you do NOT store
everything in libraries named "Standard". Use the organizer to create a
library with a distinct project name within a template, document or in
global container "My Macros"
Move dialogs and code modules into the library.
Now you can create a simple macro extension from that library. There is an
[Export] button on the "Libraries" tab of the organizer which generates a
most simple oxt.
You can also import libraries directly from documents or from library
directories. There is an [Import] button on the same tab. You may also
import libraries from extracted extensions.



--
View this message in context: 
http://nabble.documentfoundation.org/Problems-exporting-and-importing-a-dialogue-tp4204239p4204605.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

[libreoffice-users] Re: Conditional formatting and named ranges issues.

[Andreas Säger]

As far as I understand the matter, the LibreOffice devs have broken the c.f.
feature. The c.f. conditions are formula expressions but they do not behave
like other formula expressions when you move, copy, expand or shrink
references. This is one of the things that still work (almost) properly with
OpenOffice.



--
View this message in context: 
http://nabble.documentfoundation.org/Conditional-formatting-and-named-ranges-issues-tp4204324p4204606.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

[libreoffice-users] Re: Calc Options > Libreoffice Calc > General > Expand references when new columns/rows are inserted

[Andreas Säger]

*Without "expand references"*
=SUM(Sheet1.A1:A99)
becomes 
=SUM(Sheet1.A2:A100) 
after you inserted one new row at Sheet1, row #1. The reference moves down
one row.
When you insert one row between row #2 and row #99 the reference expands by
one row:
=SUM(Sheet1.A1:A100) 
Nothing happens when you insert directly below A1:A99 in row #100.

*With "expand references"*
=SUM(Sheet1.A1:A99)
becomes 
=SUM(Sheet1.A1:A100) 
when you insert one row anywhere between row #1 and row #100 directly below.

This applies to all formula expressions with references, namely cell
formulas, conditional format, named ranges, database ranges, chart areas,
pivot table sources, validation conditions, conditional format conditions
and form control sources (list box, combo box).

In 99% of all use cases you want this option being checked. Sometimes it can
be annoying and then it is good to know how to turn off.



--
View this message in context: 
http://nabble.documentfoundation.org/Calc-Options-Libreoffice-Calc-General-Expand-references-when-new-columns-rows-are-inserted-tp4204347p4204393.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

[libreoffice-users] Another LO anti-feature

[Andreas Säger]

How can I disable the silly dialog that pops up after every search on
a Calc sheet? After correcting a column of 250,000 numbers it tries to write
250,000 cell addresses into a list box which takes by a magnitude more time
than the replacement process. 
If such feature is really, really desired by the Excel fans, then it should
be possible to disable it. Furthermore, such feature should be supervised by
an experienced Calc developer who knows that a search run returns a
collection com.sun.star.sheet.SheetCellRanges with interface
XSheetCellRanges having method getRangeAddressesAsString. In my case, this
method would return one string "Sheet1.A1:A25"
http://www.openoffice.org/api/docs/common/ref/com/sun/star/sheet/XSheetCellRanges.html#getRangeAddressesAsString



--
View this message in context: 
http://nabble.documentfoundation.org/Another-LO-anti-feature-tp4203317.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

[libreoffice-users] Re: Compatibility of LO Base with Access databases

[Andreas Säger]

Walther Koehler-4 wrote
> My doctors office uses a dBase based system for administration, keeping 
> patient records and so on. It has integrated LO for many purposes, i.e. 
> medical letters. As I was told, reading those dbf files using scripts is
> easy 
> (dbf_dump), modifying dbf files from outside the program however tedious, 
> they use LO base for that purpose. Unfortunately, the SQL commands for
> dBase 
> are limited.

I do a nightly second backup of the patient.dbf and have a Base document
connected to this backup file so this connection does not interfere with the
business application.



--
View this message in context: 
http://nabble.documentfoundation.org/Compatibility-of-LO-Base-with-Access-databases-tp4189654p4190325.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

[libreoffice-users] Re: Compatibility of LO Base with Access databases

[Andreas Säger]

After all the years I'm still shocked by the level of ignorance on this user
support mailing list.

https://forum.openoffice.org/en/forum/viewtopic.php?f=83=25300




--
View this message in context: 
http://nabble.documentfoundation.org/Compatibility-of-LO-Base-with-Access-databases-tp4189654p4189778.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

[libreoffice-users] Re: Embedded Base on Windows Share?

[Andreas Säger]

For multi-user access you need a database server. It is fairly easy to
convert your embedded HSQLDB into a server application.



--
View this message in context: 
http://nabble.documentfoundation.org/Embedded-Base-on-Windows-Share-tp4185518p4185648.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

[libreoffice-users] Re: very slow loading of a ods file

[Andreas Säger]

Am 30.04.2016 um 00:02 schrieb John R. Sowden:
> 
> I then copied another test sheet and deleted all entries below December,
> calcs and cursor moves worked fine.
> 
> Therefore I concluded that the problem is with the dates after
> December.  I am doing no date math.  This seems like a LO internal
> (Java?) problem.
> 

Make a backup copy.
Select all (Ctrl+A)
Hit the backspace key and select Objects for deletion.
Hit Ctrl+Shift+Space (menu:Format>Clear Direct Formatting...)
Same with any other sheet.
With the raw data and formulas it should make a huge difference.



-- 
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: LO for Android - is there more than a Viewer available? Beta maybe?

[Andreas Säger]

Dreams are free.



--
View this message in context: 
http://nabble.documentfoundation.org/LO-for-Android-is-there-more-than-a-Viewer-available-Beta-maybe-tp4182275p4182372.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

[libreoffice-users] Re: LO for Android - is there more than a Viewer available? Beta maybe?

[Andreas Säger]

Am 29.04.2016 um 11:19 schrieb Andreas Säger:
> 
> Your initial question was if there is more than a viewer for Android and
> now you come up with issues of taste and branding.

Sorry. It was Tim's initial question.



-- 
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: LO for Android - is there more than a Viewer available? Beta maybe?

[Andreas Säger]

Am 29.04.2016 um 03:30 schrieb James Knott:
> On 04/28/2016 06:02 PM, Tim---Kracked_P_P---webmaster wrote:
>> I chose LibreOffice over all of the forks out there.
> 
> Ummm...  LibreOffice is a fork of OpenOffice.
> 
> 

Your initial question was if there is more than a viewer for Android and
now you come up with issues of taste and branding.

It is the decision of those who actually do the work.
They may find the Apache license more attractive.
They may be familiar with the old code base but not with the forks.
The "stability" (lack of development) could be attractive too.




-- 
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: LO for Android - is there more than a Viewer available? Beta maybe?

[Andreas Säger]

Am 29.04.2016 um 00:02 schrieb Tim---Kracked_P_P---webmaster:
> 
> I would rather have a LibreOffice for Android instead of Open Office for
> Android.
> 

I trust that the developers who made this happen know exactly what they
are doing.


-- 
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: LO for Android - is there more than a Viewer available? Beta maybe?

[Andreas Säger]

Do you really believe in brands?



--
View this message in context: 
http://nabble.documentfoundation.org/LO-for-Android-is-there-more-than-a-Viewer-available-Beta-maybe-tp4182275p4182305.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

[libreoffice-users] Re: LO for Android - is there more than a Viewer available? Beta maybe?

[Andreas Säger]

Am 28.04.2016 um 17:55 schrieb Tim---Kracked_P_P---webmaster:
> With the posts about iOS version is not available [on the Website list],
> I remember reading something about an Android version that was more than
> just a Viewer.
> 
> Is there an Android version yet, that can edit documents?  Even if it is
> a Beta version.
> 

https://play.google.com/store/apps/details?id=com.andropenoffice



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

[Andreas Säger]

Am 25.04.2016 um 05:52 schrieb Bo Siltberg:
> The site wants me to install a client, what is this client used for?
> My antivirus program claims it contained "Variant.Graftor.5639" and deleted
> it...
> 


Hakuna Matata

> https://malwaretips.com/blogs/gen-variant-adware-graftor-removal/



-- 
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: open a Mac numbers file in calc?

[Andreas Säger]

This is not a universal file opener. Universal file opener do not exist.



--
View this message in context: 
http://nabble.documentfoundation.org/open-a-Mac-numbers-file-in-calc-tp4181740p4181825.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

[libreoffice-users] Re: Err:504 with DDE links since LO 4→5 upgrade

[Andreas Säger]

Am 20.04.2016 um 17:21 schrieb martin f krafft:
> also sprach Andreas Säger <ville...@t-online.de> [2016-04-20 17:11 +0200]:
>> Works for me. DDE works with system notation ("C:\path name\file
>> name.ods") and with URL notation
>> "file:///C:/path%20name/file%20name.ods". Try the system notation.
> 
> For testing purposes, I made a copy of the file and used the
> absolute path in system notation. The result is the same.
> 
> I did notice that — with relative or with absolute paths — that the
> DDE() calls work in some contexts, but not in others. It seems very
> very brittle and I cannot figure out why.
> 

Avoid all special characters in path names, i.e. all sorts of quotes.

>> Call menu:Edit>Links to inspect links and delete unused links.
> 
> See my other question on the list: There are thousands of unused
> links there and I can't delete them other than individually, which
> can't be the solution.
> 

It's a heavy misuse of spreadsheets.

> I wouldn't be surprised if Libreoffice just can't handle all these
> inactive links and chokes.
> 

No spreadsheet can deal with that properly.


-- 
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: Deleting external links

[Andreas Säger]

Am 20.04.2016 um 15:45 schrieb martin f krafft:
> Hey list,
> 
> we are dealing with a rather complex spreadsheet and looking at
> Edit→Links, there are literally thousands of links in there that are
> no longer used anywhere in the document. Opening the document (and
> saving, and sometimes editing, and …) takes several minutes, and we
> think this is due to the sheer massive number of links.
> 
> We found that links can be individually deleted (broken), but we
> were wondering if there's a way to do so in bulk? Or better yet, how
> can I automatically remove unused references in this list?
> 
> Thanks for any hints,
> 

There are 5 different types of spreadsheet links. Some appear in
menu:Edit>Links, database links can be organized in menu:Data>Define

DDE("soffice";"path_name","ref") and URL links
'file:///path/name.ods'#$Sheet.A1 are established by formula
expressions. Before you can delete them in the links dialog, you have to
remove all formula references.

[Tutorial] External Links In Calc:
> https://forum.openoffice.org/en/forum/viewtopic.php?f=75=3294




-- 
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: Err:504 with DDE links since LO 4→5 upgrade

[Andreas Säger]

Am 20.04.2016 um 15:43 schrieb martin f krafft:
> Hey list,
> 
> We're dealing with a complex document containing hundreds of DDE
> links. Worse yet, those DDE links are dynamically created, e.g.
> using the following formula to reference filename ($B$2), sheet name,
> ($B$3), column ($B$6), and row (in column $A starting at $A8):
> 
>   =DDE("soffice";
> CONCATENATE("file:./";$B$2);
> CONCATENATE("$";$B$3;".$";$B$6;"$";$A8);
> 0)
> 
> This worked very well a year ago, but when we tried to open it as of
> late, we get "Err:504" (parameter list error) all over.
> 
> The only thing that's changed is that we've since upgraded from
> Libreoffice 4 to version 5.
> 
> Are you aware of (a) the relevant change, and (b) a remedy to this
> problem, so that we can use DDE links as we used to with Libreoffice
> 5.1.2?
> 
> Thanks,
> 

Works for me. DDE works with system notation ("C:\path name\file
name.ods") and with URL notation
"file:///C:/path%20name/file%20name.ods". Try the system notation.
Call menu:Edit>Links to inspect links and delete unused links.


-- 
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: Error on creation of sum in write table

[Andreas Säger]

Am 19.04.2016 um 18:52 schrieb Heinrich Stoellinger:
> Hello,
> I am trying to create a sum of arithmetic columns in a writer table, using
> the procedure described in the help document. I put the cursor into the
> cell that the sum should end up in, press F2, then select the first cell
> that is part of the sum (eg. ) and then drag the mouse down to the last
> cell (eg. ). When I press "enter"  The procedure creates
> "=SUMME",
> which seens to be correct to me. Nevertheless I get the error "**
> Fehlerhafter
> Ausdruck **" (=erroneous expression). What am I doing wrong?
> Thanks for your help
> H. Stoellinger
> 

=SUMME() with braces.


-- 
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: Calc method to change whole column cell content

[Andreas Säger]

If you would read the initial posts of the topics you are replying to ...

MRZenwiz:
> What I've been doing is loading the .csv file into a text editor,
> change those fields and then reload into calc.  This is terribly
> cumbersome.

> However, in the .csv file they send, the dollar transactions are all
> given as text entries with ($xxx.xx) for negative entries and $xxx.xx
> for positive entries. 

which is perfectly well handled by Calc's csv importer. 90% of all text
import trouble can be answered with:
1. Choose the right locale which is English(USA) in this particular case
because of the $ currency, the point decimals and propably there are
also M/D/Y dates in the file.
2. Always check "interprete special numbers". A special number is
anything beyond digits with decimal separator. This option is obsolete
since it should be always on. You can mark individual columns as text
when you do not want them to be interpreted as special numbers. But once
the option has been checked it remains checked for subsequent csv imports.


-- 
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: Calc method to change whole column cell content

[Andreas Säger]

Am 13.04.2016 um 18:23 schrieb James E. Lang:
> And there *are* text editors (even on Windows) that use regular expressions 
> and thus can perform the transformation relatively painlessly.
> 
> All the best!
> 

Writer is one of them. Calc supports regular expressions as well.

I have tested dozends of different csv flavours with all types of text,
numbers and subtypes of numbers. With one exception they imported all
well. The exception was $(123.98) for a negative amount which could be
fixed with a simple regex replacing "^\$\(" with "($". Calc is an
excellent csv import tool which imports correct cell values where other
spreadsheet apps import text and try to interprete the text on the fly.


-- 
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: Calc method to change whole column cell content

[Andreas Säger]

Am 13.04.2016 um 12:32 schrieb Tom Davies:
> Hi :)
> CSV format can be easily edited in normal text-editors before opening in
> Calc.  Sometimes its easier to use a simpler tool to do a part of the job
> rather than use a complicated route in a heavier tool such as Calc.
> Regards from
> Tom :)

Really? And how do you convert (£1,234.98) into -1234.98 in columns 3,
17 and 23 across thousands of rows using a text editor? Are YOU able to
do this actually?
Don't you think that checking "English(UK)" and "Interprete Special
Numbers" is by far easier?


-- 
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: Importing CSV file into Calc with records determined by the number of field separators instead of Line Feeds

[Andreas Säger]

Am 11.04.2016 um 06:26 schrieb Philip Rhoades:
> People,
> 
> I need to import a CSV dump from an Android SMS Sqlite DB - the problem
> is, many of the SMSs have line breaks in the text body of the DB record
> and this messes up the import into Calc.  There does not seem to be any
> way of saying to Calc: "Count x fields for each record" instead of
> recognising a record by a LF . .
> 
> Can anyone think of a nice, easy fix for this problem?
> 
> Thanks,
> 
> Phil.

You should be able to connect a Base document to the SQLite DB. Then
your spreadsheet can access the database directly.

CSV is not a file format. It is mere convention. If you have multi-line
filds, you've got to export with text delimiters (in most cases quotes).
Everything between a pair of text delimiters can be treated as one text
value.


-- 
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: Calc method to change whole column cell content

[Andreas Säger]

Am 08.04.2016 um 13:49 schrieb Bruce Hohl:
> Method 1 - Using Value()
> Use value() function to convert a text string into a number or date.
> Copy the result; paste special as number or date.
> ---
> Method 2 - Search & Replace
> Select (highlight) a cell range then:
> Using Search & Replace (Ctrl+H):
> Search for = .*
> Replace = &
> Under Other Options:
> Y = Current selection only
> Y = Regular expressions
> Click Replace All
> 

Method 3 - Text to Columns
Select a column of cells
Call Data>Text to Columns...
Choose tab as delimiter and hit [OK]

All 3 methods require that your locale setting matches with the data to
be converted.
($1,2345.98) requires English(USA) because of the $, the comma as
thousands separator and the decimal point.
(£1,2345.98) requires English(UK) because of the £, the comma as
thousands separator and the decimal point.
(€1.2345,98) requires German or French because of the € the point as
thousands separator and the decimal comma.

menu:Tools>Options>LanguageSettings>Locale (second option) determines
the cultual context of all text-to-number conversions.

Better you do not import numeric text in the first place. Wrong dates
(2/3/1999 vs 3/2/1999) and wrong numbers (1.234 vs 1,234) can be very
difficult to convert. Simply check the right locale in the import dialog
together with the "detect special numbers" option.


-- 
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 5.1.1.3 on Windows 7

[Andreas Säger]

Am 08.04.2016 um 04:04 schrieb Henry Sikkema:
> Thank you Andreas, for the suggestion.  Running Windows 7 in SafeMode
> allows the file to load!  So how do I find the offending files or
> configuration?
> 
> Henry
> 

I don't know. My knowledge about Windows is very limited.



-- 
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 5.1.1.3 on Windows 7

[Andreas Säger]

Am 08.04.2016 um 03:02 schrieb Henry Sikkema:
> I tried a complete re-uninstall and deleted the profile folder and
> reinstalled and a new profile folder was created when I started LO Calc
> again.  The file still crashes LO Calc on my machine but not on the other
> machine.
> 
> Aside from a complete re-install of Windows 7, I do not know what else to
> attempt.
> 
> *Henry*

Start Windows in protected mode, start LibreOffice and see if protected
mode makes any difference.



-- 
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: Calc method to change whole column cell content

[Andreas Säger]

Am 08.04.2016 um 01:35 schrieb MR ZenWiz:
> I recently began to use the spreadsheet downloads from one of my
> credit unions as it is so far superior to the home-grown method I have
> been using it's not even funny.
> 
> (I know, way late... Cries of "luddite" in the background, etc.)
> 
> However, in the .csv file they send, the dollar transactions are all
> given as text entries with ($xxx.xx) for negative entries and $xxx.xx
> for positive entries.  I don't see a way inside calc either to simply
> convert that to a currency amount or to strip out the leading
> apostrophe/quote mark that inhibits proper evaluation of the field.

Language = English(USA)
[X] Detect Special Numbers



-- 
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 5.1.1.3 on Windows 7

[Andreas Säger]

Am 07.04.2016 um 21:19 schrieb Henry Sikkema:
> Would an uninstall remove this configuration file? ... if so, I have
> uninstalled twice and reinstalled and the problem persists.
> 
> *Henry*

No.



-- 
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: file format problem?

[Andreas Säger]

Am 07.04.2016 um 04:20 schrieb Thomas Blasejewicz:
>>
>> [these are MsFt not LO documents.]
> After the trouble occured, I copied TEXT ONLY into Writer, finished work
> there AND THEN saved first as .odt and then as .docx (same file)
> 
> Necessity for Word format: translation agencies send me those Word file
> -> expect them to be "overwritten" ->
> AND expect Word files back. Which will then be sold to the clients who
> ordered the translations. (translation not of file formats, but of text:
> manuals, books, letters etc.)
> If I start mumbling "I use only odt format ...", they will probably stop
> sending me work. Then I will starve to death ...
> 
> 
> 

But why don't you use MS Word then? Any old copy of Word'98 generates
perfectly valid .doc files.


-- 
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: Adding decimal minutes to regular minutes and hours (calc)

[Andreas Säger]

Am 06.04.2016 um 19:27 schrieb James Knott:
> 
> While I haven't done this in a spreadsheet, I used to on a calculator. 
> I did it by converting between decimal degrees and degrees, minutes &
> seconds.
> 
> BTW, as an indication of how long ago I did this, I used this method to
> add up the time for tracks on an LP to figure out how much time I'd need
> on a cassette.  ;-)
> 
> 

You could have used a spreadsheet back in the 80ies and it would be the
exact same method. Either multiply the days by 24 to get hours or change
the number format. As a third method you may separate full days from day
fractions.

A1: =PI()
=int(A1) => 3 full days
=mod(A1;1) => 3:24 (about 1/7 of a day)

A1 formatted as HH:MM => 03:23 (time on day #3)
A1 formatted as [HH]:MM => 75:24 (showing full hours)
=A1*24 => 75.4 hours


-- 
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: Adding decimal minutes to regular minutes and hours (calc)

[Andreas Säger]

Am 06.04.2016 um 15:36 schrieb John Meyer:
> Hi,
> 
> I have a project where I am trying to calculate the total amount of work
> hours for a project based upon the timestamp of calls throughout the
> day.  The time at which the calls is placed is in hh:mm:ss while the
> duration of the call is in decimal time.  I need to take the last call
> of the day and add the decimal time to get an accurate shift time.Do
> I just put the hh:mm:ss time in the time function and add that to the
> decimal time?
> 
> Thanks.
> 

Spreadsheet dates are formatted numbers in unit "Days".
0.0 <==> 00:00
0.25 <==> 06:00 1/4 of a day
0.5 <==> 12:00 1/2 of a day
0.75 <==> 18:00 3/4 of a day
1.0 <==> 24:00 (with number format [HH]:MM)

There is no difference between the day fraction on the left and the
formatted number on the right. Both sides yield the exact same results
for all kinds of calculations and comparisons.
Multiply by 24 in order to convert days to hours and switch to some
decimal format when the result looks wrong.

Number format [HH]:MM displayes hours beyond 24 as full hours. This
number format should be used when you want to express time spans in
hours. A time span of 2 days and 3 hours (value 2.125) formatted as
HH:MM shows 03:00 (the hours at a point of time) whereas [HH]:MM shows
51:00.

The first method actually calculates the amount of hours, the formatting
solution provides a more adequate representation of time spans without
any conversion.


-- 
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: Calc as a Flat File Database

[Andreas Säger]

Calc menu:Data>Form...

https://forum.openoffice.org/en/forum/viewtopic.php?f=21=77543 includes a
macro to extract and reconnect all forms from a database document.
Background: https://forum.openoffice.org/en/forum/viewtopic.php?f=83=40493



--
View this message in context: 
http://nabble.documentfoundation.org/Calc-as-a-Flat-File-Database-tp4177965p4179316.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

[libreoffice-users] Re: question about the best version of libreoffice - MY God is better!

[Andreas Säger]

Am 27.01.2016 um 21:23 schrieb Sergio Gutierrez:
> Hi, to all who had been participating, for some time now, in this
> nonsensical religious comments. When I accepted to receive e-mails from
> this user group, I thought that it could be useful whilst using Libre
> Office. I never expected to become involved in religious arguments, or
> being forced to read any religious preaching. In most forums everybody is
> compelled to keep postings within the subject for which they were set up,
> and anybody that strays from that is usually removed. Since this forum has
> lost its direction (with the approval of some member that confuse tolerance
> with the lack of respect for other people), it's time for me to leave.
> Since this e-mail does not have the usual "unsubscribe" link, I will put it
> into the "junk mail" section, where it belongs.
> Have a nice day.
> 

+1



-- 
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: LO-Base - Autoreconnect

[Andreas Säger]

Am 27.01.2016 um 13:16 schrieb Walther Koehler:
> Hello list,
> 
> me too would like to have a reconnect:
> 
> When LO-Base the first connection to a dBase 
> database (directory) has made, all the existing *.dbf files in that directory 
> are recognized and shown as tables in *.odb.
> 
> However, if you add manually or by a third party program another *.dbf, it is 
> not recognized until one terminates the running LO (usually with many open 
> writer, calc files).
> 
> Is there a way other than by a makro (getTables()) to update the tables 
> (=*.dbf file list) while in LO Base?
> 
> Walther
> 

menu:View>Refresh Tables


-- 
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: difference between Excel and Calc

[Andreas Säger]

Am 26.01.2016 um 13:53 schrieb Ian McCarthy:
> Hi I'm porting a spread sheet from Excel to LibreOffice Calc and I've
> fallen over an incompatibility
> as spread sheet will be used by both tools is there a switch I can use.
>  The problem
> =CELL("filename",A1) in LO returns
> 'file:///C:/Users/Ian Mac/Desktop/Accounts15-16.xls'#$Sep 15
> 
> where as in Excel the returned data is different
>  cant easily paste the excel result here but the terminal filename is in
> square brackets
> is there a way I can either spot which program I'm using and therefore
> switch the detection of the sheet name
> 
> using  LibreOffice 5.0.4.2
> 

=LEFT(CELL("FileName");8)="'file://"
returns TRUE in Calc and FALSE in Excel


-- 
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: [calc] is there a GOAL_SEEK function somewhere?

[Andreas Säger]

Am 26.01.2016 um 11:47 schrieb Larry Evans:
> I've checked that the value returned by the YIELD function:
> 
> https://help.libreoffice.org/Calc/Financial_Functions_Part_Two#YIELD
> 
> can be gotten by using [Tools>Goal Seek...] and the PV function:
> 
> https://help.libreoffice.org/Calc/Financial_Functions_Part_One#PV
> 
> Is there some way I could use a something like a GOAL_SEEK function
> to implement my own version of YIELD?  IOW, without having to go
> through the answering of the [Goal Seek] dialog window requesting
> Formual cell, Target Value, and Variable cell?
> 
> TIA.
> 
> -regards,
> Larry
> 
> 

menu:Tools>Goal Seek ?


-- 
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 Base and MySQL

[Andreas Säger]

Am 24.01.2016 um 09:04 schrieb Hank Alper:
> Hi Ian,
> I frequently import Calc Spreadsheets into my MySQL database using
> phpMyAdmin.. My version of phpMyAdmin asks to locate the File you wish to
> import.Specifically, it offers a Browse option. Locate the Calc file you
> wish to import.by browsing to it in your file system.
> It also asks for the type of file you wish to import. One of the options is
> ODF spreadsheet.That's the format of Calc, isn't it ?
> No need to convert to CSV File.
> Hank
> 

Open the spreadsheet document. Ensure that your data are organized as a
normalized list where numbers are numbers, dates are dates and times are
times. Quite often and for no reason, Excel sheets are poisoned with
text data which makes them rather useless. If you can not distinguish
the data types in a spreadsheet, there is no hope anyway.

Copy the normalized list of valid data including any header row.
In the Base document which is connected to your MySQLDB click the _icon_
of a target table where you want to append the spreadsheet data and paste.
A wizard pops up where you can map the fields of the clipboard data to
the fields of your database table.

This may raise 3 types of errors:
-- referencial integrity errors
-- not nullable errors
-- wrong data type errors
Each of these error types can be answered with "Cancel" or "Ignore". The
ignore option will try to import as much as possible without raising the
same error again.

Some helpful spreadsheet formulas to test spreadsheet data for consisteency:

> =MAX(LEN(column))[Ctrl+Shift+Enter] returns the max. length of a text column.
> =COUNTBLANK(column) counts blanks.
> =COUNTA(column) counts any values
> =COUNT(column) counts numbers
> =COUNTA(column)=COUNT(column) TRUE if there are only numbers.
> =AND(ROWS(COLUMN)=COUNT(column);COUNTA(column)=COUNT(column) TRUE if there 
> are only numbers and now blanks.
> =MIN/MAX(column) min and max values of a column
> =N(MATCH(value;column;0)) returns 0 if value does not occur in some other 
> table's column (test referencial integrity).
> =COUNTIF(value;same_column)>1 returns TRUE if there are duplicates in the 
> same column.

=MATCH(value ; other_list ; 0) tests referencial integrity against
another table.


-- 
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: Auto Increment Doesn't Work

[Andreas Säger]

Am 25.01.2016 um 10:44 schrieb Marion & Noel Lodge:
> Hi Tim,
> 
> It may depend on which Database you are using with LibreOffice.
> 
> I use the H2 Database and in my tables if I make CustomerID's type
> BigInt[Identity],
> then AutoValue = 'Yes works.  That might be worth trying in your situation.
> 
> Noel
> --
> Noel Lodge
> lodg...@gmail.com
> 

The Base GUI does not change this attribute for an existing field.
Tools>SQL...
ALTER TABLE "table name" ALTER COLUMN "CustomerID" INTEGER GENERATED BY
DEFAULT AS IDENTITY;
[replace "table name" with the actual name of your table in double-quotes]

menu:View>RefreshTables...


-- 
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: Base: problem with where clause in a select query.

[Andreas Säger]

Am 25.01.2016 um 10:28 schrieb Egbert Eissing:
>  
> 
> I must be doingsomething wrong: Here is the where clause of my select query 
> within amacro:
> WHERE ""EmployeeID""='" + sEmployeeID + "' AND ""ItemValue""<> '0' AND 
> ""MidOrEndMonth"" = '0'")
> Instead of returningthe table rows where “ItemValue” IS NOT “0”, it returns 
> therows where the “ItemValue” IS “0”. On the other hand, if Iplace this query 
> into the query editor, it returns all the rowscorrectly. 
> I would appreciateif someone could point out to me how the syntax could be 
> improved tothat the correct rows are being collected. 
> Thanks for yourhelp.Egbert
> 

Macros are a no-go. Simply use parameter queries. Before you try to
concatenate an SQL statement in stupid Basic, you should test the
statement in the query designer. Then debug your Basic code. Test if the
SQL string is exactly the same string that does work in the GUI.


-- 
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 Base and MySQL

[Andreas Säger]

Am 21.01.2016 um 13:20 schrieb Heinrich Stoellinger:
> Of course these are valid values as for as CSV is concerned, but not ALL
> are
> valid as far as MySQL goes. I have no problem restoring MySQL-DATE COLUMN
> values, but represent them as "2014-12-22", the same as character strings.
> Forget Base at the moment and deal with the stipulations of SQL, in
> particular
> MySQL.
> 
> On Thu, 21 Jan 2016 11:37:51 +0100, Jaroslaw Staniek 
> wrote:
> 

Of course, ISO dates are the one and only unambiguous standard for date
strings. It is not too difficult to convert other date strings with 3
numbers and 2 separators into ISO strings which can be converted to real
date values.


-- 
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: use calc rows as fooier

[Andreas Säger]

Am 20.01.2016 um 22:06 schrieb Keith Bainbridge:
> Good morning All
> 
> 
> 
> It's been a while.
> 
> 
> 
> I am trying to use 4 rows on a calc sheet as a footer, in addition to a
> header row. Can only see how to use rows as a header.
> 
> 
> Any hints please?
> 
> 
> Thanks
> 
> 
> 


If I recall correctly, the following macro writes cell contents into
page headers and footers:
> http://sourceforge.net/projects/ooomacros/files/Calc%20Header_Footer/




-- 
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: question about the best version of libreoffice:

[Andreas Säger]

Am 21.01.2016 um 01:42 schrieb Tom Davies:
> Hi :)
> Many people on this mailing list have had signatures that include
> Bible quotes or such-like without anyone grumbling or anything.  I
> thought it was nice to see something similar from a different religion
> for a change.
> 
> Regards from
> Tom :)
> 
> 
> 
> 

And I tend to ignore all of them instinctively. I would not have
answered this topic if I had noticed that sermon.
Interesting how the least relevant null topics trigger the most
extensive discussions on this list. Trolls at work.


-- 
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: question about the best version of libreoffice:

[Andreas Säger]

Am 21.01.2016 um 06:54 schrieb James E. Lang:
> Hi Andreas and Tom,
> 
> It was good to see that someone actually responded to the question that was 
> asked about LO. I don't make much use of Writer so I have little but civility 
> to contribute. I have *reflowed* your messages as quoted below my signature.
> 
> I would think that for the casual user of Writer who mostly uses it as a text 
> document reader like the original poster said describes his usage of LO, it 
> makes little difference which version of LO one uses. 
> 
> The diatribe that occurred against the original poster's signature block is 
> regrettable and in my opinion unwarranted. While I'm convinced that Islam is 
> in error and Christianity is true, I can pray for the followers of Islam and 
> for the peace of Jerusalem.
> 

I'm still convinced that the poster is not interested in the answer to
his technical question. And like so often we will not see any feedback
regarding the answers to his on topic question. Therefore I call him a
troll.


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

[Andreas Säger]

Am 22.01.2016 um 01:17 schrieb Dave Stevens:
> Quoting James Knott :
> 
>> And it's all nonsense.  The bible is provably fiction.
> 
> is it possible to park this thread or take it off-list?
> 
> Dave
> 

The religious bullshit is disturbing indeed. But we have to cope with it
wherever it rains down on us. Leave the censorship up to them and get
back to the drawing board.


-- 
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 Base and MySQL

[Andreas Säger]

When using HSQL (which is less powerful than MySQL) command CREATE TEXT
TABLE "Foo"(...) prepares a table "Foo" with fields and indices just
like a regular data table. A second command SET TABLE "Foo"... links the
text table "Foo" to a particular text file.
If the linked text table and the underlying csv and the target table
share the same structure with same data types in same order of columns,
I can simply drag the text table icon over the icon of the regular data
table and confirmt the import dialog without further adjustments.
If this precondition is not met or when data type conversions are needed
(e.g. text with German comma decimals and D.M.Y dates) then I create a
view to return all fields with the right types in right order and drag
the view over the data table. HSQL only accepts text data with point
decimals and ISO date/times.
With the right setup it is just a simple drag operation with no
spreadsheet involved. The setup is development work because it requires
understanding simple data types. Same problem with csv to spreadsheet
imports which will fail in most cases when you ignore the import options
because you don't understand them.


-- 
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 Base and MySQL

[Andreas Säger]

How can anybody solve any csv related problem without knowing anything about
the actual content?

4 different lines of perfectly valid and commonly used csv data:

1234.98;2014-12-22
1.234,98;22 Dez 2014
1234.98;12/22/14
1234.98;22/12/14

Each line carries the exact same information. I could add a thousand more
different lines with the exact same values without leaving the conventions
of valid csv.



--
View this message in context: 
http://nabble.documentfoundation.org/LibreOffice-Base-and-MySQL-tp4172396p4172475.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

[libreoffice-users] Re: R1C1 reference style with LibreOffice

[Andreas Säger]

Am 20.01.2016 um 10:17 schrieb pacopyc pacopyc:
> Ok, but the problem is that I must do it from LibreOffice basic code.
> 

If you would spend more than an hour or two with this matter, you would
not have to wait days for the answer.




> https://forum.openoffice.org/en/forum/viewtopic.php?f=74=49294

> http://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1table_1_1XCellRange.html#details

> http://www.pitonyak.org/oo.php






-- 
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: question about the best version of libreoffice:

[Andreas Säger]

Am 20.01.2016 um 13:36 schrieb Andreas Säger:
> 
> I used 3.5 for many years with no problems.
> 
> 

Oh, shit. Did I feed a troll?


-- 
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 Base and MySQL

[Andreas Säger]

Am 20.01.2016 um 11:05 schrieb Ian Whitfield:
> Hi All
> 
> I have been trying to import a CSV file from Calc into MySQL to run with
> Base for over a week now and can not believe this is so difficult to do
> so I'm hoping some other Base users might have cracked this one!!
> 
> My OpSys is PClinuxOS - 32-bit and MySQL is ver 5.1.73. Everything is
> running on localhost.
> 

Database admins don't use spreadsheets. MySQL can do this very well. Of
course, csv is not a file format. It is mere convention with millions of
different flavours.



-- 
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: Need help and don't know where to even start.

[Andreas Säger]

Am 19.01.2016 um 09:45 schrieb JL:
> Good evening all,
> 
> I've found myself in a position where I need to drop serious weight for
> health reasons.  I have a diet that works (more a complete change of
> eating) but I need help in the planning of it. 


I'd suggest pencil & paper or one of these smartphone apps.





-- 
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: Transferrig a parameter to a sub form

[Andreas Säger]

Am 15.01.2016 um 04:23 schrieb Egbert Eissing:
>  I have a form with atable control which lists all the employees, and a 
> sub-form with atable control that lists the payroll data of each employee. 
> If an employee isselected in the first table, the employeeID should be passed 
> to thesub form to filter the data for the selected employee. The code 
> couldlook something like this:
>  oDoc=ThisComponent.DrawPage.Forms 
> oFormACemplData=oDoc.getByName("ACemplData”) ' main form 
> oFormPayrollData=oDoc.getByName("FormPayrollData”) ' sub form
>  oEmployeeID =oForm.getByName("employeeID") ' employeeID is theparameter for 
> TablePayrollData. sEmployeeID =oEmployeeID.text  oFormPayrollData.Parameter= 
> setINT(sEmployeeID) oFormPayrollData.refresh()
> It is this second tolast line, the syntax of which I do not know, and have 
> not been ableto find in any of the examples I have read and re-read. 
> Alternatively, if itis not possible to just pass a parameter to the table, 
> may be it ispossible to pass a complete prepared statement instead. 
> Could anybodyprovide some clue on how to do it?Thanks for helping. Egbert
> 

Apply master and slave fields to the subform. No macro required. For
more than A=B AND X=Y bindings, you can bind the subform to a parameter
query and link paramA=X AND paramB=Y while paramA and paramB can be used
with all kinds of functions and operators.


-- 
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: maybe is missing formatting character encoding?

[Andreas Säger]

Am 13.01.2016 um 15:29 schrieb manuel_songo...@yahoo.it:
> hello
> my file TXT and CSV, there are bad character encoding (�,é,..)is there 
> formatting for encoding?maybe is missing this feature for libreoffice...?
> 

Sceenshot
> https://forum.openoffice.org/en/forum/download/file.php?id=12809

The topmost setting is the character encoding. Adjust it until the
preview looks right.
The second setting describes the ingoing numerals. USA for M/D/Y dates
and point decimals, UK for D/M/Y dates, German for D.M.Y dates and comma
decimals etc.
Always check the "special numbers" option.
In the preview you can override the general settings for individual
columns. In the screenshot the ZIP column is marked as text.


-- 
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: Displaying data on an unbound field

[Andreas Säger]

Always the same answer:

> https://forum.openoffice.org/en/forum/viewtopic.php?f=20=81276=375294#p375294

Using the GUI, I can set the default value for an unbound text box
belonging to any form or subforme, and nothing changes this text. Then I
can inspect this text box using MRI and find out the property I need to set.


-- 
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: BaseForms: transferring contents of data fields to the database table

[Andreas Säger]

Am 05.01.2016 um 04:24 schrieb Egbert Eissing:
> I have a main form and a sub form. 
> The main form holds one single record, the sub form contains multiple records 
> related to the record in the main form. 
> Both forms are holding alphanumeric and also pure numeric data. 
> I wrote a macro to evaluate and calculate the numeric data in the sub form 
> and deposit the results in fields of the main form. 
> 
> Now my problem: The numbers placed in the main form fields by means of the 
> macro are not recognized by the back end MySQL database. These simply are not 
> transferred, whatever I do. (If I write some figures in manually, the same 
> are being transferred without problem.) What can I do to work around this 
> problem? Is there any kind of trick that makes the form believe that the 
> automatically generated data have been put in by hand and treated 
> accordingly? I am sure there must be a solution to this. 
> Thanks for any help. 
> 

Please refer to other peoples working code. There are far too many
problems and pitfalls with this API to answer this question out of thin air.


-- 
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: How to close *.dbf files in a Base (makro)

[Andreas Säger]

Am 03.01.2016 um 12:17 schrieb Walther Koehler:
> Hello list, high Andrew Pitonyak,
> 
> After an SQL UPDATE in a makro, the updated *.dbf is still marked as open
> (in LINUX see fuser *.dbf), until the last instance of LO is closed. This is 
> nasty, because I have usually many files open and want ot access the *.dbf by 
> other progs. How do I close that file?
> 
> [Even
> oDoc=dataSource.DataSourceDocument
> oDoc.close
> doesnt help (the *.odb wasnt open anyway)]
> 
> Walther
> 
> Andrew, thank you for your makro guide!
> 

Close the _connection_ to the database.
Basic snippet generated by MRI:

> Sub Snippet(Optional oInitialTarget As Object)
>   Dim oObj1 As Variant
>   Dim oConnection As Variant
>   Dim oTables As Variant
>   Dim oObj2 As Variant
> 
>   oObj1 = oInitialTarget.getByName("Bibliography")
>   oConnection = oObj1.getConnection("", "")
>   oTables = oConnection.getTables()
>   
>   oObj2 = oTables.getByName("biblio")
>   oConnection.close()
> End Sub

When I access oObj2, fuser reports the office process owning biblio.dbf.
After closing the connection, fuser reports no process.
However, I am not sure about the side effects of connection pooling or
any other office connections to the same database (spreadsheet links,
serial letters, opened forms). IMHO, it could be that other connections
still access your database after closing the connection that had been
established by your macro.



-- 
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: Base: create form wizard sub-form error

[Andreas Säger]

Am 23.12.2015 um 17:21 schrieb Blake McBride:
> Greetings,
> 
> I am using LibreOffice Base 4.4.3.2 on 64 bit Linux with a PostgreSQL DB.
> 
> I have a hierarchy of tables such that:
> 
> Table A
> Table B (many B to one A relationship with Table A)
> Table C (many C to one B relationship with Table B)
> and so on...
> Table E
> 
> 
> I am trying to use the Form Wizard to create a form that allows the user to
> edit tables A and B only.
> 

Forget the form wizard. It is close to useless. Get the "Form Design"
toolbar. Hit the 5th button ("Form Navigator"), right-click the forms
collection and start your own hierarchy of forms and subforms with grids
and list boxes. Subforms and list boxes are the elements which help you
to edit 1-n relations and m-n relations as well.

[Tutorial] Forms in OpenOffice.org Base
> https://forum.openoffice.org/en/forum/viewtopic.php?f=83=28235

[Tutorial] Creating a form in Design view
> https://forum.openoffice.org/en/forum/viewtopic.php?f=83=32757

[Example] Relations reflected by list boxes in forms
> https://forum.openoffice.org/en/forum/viewtopic.php?f=100=40444




-- 
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: Base: connecting to a DB without requiring a password

[Andreas Säger]

Am 22.12.2015 um 20:26 schrieb Blake McBride:
> I am trying to build a simple interface app for a user.  With 35 years
> experience in software development, I can tell you:
> 
> 1.  It is customary to password protect a database to prevent unauthorized
> access.
> 
> 2.  It is customary for applications that validate a user to have the
> password embedded in the program so that each user doesn't have to know the
> DB password.
> 

You can store the password in the database document but the GUI does not
offer this option. The database document is zipped XML with no
encryption. If you save the user's database password in the document,
anybody with a zip tool and editor can read it.

> That is what I am trying to do with Base.  (Also, I see no relationship
> between your link and my question.)
> 

As a professional with 35 years experience in software development you
should be able to read. If you had one drink too many, the screenshot
indicates clearly that my tool can store the log-in flag, the user name
and the passord (together with jdbc:hsqldb: connection parameters).

If you have any problem with code written by hobbyists, you may be
satisfied with this reference:

> http://api.libreoffice.org/docs/idl/ref/servicecom_1_1sun_1_1star_1_1sdb_1_1DataSource.html

which should help you to write your own code storing a password in a
database document.


-- 
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: Base: connecting to a DB without requiring a password

[Andreas Säger]

Am 21.12.2015 um 22:47 schrieb Blake McBride:
> What I want is to keep the password on the database but not require user
> entry of it.  I have tried a bunch of stuff.  I added UserName and Password
> to the odbc,ini file.  I also tried adding "Password=xyz" to Base's
> database properties under ODBC options.  I also tried unchecking the
> "Password required" option on Base DB setup.
> 
> No matter what I do, it insists on getting a password.
> 

Of course it does. If you are the admininstrator of that database remove
the password from your database account. If not, ask the responsible
admin to do it for you.

Anyhow:
https://forum.openoffice.org/en/forum/viewtopic.php?f=21=77543 lets
you store the "password required", the user name and the password
_unencrypted_ within the database front-end. It is definitively a
security breach.
Install the oxt and call Tools>Macros>Run>FreeHSQLDB.FreeHSQLDB.Main.
The macro shows a dialog to connect this document with an external
HSQLDB but the upper part with registration and log-in works with all
types of databases.


-- 
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: Calc formula syntax assistance

[Andreas Säger]

Am 19.12.2015 um 18:42 schrieb Hylton Conacher (ZR1HPC):
> 
> Any ideas to get the correct answer of the number of times a field appears?
> 

https://wiki.documentfoundation.org/images/4/47/CG41-CalcGuideLO.pdf
(chapter 8 on pivot tables)



-- 
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: Cannot assign template to existing writer odt file

[Andreas Säger]

Am 16.12.2015 um 19:05 schrieb V Stuart Foote:
> 
> @Andreas, I don't agree with your assessment.  The
> XDocumentPropertiesSupplier is fully functional and suited to task.
> 

XDocumentPropertiesSupplier replaced XDocumentInfo

Sub Main
obj = ThisComponent.getDocumentInfo()
End Sub

still works with AOO and old versions of LO 3(?) but not with recent LO.
It was marked as deprecated since OpenOffice.org 2.x


Sub Main
obj = ThisComponent.getDocumentProperties()
End Sub

works with all ODF suites since OOo 2.x. The template changer extension
uses the wrong document info interface.



-- 
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: Cannot assign template to existing writer odt file

[Andreas Säger]

Am 16.12.2015 um 10:09 schrieb Ken Heard:
> "Property or method not
> found: Document Info"


com.sun.star.document.XDocumentInfo was a deprecated interface in older
versions. For OpenOffice it is still documented here:
> http://www.openoffice.org/api/docs/common/ref/com/sun/star/document/XDocumentInfoSupplier.html#getDocumentInfo

but it is gone in LibreOffice.

It looks as if the developers removed a deprecated interface in favour
of a newer, better one without considering all dependencies. This should
not happen.

Are you sure about menu:File->Templates->AssignTemplate? I can't find
the command in my LO 4.6.x


-- 
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: Use KAddressBook As LibreOffice Resource

[Andreas Säger]

Am 16.12.2015 um 09:19 schrieb Ken Heard:
> On 2015-12-12 20:57, Don Parris wrote:
> 
> 
> The "address books:registering" entry in the LibreOffice Writer help
> (F1) explains how to import various address books into Writer.  I have
> so far set it up to use my icedove address book in Writer, but I have
> yet to use it for actual addressing.
> 
> Regards, Ken
> 
> 

We can connect a Base document with dozends of different database types,
spreadsheets, plain text (csv), dBase and some address books.

This topic is about the KDE address book in particular. LO has a
built-in driver (sdbc:address:kab) which does not work anymore because
the KDE folks added a new abstraction layer "Akonadi" between database
and client applications.

According to the German Wikipedia, Akonadi saves data in some Sqlite,
MySQL or PostgreSQL database.

> https://de.wikipedia.org/wiki/Akonadi


Either we find a way to connect to this database (for all 3 types
drivers are availlable) or someone writes a new sdbc driver for "Aconadi".


-- 
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: Use KAddressBook As LibreOffice Resource

[Andreas Säger]

Am 15.12.2015 um 17:23 schrieb Don Parris:
> On Mon, Dec 14, 2015 at 5:17 AM, Andreas Säger <ville...@t-online.de> wrote:
> I though my question - posed some time ago now - was quite clear.  

But possibly untechnical. Did you ask how you can connect to the
contacts and issue an SQL query such as
  SELECT * FROM CONTACTS
?


-- 
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: Use KAddressBook As LibreOffice Resource

[Andreas Säger]

Am 15.12.2015 um 17:23 schrieb Don Parris:
> 
> It really is completely mind-boggling that two prominent projects would
> somehow "miss" each other like this.
> 

Only a tiny fraction of LO users is aware of database connectivity. Most
users use Base through the mail merge wizard to connect a serial letter
with a spreadsheet. That wizard hides away the whole database thing.
Most software developers never use any office suite.


-- 
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: Where to request a new App (Mind mapping)for Libreoffice?

[Andreas Säger]

Am 14.12.2015 um 09:37 schrieb minhsien0330:
> Hi all:
> I think it will be very good if we have a mind mapping application in
> Libreoffice.
> 
> This would be a very good new feature!
> 
> We already have Writer, Calc, Impress, Draw, Math and Base, and how about
> add a new application for mind mapping named "Mindmap"?
> 
> Do you know where to send this request to the developers?
> Thanks~
> 
> Minhsien0330
> 


I think some million Dollar or Euro would do the trick. What's wrong
with the existing mind mappers? How is mind mapping related to the Open
Document Format (ODF)?


-- 
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: Use KAddressBook As LibreOffice Resource

[Andreas Säger]

Am 12.12.2015 um 14:57 schrieb Don Parris:
> I want to use KAddressBook as the resource for my LibreOffice mailmerge.
> Unfortunately, the only way this seems possible is by exporting the
> contacts from KAddressBook to a CSV file.
> 
> I have searched high and low, and cannot find any good way to use
> KAddressBook.  The KDE-PIM group seems to offer little help beyond
> exporting the data.

How did you formulate your question? Can you provide a hyperlink to your
help request? Did you ask for specific parameters to connect with the
underlying database?
Developers don't know anything about LibreOffice except that it has a
spreadsheet application so they recommend csv because this is what
everybody does when database data need to be used with non-database
applications.


-- 
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 Calc - Anomaly discovered in versions 4.2.8 and 4.4.6 - VLOOKUP function

[Andreas Säger]

Am 23.11.2015 um 18:10 schrieb Michele contabilmenteAG:
> Thanks, I solved the problem by entering the 4th argument to 0.
> 
> The solution, as I look for now is effective.
> 
> cordial greetings
> 
> Michele Ras
> 
> 2015-11-23 18:00 GMT+01:00 Andreas Säger <ville...@t-online.de>:
> 

You will get wrong matches or wrong #N/A errors if the "regular
expressions" option is ON and your search expressions contain certain
characters. With your own example
> CONTO TRANSITORIO PAGHE LL.DD.

will match any characters at the positions where the points are

You may get wrong positive matches when the "match whole cells" option
is OFF.
Search expression CONTO TRANSITORIO PAGHE will match at CONTO
TRANSITORIO PAGHE LL.DD.


-- 
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 Calc - Anomaly discovered in versions 4.2.8 and 4.4.6 - VLOOKUP function

[Andreas Säger]

Am 23.11.2015 um 16:33 schrieb Michele contabilmenteAG:
> Anomaly discovered in *versions 4.2.8 and 4.4.6* -
> VLOOKUP function
> 

menu:Tools>Options>Calc>Calculation
Regular expression = OFF
Match whole cell = ON

You leave out the 4th argument which means it defaults to 1. You want 0.
VLOOKUP(x;range;2;0)



-- 
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: CONGRATULATIONS!!1!

[Andreas Säger]

For "compatibility" with something that does not want to be "compatible" at
all, you may consider SoftMaker office for Linux. The current version is
inexpensive. Its predecessor is free as in "free beer". Of course, it can
not be API compatible to any other product.
I agree that LO is on a slippery road as far as quality managment is
concerned.



--
View this message in context: 
http://nabble.documentfoundation.org/CONGRATULATIONS-1-tp4166770p4166826.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

[libreoffice-users] Re: connecting bibliography to document problem

[Andreas Säger]

Am 04.11.2015 um 22:22 schrieb andrey.ry...@bilkent.edu.tr:
> 
>> I'm clueless.
>> Can you upload the Writer document somewhere?
>>
> What i should check in my document? ^)
> 
> 

Remove any confidential content and attach it to a mail to
ville...@t-online.de
I'll try to connect it to my biblio database and see what happens.


-- 
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: connecting bibliography to document problem

[Andreas Säger]

Am 04.11.2015 um 12:06 schrieb andrey.ry...@bilkent.edu.tr:
>> Hit F4, Right-click your database in the data source window and choose
>> "Edit
>> database".
>> Look at the status bar of the database window. What does it tell about the
>> type of database and the location of the database?
> 
> it  shows standard path. I am using Debian.
> /home/myname/.config/libreoffice/4/user/database/biblio
> it is written on left side of path in status bar: dBASE
> As i understand this is the type of database.
> 
> 

I'm clueless.
Can you upload the Writer document somewhere?


-- 
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: DRAGON in OOWrite problem

[Andreas Säger]

Am 03.11.2015 um 06:13 schrieb plexorite:
> Greetings all, from Oz!
> I have been very happily working with the very latest Windows 10 version of
> Dragon Professional Individual Version 14 . . .  180 for a couple of weeks
> in OpenOffice version 5. 022.

You installed LibreOffice 5 (the green one). The latest version of
OpenOffice is 4.1.2.

Search results on the OpenOffice user support forum with "Dragon" in title:
> https://forum.openoffice.org/en/forum/search.php?keywords=dragon=all==1=titleonly=posts=t=d=0=300=0=2f1a6315f322dddf7ae188f41adc2cc9=Search

Hope this helps.



-- 
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: connecting bibliography to document problem

[Andreas Säger]

Hit F4, Right-click your database in the data source window and choose "Edit
database".
Look at the status bar of the database window. What does it tell about the
type of database and the location of the database? 



--
View this message in context: 
http://nabble.documentfoundation.org/connecting-bibliography-to-document-problem-tp4165161p4165191.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

[libreoffice-users] Re: Inconveniences of time format

[Andreas Säger]

Am 31.10.2015 um 08:40 schrieb Gary Collins:
> Hi
> 
> 
> I've got a column in calc 4.3.2.2 to contain the length of video clips; it's 
> formatted to Time>876613:37:46. 
>   
> 
> The first inconvenience is that, when using autoincrement the times are 
> incremented not by 1 second but by 24 hours. 
>  
> 
> Whilst i understand that this is due to the way date/time is stored, with the 
> date as integer and the time as fraction, i think it is not exactly 
> intuitive. I feel that it might be much more convenient if LO would take the 
> formatting into account and increment by 1 second (or, to be more precise, by 
> 1 LSD  to the chosen format).
> 
> 
> Similarly, when entering such times i think it would be more helpful to give 
> precedence to the LSD, so entering 8, for example, would be interpreted as 8 
> seconds (rather than 8 hours as is cuŕrently the case) and 8:40 as 8m40s. 
> Again, this interpretation should be format dependent.
>  
> 
> What does anyone else think?
> 
> 
> Best
>  
>  
> /Gary
> 

Fill down =A1+1/86400 (with A1 being the start time)



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

[Andreas Säger]

V Stuart Foote wrote
> 
> +1 -- I don't understand why this is such a hard concept for folks to
> grasp ;-)

I found that a whole lot of people suffer from the misconception that their
document files contain computer instructions. When I select a portion of
text, click the bold button and save the document then the file contains a
clear and unambiguous computer instruction that this portion of text has to
be painted in bold font.



--
View this message in context: 
http://nabble.documentfoundation.org/Compatibility-tp4164384p4164907.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

[libreoffice-users] Announcing OpenOffice 4.1.2

[Andreas Säger]

> https://blogs.apache.org/OOo/entry/announcing_apache_openoffice_4_11
> http://www.openoffice.org/download/




-- 
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: Announcing OpenOffice 4.1.2

[Andreas Säger]

Am 29.10.2015 um 17:00 schrieb Bastián Díaz:
> 
> El 29-10-2015 11:10, Andreas Säger escribió:
> 
>>> https://blogs.apache.org/OOo/entry/announcing_apache_openoffice_4_11
>>> [1] http://www.openoffice.org/download/ [2]
> 
> What? This is a mailing list of LibreOffice user. If a user is
> interested in Ooo, that user has all the freedom to join the mailing
> list Ooo releases.
> 
> Thanks


> https://forum.openoffice.org/en/forum/viewtopic.php?f=101=75656
> http://nabble.documentfoundation.org/Fw-MariaDB-Announce-MariaDB-5-5-24-now-available-tp3988344.html




-- 
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: Announcing OpenOffice 4.1.2

[Andreas Säger]

Am 29.10.2015 um 17:50 schrieb Florian Reisinger:
> Hi,
> 
> On the contrary it is interesting to see if and when yes how often Open 
> Office will release. I thought of it as being dead as there has not been a 
> release in a relative long period of time.
> 
> So thanks for informing ;)
> 
> PS: @Bastián: You just started a probably long discussion ;)
> 

This was the first bug fix release since 13 months. On my laptop I have
both suites installed. I prefer AOO.



-- 
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: Announcing OpenOffice 4.1.2

[Andreas Säger]

Am 29.10.2015 um 18:05 schrieb Joel Madero:
> I tend to agree that this is a LibreOffice mailing list - it's one thing to
> say a new release is out for OOo but to link to their download page...I
> don't see this as being the proper venue for that.
> 
> Best,
> Joel
> 

Virtually none of your aleged users read mailing lists. From the AOO
support forum you get way more users because we never hesitate to
recommend LO when it comes to "compatibility" with the _real_ enemy or
when someone asks for a feature that is implemented in LO but not in
AOO. I couln't care less about the partisanship exposed on this fanboy
register.


-- 
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: Can't get LibreOffice 5.2.0 to Startup

[Andreas Säger]

Am 29.10.2015 um 10:06 schrieb James R McKenzie:
> When I try to launch LibreOffice a dialog button pops up and say "LibreOffice 
> 5.0 - Fatal Error The application cannot be started. User installation could 
> not be completed." I'm presented with an OK button on the Dialog Box. How can 
> I fix this? I don't have any further information as to the cause. Where do I 
> look in Kubuntu 14.04.3 64 Bit to find out anything for LibreOffice 5.0.2.0 
> to offer further information here?
> 
> Any ideas?
> 
> 
> 

Close the office and run this in a terminal:

> killall soffice
> cd .config/libreoffice/4/
> mv user userx
> /usr/bin/soffice




-- 
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: Sorting Calc Sheet in Alphabet orde on names in one Column

[Andreas Säger]

Am 25.10.2015 um 21:48 schrieb ajebay:
> I have a calc spreadsheet with many lines of data which include one
> column with names for the line.
> I want to sort the names from A to Z, top to bottom, and have all the
> corresponding data in each line move with the corresponding name.  Hope
> this is clear.
> Is this possible?
> 

You can click any single cell in the column you want to sort and click
one of the sort buttons [A-Z], [Z-A]. This will sort the area of
adjacent used cells.
Alternatively you can select the whole range and call the Data>Sort dialog.
And you can click a single cell and call the sort dialog which will
select the area of adjacent used cells as well.
Only one thing does not work: You must not select any part of a table
because this sorts the selected part. Spreadsheets do not have any
concept of tables. A table in a spreadsheet is what you treat as a table.


-- 
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: Outline Numbering Ignorance.

[Andreas Säger]

Am 20.10.2015 um 20:42 schrieb Steve Edmonds:
> How does Tools > Outline Numbering do more than assign a paragraph style
> to an outline level, do the settings in Tools > Outline Numbering over
> ride the styles or vis versa.
> 
> Any help to clear the fog much appreciated.
> Steve
> 

[Tutorial] Numbering chapters on Writer
> https://forum.openoffice.org/en/forum/viewtopic.php?f=71=278#p1103




-- 
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: Tooo many messages on this mailing list?? How to avoid being swamped ...

[Andreas Säger]

Am 16.10.2015 um 18:25 schrieb anne-ology:
>very interesting indeed  ;-(
> 
> 
> 
> From: Andreas Säger <ville...@t-online.de>
> Date: Thu, Oct 15, 2015 at 5:47 PM
> Subject: [libreoffice-users] Re: Tooo many messages on this mailing list??
> How to avoid being swamped ...
> To: users@global.libreoffice.org
> 
> 
> Am 15.10.2015 um 23:38 schrieb libreoffice-ml.mbou...@spamgourmet.com:
>>
>> Most emails appear correctly threaded to me, using SeaMonkey (based on
>> Thunderbird). Some messages break threading, because those sending them
>> use a mail client which doesn't include the relevant headers.
>>
>> Mark.
>>
>>
> 
> 
> 
> All replies by anne-ology start a new thread (gmane on Thunderbird).
> 

This topic looks like this in any mail client utilizing the In-Reply-To
header for threading. I think it would look the same if I would store
the mails in my inbox and watch it with some other mail client.

> http://www.mediafire.com/view/fym07dlm935a185/gmane.comp.documentfoundation.libreoffice.uer.tooo_many_messages.png

More than 10% of this mailing list is about the list itself. Apart from
this topic, notice the recent topic "Please do not send me a reply. My
question was solved already. I ask you sincerely." End users are not
interested in being mebers of a software fan club.

Contrary to the users of the 90ies, today's computer users do not
understand message boards nor mailing list just like they do not
understand office suites or anything that wants to be configured.


-- 
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: Too many messages on this mailing list?? How to avoid being swamped ...

[Andreas Säger]

Am 19.10.2015 um 13:13 schrieb James Knott:
> On 10/18/2015 11:15 PM, jorge wrote:
>>  As I remember there is an option for example in Evolution mail program
>> to let or not the original mail in the server. Is an option of the user.
>> This option we check when start a new account.
> 
> Other email apps, such as Thunderbird and Seamonkey, also allow you to
> leave email on a POP server for a specified period of time.
> 
> 

This is a server option. When you check this option in your mail client,
it will tell the POP server to keep delivered mails.


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

[Andreas Säger]

Am 19.10.2015 um 19:06 schrieb James Wilde:
> Using v.5.0.0.5 on OSX 10.9
> 
> I think this functionality, which everyone says is to be found, is not
> too well documented.
> 
> James
> 

Hands-on tutorial by example document about templates, styles, outlines,
indices etc.

> http://openoffice-uni.org/




-- 
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: Spam? Re: Microsoft outlook support number 1-844-815-2122

[Andreas Säger]

Am 19.10.2015 um 18:17 schrieb James E. Lang:
> 
> 

Of course it is spam. The bots notice that we discuss predominantly
about mail.


-- 
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: Tooo many messages on this mailing list?? How to avoid being swamped ...

[Andreas Säger]

The messenger is the culprit.



--
View this message in context: 
http://nabble.documentfoundation.org/Tooo-many-messages-on-this-mailing-list-How-to-avoid-being-swamped-tp4163215p4163658.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

[libreoffice-users] Re: How to.. sort a table in 3 columns

[Andreas Säger]

Am 18.10.2015 um 12:36 schrieb william drescher:

>> Operating system?
> 
> Windows 7
>> Office version?
>> Office component? Writer? Calc? Base?
> I'll use whatever I need
>> File format? doc, docx, odt, ods, xls, odb?
> odt or ods
>> I don't understand how you want to dump 2 fields into 3 columns?
> 
> Locationitem  locationitem  location  item
>1 widget 9 vebelfetzer   13nails, 10p
>1 screws, 8x1 10L. widget 24 nailsm 16p
> 
>> The term "pick list" is unclear. Listbox? Writer field of type "input
>> list"?
> 
> a pick list is a lit of items to be picked and packed for an order
>>
> bill
> 
> 
> 

1) Store your list data in some kind of simple database:
Having the 2-column list in a text file (*.csv or *.txt), open the file
with Calc.
Having the 2-column list in a spreadsheet, make sure that the A1 and B1
contain the words "Location" and "Item" as column labels and that all
locations are numbers (Ctrl+F8 highlights numbers in blue).
Save the spreadsheet in a separate directory as a dBase file:
menu:File>SaveAs...
Navigate to your preferred directory, add a new directory, visit the new
directory
menu:File Type:dBase(*.dbf)
This file format gives various advantages for every day use.
--
2) Connect your database to the office suite:
File>New>Database...
[x] Connect to existing database
Type: dBase
Point to the directory
[X] Yes, register the database
Save the database document (*.odb) in that directory or elsewhere.
---
3) Generate a dynamic report in columnar layout:
Click the tables container.
Right-click the table therein, call the report wizard and create a
tabular report with a 3-column layout and the right sort order.
--
What is this "database document"?
Your database table is a _link_ to your dBase file. The database
document (*.odb) does not store any data. It represents the contents of
the dBase files in the given directory as a collection of database
tables. Your data are in the dBase file or any additional dBase files
stored in that directory.
Since you registered this data source you have quick access to your list
without opening anything. Just hit F4 in Writer or Calc.
The report is a Writer document embedded in that database file. It is
filled with table data every time you open the report. You can store
snapshots of this report at any time simply saving the embedded Writer
document as a stand-alone document or as PDF.


-- 
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: Tooo many messages on this mailing list?? How to avoid being swamped ...

[Andreas Säger]

On 10/17/2015 10:39 AM, Andreas Säger wrote:

>>
> Mailing lists and aggregators are tools of the 90ies. Almost forgotten
> in the twitter age.

Not everyone like to use Twitter or Facebook.

Nor do I. But this mailing list is a very good example why mailing lists can
not be used for end user support efficiently.



--
View this message in context: 
http://nabble.documentfoundation.org/Tooo-many-messages-on-this-mailing-list-How-to-avoid-being-swamped-tp4163215p4163643.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

[libreoffice-users] Re: Tooo many messages on this mailing list?? How to avoid being swamped ...

[Andreas Säger]

Am 16.10.2015 um 18:45 schrieb anne-ology:
>curiously wondering what gmane is ...
>   curiously wondering what else I'll be a-learnin' today ...
>  curiously wondering what the newest computer gadget'll be ...
> curiously wondering ... curiously wondering ... curiously
> wondering  ;-)
> 
>very interesting indeed;
>   and remember'g how file folders expanded to hold letters by same
> case ...
>  ah, times ... they've been a-changin'  ;-)
> 
> 
> 

Mailing lists and aggregators are tools of the 90ies. Almost forgotten
in the twitter age.



-- 
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: How to.. sort a table in 3 columns

[Andreas Säger]

Am 16.10.2015 um 22:02 schrieb william drescher:
> I have a list that has two fields: aisle and item.  I need to maintain
> the list sorted by item, but print a pick list by aisle.  This would be
> simple except, when I print the list for marking I need to print it in
> item order, in 3 columns.  When I print the pick list I again need to
> print it in 3 columns, sorted by item,
> 
> Right now I am sorting the list by aisle and manually cutting and
> pasting it into 3 columns.  I currently have the data in a spreadsheet.
> 
> I tried using frames set for 3 columns, but when past the sorted list
> into the frames it does not spill over onto the 2nd and 3rd columns.
> 
> I would appreciate suggestions.
> 
> Thanks,
> 
> bill
> 
> 

Operating system?
Office version?
Office component? Writer? Calc? Base?
File format? doc, docx, odt, ods, xls, odb?
I don't understand how you want to dump 2 fields into 3 columns?
The term "pick list" is unclear. Listbox? Writer field of type "input list"?

Let's try to rephrase:
Using LibreOffice 5.0.2, I have a spreadsheet (*.ods) with a 2-column
list of item names and aisles numbers.
How can I include a properly sorted version of that list with a 3rd
column of ... in a Writer document?



-- 
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: Tooo many messages on this mailing list?? How to avoid being swamped ...

[Andreas Säger]

Am 16.10.2015 um 00:47 schrieb Andreas Säger:
> Am 15.10.2015 um 23:38 schrieb libreoffice-ml.mbou...@spamgourmet.com:
>>
>> Most emails appear correctly threaded to me, using SeaMonkey (based on
>> Thunderbird). Some messages break threading, because those sending them
>> use a mail client which doesn't include the relevant headers.
>>
>> Mark.
>>
>>
> 
> 
> All replies by anne-ology start a new thread (gmane on Thunderbird).
> 
> 
> 


He is the only one with no

> In-Reply-To: <parent...@host.com>

in the header.


-- 
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: Digital signatures

[Andreas Säger]

Am 15.10.2015 um 12:07 schrieb Евгений:
> Hello.
> 
> "Writer 4.2 Guide" from second link.
> 
> =


I prefer the AOO documentation
> https://wiki.openoffice.org/wiki/How_to_use_digital_Signatures





-- 
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: Tooo many messages on this mailing list?? How to avoid being swamped ...

[Andreas Säger]

Am 15.10.2015 um 23:38 schrieb libreoffice-ml.mbou...@spamgourmet.com:
> 
> Most emails appear correctly threaded to me, using SeaMonkey (based on
> Thunderbird). Some messages break threading, because those sending them
> use a mail client which doesn't include the relevant headers.
> 
> Mark.
> 
> 


All replies by anne-ology start a new thread (gmane on Thunderbird).



-- 
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: Tooo many messages on this mailing list?? How to avoid being swamped ...

[Andreas Säger]

Hiding away your mails helps a lot.


-- 
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: Installing Libreoffice in Ubuntu

[Andreas Säger]

Am 09.10.2015 um 04:47 schrieb John R. Sowden:
> I have been dealing with this issue for years, going back to the Open
> Office days.
> 

> How do you install Libreoffice under Ubuntu?
> 

After all those years, you never googled, you never asked anybody, you
never tried anything with or without success? You never continued an
online discussion clear up things that remained unclear or did not work?

> Where are the step by step, clearly documented instructions?
> 

Last Sunday two fairly detailed manuals have been written for you
exclusively but you prefer to not reply a single word.

> When are they not either on the download page in LO or a clear link on
> the download page?
> 

Installing Debian packages, downloaded from website or from ppa, is more
or less the same procedure regardless of the respective application.

Can we expect that you come up with the exact same questions under
another nickname next year?
Can we assume that you are a troll?



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