[libreoffice-users] Re: Calc Data Filter, Standard Filter, Value lost during restart?

2012-04-19 Thread Andreas Säger
Am 19.04.2012 23:37, lagagnon wrote: I have a calc database of 2000 lines or so. I use Data, Filter, Standard Filter to test whether one column has a certain value and whether the cells in another column are empty. Here is what the standard filter looks like: http://ompldr.org/vZGZ0dg This

[libreoffice-users] Re: Calc function

2012-04-18 Thread Andreas Säger
Am 17.04.2012 19:35, Mike Phelan wrote: I am trying to automatically remove a number from a range of cells, if it appears in a different range. I am creating a spreadsheet where once a number appears in B4:G11 4 times, it changes color to Red...got that part. Then I want to manually enter

[libreoffice-users] Re: beware of the m$ subsidiary

2012-04-18 Thread Andreas Säger
Am 17.04.2012 13:50, e-letter wrote: Readers, M$ is allegedly seeking to invest in interoperability and open source: http://www.infoworld.com/d/open-source-software/microsoft-forms-subsidiary-engage-open-source-communities-190790. Perhaps more for 'Groklaw', but isn't this a potential trojan

[libreoffice-users] Re: Calc function

2012-04-18 Thread Andreas Säger
Am 18.04.2012 17:56, Johnny Rosenberg wrote: Den 18 april 2012 09:47 skrev Andreas Sägerville...@t-online.de: Am 17.04.2012 19:35, Mike Phelan wrote: I am trying to automatically remove a number from a range of cells, if it appears in a different range. I am creating a spreadsheet where once

[libreoffice-users] Re: Problems importing an OO database into LO

2012-04-17 Thread Andreas Säger
Am 17.04.2012 10:52, ptoye wrote: Access allows update queries, which are sadly missing from LO/OO. Why can't you run SQL update queries? This is trivial to do in SQL. The SQL is trivial to execute by macro. If you desparately want a graphical query designer for update/insert/delete

[libreoffice-users] Re: Problems importing an OO database into LO

2012-04-17 Thread Andreas Säger
Am 17.04.2012 11:34, ptoye wrote: Andreas Säger wrote Why can't you run SQL update queries? This is trivial to do in SQL. The SQL is trivial to execute by macro. If you desparately want a graphical query designer for update/insert/delete queries, then you should write one and store your

[libreoffice-users] Re: Problems importing an OO database into LO

2012-04-17 Thread Andreas Säger
Am 17.04.2012 11:28, Ian Whitfield wrote: On 04/15/2012 08:58 AM, David wrote: ... What database doe you think works better than OpenOffice or LibreOffice? I don't have any views on this matter. After using OO/LO Base for over 5 years now I gave up last month after the latest crash. It

[libreoffice-users] Re: Problems importing an OO database into LO

2012-04-17 Thread Andreas Säger
Am 17.04.2012 16:03, Pertti Rönnberg wrote: To the LibO-folks and developers I repeat: Stop developing LibO-Base;go back to the latest stable version and start to complete it and repair all discrepancies in the program and between the program and it’s documentation! There is so much good done

[libreoffice-users] Re: Problems importing an OO database into LO

2012-04-17 Thread Andreas Säger
Am 17.04.2012 17:38, Tom Davies wrote: Hi :) Would it be easy to upgrade the HSqlDb embedded in Base or would all the tweaks need to be applied? Are the tweaks vital or could they left out? Regards from Tom :) The easiest improvements in my honest opinion: - Wipe out the .odb container all

[libreoffice-users] Re: select en-dash and em-dash characters

2012-04-17 Thread Andreas Säger
Am 16.04.2012 22:36, Séamas Ó Brógáin wrote: Regina wrote: They are usually written via AutoCorrect. The simple hyphen is replaced with the en-dash or em-dash when the following word is finished . . . That is _not_ a good idea. The hyphen, en rule and em rule (dash) are distinct characters

[libreoffice-users] Re: Problems importing an OO database into LO

2012-04-17 Thread Andreas Säger
Am 17.04.2012 19:23, Tom Davies wrote: Hi :) It looks like most of this can be done without touching Base itself? Is LO able to use databases in this way already? Is it something that could be passed to the devs list an/or the BoD discussion list? Something like this could be phrased to

[libreoffice-users] Re: Problems importing an OO database into LO

2012-04-16 Thread Andreas Säger
Am 16.04.2012 14:49, Mark Stanton wrote: - multiple table query/update support Multi-table update support is an SQL limitation, isn't it? At least it requires that a foreign key is linked to another table's unique (primary) key, otherwise it is uncertain which one of the related rows you

[libreoffice-users] Re: Problems importing an OO database into LO

2012-04-16 Thread Andreas Säger
Am 15.04.2012 17:48, ptoye wrote: Well, I seem to have started off quite a discussion. It's interesting that Andreas seems to agree with me that OO isn't really for programming. And the use of ODF is extremely important for intercommunicability, a point which isn't taken by many MS addicts.

[libreoffice-users] Re: Base 3.5.2.2 hangs

2012-04-15 Thread Andreas Säger
Am 15.04.2012 09:49, clehmann wrote: Your statement So - if your problem happens when opening an ODB file for the first time in a session it would be different. is interesting since it seems that I never manage to be able to open a local .odb database the first time. It is only after having

[libreoffice-users] Re: Problems importing an OO database into LO

2012-04-15 Thread Andreas Säger
ptoye wrote Glad to hear it. But IMHO Base is just nowhere compared to Access (which itself isn't much to shout about). And OO Basic compared to VBA similarly. As an ex-programmer I'm always keen to automate any process, but the OO Basic learning curve turns many people off (as far as I

[libreoffice-users] Re: How to format data entry in base table to UPPERCASE only

2012-04-14 Thread Andreas Säger
Am 14.04.2012 07:57, Mark Stanton wrote: Which is also to say that the input filters you're expecting don't exist in Base. Regards Mark Stanton One small step for mankind... In this case a form related macro solution might be simple, I guess. -- For unsubscribe instructions e-mail to:

[libreoffice-users] Re: [Announce] HyperSQL 2.2.8 Released

2012-04-14 Thread Andreas Säger
Am 14.04.2012 04:22, avamk wrote: Thank you for all of your replies, the information is very helpful, and I will continue to explore. Just one more question: Would migrating to other databases (like MySQL or PostgreSQL) be similar to how I would migrate from an *.odb file to a HSQL database? If

[libreoffice-users] Re: [Announce] HyperSQL 2.2.8 Released

2012-04-14 Thread Andreas Säger
Am 14.04.2012 13:04, drew jensen wrote: Hi Andreas, Sorry, I can't agree with your advice to avamk on this one. Sure you can edit tables on 'your' database, as long as he is the one doing the work the fact that it is a server based system is meaningless in this regard As for Base features,

[libreoffice-users] Re: How to format data entry in base table to UPPERCASE only

2012-04-14 Thread Andreas Säger
Am 14.04.2012 16:38, Mark Stanton wrote: Having said all of that, it doesn't exist in Base (yet :-) ). Sure, it does exist. It's called pattern field: http://user.services.openoffice.org/en/forum/viewtopic.php?f=61t=10132p=47451hilit=input+mask+literal#p47451 A macro solution could

[libreoffice-users] Re: How to download?

2012-04-13 Thread Andreas Säger
Am 13.04.2012 03:14, Darren Govoni wrote: Hi, I've been trying to download the latest LibreOffice. No luck. It gets about 5%. Its slow then gets interrupted and stops. The torrent does not work. It stays at 0%. Never seen this from a download site before. Is there a mirror list? I tested my

[libreoffice-users] Re: Connecting to HSQLDB with Base

2012-04-13 Thread Andreas Säger
Am 13.04.2012 15:50, Dan Lewis wrote: On Fri, 2012-04-13 at 09:38 -0400, Dan Lewis wrote: I have hsqldb installed and running. But I don't find the information that I need to connect Base to it. I have read I can use either ODBC or JDBC to do this. JDBC requires: Data source URL jdbc:: and

[libreoffice-users] Re: How to format data entry in base table to UPPERCASE only

2012-04-13 Thread Andreas Säger
Am 13.04.2012 17:42, leon244 wrote: I am trying to find a way to format the text fields in my small data base to be uppercase only. Is there a way to do it at the table field level with the 'format', or can it only be done at the form level through a pattern field using 'X'? -- View this

[libreoffice-users] Re: Can one export from Calc a spreadsheet raw into a MySql database table raw?

2012-04-13 Thread Andreas Säger
Am 13.04.2012 22:06, Csanyi Pal wrote: Hi, I made in Calc a spreadsheet and now I want to export some raws into a mysql database table's raws. I have created already the database using command mysql to log into mysql server and have already the table in database with corresponding fields in

[libreoffice-users] Re: Calc: cell protection + cut paste

2012-04-13 Thread Andreas Säger
Am 13.04.2012 22:36, miakoiv wrote: Yes, absolute references don't solve it. And I really do agree that there should be a way to control how these editing operations affect protected cells. One of the core fuctions of a speadsheet program (in my opinion) in that somebody skills can make a

[libreoffice-users] Re: How to download?

2012-04-13 Thread Andreas Säger
, 2012-04-13 at 14:45 +0200, Andreas Säger wrote: Am 13.04.2012 03:14, Darren Govoni wrote: Hi, I've been trying to download the latest LibreOffice. No luck. It gets about 5%. Its slow then gets interrupted and stops. The torrent does not work. It stays at 0%. Never seen this from a download site

[libreoffice-users] Re: [Announce] HyperSQL 2.2.8 Released

2012-04-12 Thread Andreas Säger
Am 12.04.2012 01:17, avamk wrote: Hello, As a new user, the new HSQL looks very interesting, but I am still a little confused: Does this mean if I setup HSQL 2.2.8 per your instructions in the original post, I will have a database service/server running on my machine that LibreOffice acts as

[libreoffice-users] Re: Problems importing an OO database into LO

2012-04-12 Thread Andreas Säger
Try if a manual refresh helps. Use the button in the middle of the navigation toolbar. Work-around: Use the ID numbers together with a list box. So the actual field value is the ID masked by the list box text. In addition you can have an editable record set. -- View this message in context:

[libreoffice-users] Re: [BASE] New to Base - Program stops RESOLVED

2012-04-12 Thread Andreas Säger
Am 12.04.2012 15:34, Betti Ann and Preston Smith wrote: Thanks again for your help. My brute force approach does not show much finesse but it worked for me. In the process I learned much from your input. Preston Unfortunately, your old profile is lost now and no developer has any chance to

[libreoffice-users] Re: [Base} Compare contents of similar records on two sheets

2012-04-12 Thread Andreas Säger
Am 12.04.2012 15:23, Preston Smith wrote: Hello, I have asked this question previously in the context of two spreadsheets. I know now that I can migrate my spreadsheets to BASE and with minimal fuss make it work for me. I have two sets of records. My Master database and a monthly update that

[libreoffice-users] Re: How to edit words and phrases in a pdf

2012-04-12 Thread Andreas Säger
Am 12.04.2012 14:43, Tom Davies wrote: Hi :) Normally when i open a pdf document in LibreOffice each line of text seems to be contained in it's own text-box which i can then move around or perhaps delete but i can't seem to edit the words inside the line, eg to correct typos. Is it possible

[libreoffice-users] [Announce] HyperSQL 2.2.8 Released

2012-04-11 Thread Andreas Säger
. Encrypted connections are supported. - And you can connect LibreOffice to the local copy of HyperSQL directly (cached mode analog to the embedded database). For a better Base experience! Cheers, Andreas Säger -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems

[libreoffice-users] Re: [BASE] New to Base - Program stops

2012-04-11 Thread Andreas Säger
Downgrading would be silly. 3.4 had some nasty bugs. Version 3.5 is as usable as it used to be in LibreOffice 3.3 and OpenOffice 3.3. Most strange problems and crashes are cured by resetting the user profile. http://user.services.openoffice.org/en/forum/viewtopic.php?f=74t=12426 -- For

[libreoffice-users] Re: Calc: cell protection + cut paste

2012-04-11 Thread Andreas Säger
Am 11.04.2012 22:58, Cor Nouws wrote: Pls explain more in detail what the situation is you talk about. An example of the cells involved maybe? Thanks, Cell protection can be overridden by pasting/dragging arbitrary other spreadsheet cells over the protected ones. The underlying problem is

[libreoffice-users] Re: Calc: cell protection + cut paste

2012-04-11 Thread Andreas Säger
Am 11.04.2012 23:59, Andreas Säger wrote: Am 11.04.2012 22:58, Cor Nouws wrote: Pls explain more in detail what the situation is you talk about. An example of the cells involved maybe? Thanks, Cell protection can be overridden by pasting/dragging arbitrary other spreadsheet cells over

[libreoffice-users] PLEASE ban this spammer!

2012-04-09 Thread Andreas Säger
Am 09.04.2012 13:09, Tom Davies wrote: Hi :) Base users that are currently using MySql/MariaDb might be interested in the events that are after the announcement of the new release of MariaDb. It would be great if someone on the Postgresql mailing lists could let us know of significant

[libreoffice-users] Re: links as filed on a Database (BASE)

2012-04-05 Thread Andreas Säger
Am 05.04.2012 11:52, Haruka Akiko wrote: The links may point both to phisical places in my hardisk and to places in the web (say web sites or documents stored in a web space). It'd seem simple, but I have just little knowledge of Base and I'm wondering if, in a report of data extracted from this

[libreoffice-users] Re: Convert multi-sheet ods to csv files

2012-04-05 Thread Andreas Säger
Am 05.04.2012 23:43, NoOp wrote: Why not just install Python6? You can have multiple versions installed (I have both 5 6). The Python runtime with the UNO module needs to be compiled with the exact same compiler as the office suite. http://www.openoffice.org/udk/python/python-bridge.html

[libreoffice-users] Re: libre office and microsoft office access

2012-04-04 Thread Andreas Säger
The required database drivers come from Microsoft. Microsoft will never pubilish these drivers for Linux. Let Access export your data to dBase, connect one Base document to the dBase tables, another Base document to your preferred database (MySQL for instance) and copy over the dBase tables to

[libreoffice-users] Re: Convert multi-sheet ods to csv files

2012-04-02 Thread Andreas Säger
Am 01.04.2012 23:26, Pedro wrote: Andreas Säger wrote Python is platform independent. I don't see any reason why that particular script would not run with the Python runtime shipped with your LibreOffice. Yes, I know how to run python scripts ;) But I get Traceback (most recent call last

[libreoffice-users] Re: Convert multi-sheet ods to csv files

2012-04-02 Thread Andreas Säger
I could run the script on a Windows box calling the full pathname of Python.exe script.py input.ods It complained about something else but it found all the modules to import. -- View this message in context:

[libreoffice-users] Re: Fw: [libreoffice-marketing] Open standards and UK gov use of odf

2012-04-01 Thread Andreas Säger
Am 31.03.2012 20:19, Tom Davies wrote: Hi Andreas :) This seems to be a somewhat inconsistent message from you. I thought you wanted people to be allowed to use ODF formats? Regards from Tom :) Meanwhile I find amusing how you do not read other people's statements. However, it is a major

[libreoffice-users] Re: Convert multi-sheet ods to csv files

2012-04-01 Thread Andreas Säger
Am 01.04.2012 20:16, Pedro wrote: Hi Andreas Any chance there is a similar python script that works under Windows? Python is platform independent. I don't see any reason why that particular script would not run with the Python runtime shipped with your LibreOffice.

[libreoffice-users] Re: Convert multi-sheet ods to csv files

2012-03-31 Thread Andreas Säger
Am 30.03.2012 23:36, Vytas Janusauskas wrote: Hi, I have 50 or so spreadsheets comprising of 6 sheets of information. I need to export this data to csv format. I thought I had found the solution by using the unoconv program (unoconv -f csv FileName.ods . Unfortunately it will only export the

[libreoffice-users] Re: Fw: [libreoffice-marketing] Open standards and UK gov use of odf

2012-03-31 Thread Andreas Säger
Am 30.03.2012 12:28, Tom Davies wrote: --- On Fri, 30/3/12, Ian Lynchianrly...@gmail.com wrote: It seems Microsoft is lobbying the UK Cabinet office for OOXML in place of odf http://www.computerweekly.com/blogs/public-sector/2012/03/microsoft-redeploys-ooxml-in-o.html Anyone that has a

[libreoffice-users] Re: Bibliography crash

2012-03-28 Thread Andreas Säger
Am 27.03.2012 23:46, sanches wrote: Thanks a lot for reply and tip, Tom! I had found the answer. Java plugin for LibreOffice had not been installed by default in the Ubuntu 12.04 distribution (why, actually?). Oh, my carelessness :) -- View this message in context:

[libreoffice-users] Re: Missing XHTML Writer File export filter on LibreOffice 3.5.0.2 for MS Windows?

2012-03-27 Thread Andreas Säger
Am 27.03.2012 12:52, Tomas Hlavaty wrote: I was under the impression that Java was not required anymore for this, but probably it is as you say. XHTML export does not work for me when I disable Java. However, I set Java Options to use java 1.6.0.20 (from sun) but it still doesn't work both

[libreoffice-users] Re: LibreOffice-created Word document won't open normally in Windows Vista

2012-03-27 Thread Andreas Säger
Am 27.03.2012 15:00, kd5 wrote: LibreOffice works great with Windows XP. If I create a document using LibreOffice, 'Save As' Word 2007/2010 .docx, then go to My Documents and double-click on the saved document, LibreOffice Writer will open the document perfectly. Please, please, please! Never

[libreoffice-users] Re: mail merge duplicates entries

2012-03-26 Thread Andreas Säger
Am 26.03.2012 14:14, Ron Gregor wrote: Andreas, Thanks for the suggestion. Can you tell me how to use a query when printing with a mail merge? I didn't see any place to enter a query. Ron Hit F4, right-click the data source - Open Database... Add your query to the database, save

[libreoffice-users] Re: [Libreoffice-users] Missing XHTML Writer File export filter on LibreOffice 3.5.0.2 for MS Windows?

2012-03-26 Thread Andreas Säger
Am 26.03.2012 20:04, Tomas Hlavaty wrote: Do I need to do something extra to get the XHTML filter to appear and work on Windows? You need a 32-bit version of Java 1.6.x. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Re: Data, Filter, Standard Filter won't filter blank cells

2012-03-25 Thread Andreas Säger
Am 25.03.2012 19:15, lagagnon wrote: I have a calc database of about 2000 records. I use Data, Filter, Standard Filter from the main database sheet to select only those records which are -empty- in one specific field, and I filter those records into a second calc sheet. Since version 3.5 the

[libreoffice-users] Re: mail merge duplicates entries

2012-03-23 Thread Andreas Säger
Am 23.03.2012 18:24, Ron Gregor wrote: Does anyone know how to fix this or is this another bug that needs to be filed. It is another bug that needs to be filed AND a simple query can fix it: SELECT DISTINCT * FROM Your Table -- For unsubscribe instructions e-mail to:

[libreoffice-users] Re: formatting emails

2012-03-23 Thread Andreas Säger
Am 23.03.2012 20:59, Doug wrote: Interesting problem: An email text is received which you need to format for publication. The email uses a carriage return at the end of each line, and a double carriage return for paragraph spacing. What I'd like to do is remove the cr's at the end of each line,

[libreoffice-users] Re: Install RPM as non-superuser

2012-03-22 Thread Andreas Säger
Am 22.03.2012 18:08, Reinhard wrote: -- View this message in context: http://nabble.documentfoundation.org/Install-RPM-as-non-superuser-tp3848942p3848942.html Sent from the Users mailing list archive at Nabble.com. Simply extract the installation files to some place and call

[libreoffice-users] Re: saving as docx crashes libreoffice 3.5.1 on windows 7

2012-03-22 Thread Andreas Säger
Am 20.03.2012 23:05, Shari wrote: You can try saving it as a 2003 xml and office 2007/2010 should be able to open that. I know in a previous version of Libre this worked for me. Shari 2003 xml is even worse. The one and only file format with 95% compatibility is .doc/.xls/.ppt. -- For

[libreoffice-users] Re: saving as docx crashes libreoffice 3.5.1 on windows 7

2012-03-22 Thread Andreas Säger
Am 21.03.2012 01:09, Jon Rubin wrote: bangs head against wall. I'm in academia, they aren't going to buy me a copy of MS to use at home. I don't want to buy one. Who benefits? Bangs head again. *I* benefit, if LO can open and save docx with no probllems so that it is transparent. I normally

[libreoffice-users] Re: saving as docx crashes libreoffice 3.5.1 on windows 7

2012-03-22 Thread Andreas Säger
Am 20.03.2012 22:58, Shari wrote: This person is only asking to do what the website says it can. Either it can or it can't. Shari Obviously it can't and e-letter makes a point. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Re: Date Difference formula required in Calc 3.5

2012-03-22 Thread Andreas Säger
Am 22.03.2012 19:41, Essex Lad wrote: I realise that I can get a date difference of days or years in Calc, but what is needed is a way of getting a result in Years/Months/Days - any thoughts would be very welcome Dave H. http://user.services.openoffice.org/en/forum/download/file.php?id=7015

[libreoffice-users] Re: Date Difference formula required in Calc 3.5

2012-03-22 Thread Andreas Säger
Am 22.03.2012 20:01, Essex Lad wrote: Thank you very much - that has solved my query I know that other people a re asking the same question - can I send then your file? That's why it is on the internet. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Re: saving as docx crashes libreoffice 3.5.1 on windows 7

2012-03-22 Thread Andreas Säger
Am 20.03.2012 13:52, darwinev0lved wrote: Advice, thoughts? Jon There is no technical reason why a user of LibreOffice should save a file in OOXML as long as Microsoft Office provides full support for doc/xls/ppt. Office Open XML (OOXML) is simply a no go area. This pestilence of a file

[libreoffice-users] Re: [Calc} Compare contents of similar records on two sheets

2012-03-21 Thread Andreas Säger
Fields and records describe a database. A spreadsheet is a very poor surrogate for a database. You need to know *everything* about spreadsheet lookups in unordered database mode: http://user.services.openoffice.org/en/forum/viewtopic.php?f=75t=46746 -- For unsubscribe instructions e-mail

[libreoffice-users] Re: Automate a Data Filter in Calc ?

2012-03-21 Thread Andreas Säger
Am 22.03.2012 00:32, lagagnon wrote: I have a 2500 line database in LO Calc with 10 fields per record (line). In a second sheet I want only specific records from the first sheet (the database) which match 3 criteria. I haven't quite figured out how to do that manually with Data, Filter, Standard

[libreoffice-users] Re: Urgent Base problem

2012-03-18 Thread Andreas Säger
Am 18.03.2012 08:56, Mark Stanton wrote: I think the point Mark was making was to switch away from using the embedded back-end to pretty much any external one. Which is what you often suggest too. Yes indeed. Can HSQLDB be used as an external engine? I thought not, which is why I didn't

[libreoffice-users] Re: Urgent Base problem

2012-03-18 Thread Andreas Säger
Some additions for anybody who wants to follow my receipt: Am 18.03.2012 10:25, Andreas Säger wrote: Extract ./database/ from your embedded database somewhere to your files. Rename your database files with a common dbname. prefix. The dbname in the below URL is chargen so I renamed the files

[libreoffice-users] Re: BASE and HSQLDB 2

2012-03-18 Thread Andreas Säger
Am 18.03.2012 01:35, RustyRiley wrote: thanks, after reading the commentr about the bastard thought I'd go ahead aand install HSQLDB, especially after reading it was small, fast and siuitable for thr home user, but even this tutorial is too advanced for me -- like how do I install it? not

[libreoffice-users] Re: AutoFilter Change

2012-03-18 Thread Andreas Säger
Tom wrote Hi :) I don't think LO's Calc is aiming to look exactly like Excel but it does aim to remain fairly similar so that people find it easy to migrate to LO.  I think it's a lot more configurable than Excel especially with the Add-ons/Extensions.  Regards from Tom :) You may

[libreoffice-users] Re: Indexing a text by concordance file failes

2012-03-18 Thread Andreas Säger
[Solved] Using Concordance for Indexing http://user.services.openoffice.org/en/forum/viewtopic.php?f=7t=47581hilit=concordance -- View this message in context: http://nabble.documentfoundation.org/Indexing-a-text-by-concordance-file-failes-tp3833634p3837173.html Sent from the Users mailing list

[libreoffice-users] Re: Urgent Base problem

2012-03-17 Thread Andreas Säger
Am 17.03.2012 11:41, Ian Whitfield wrote: What filter must I selct or what must I do to get my Database going again?? You need to restore your database from a backup. It is lost. This would not have happened with a true database connection. The database wrapped in a single document

[libreoffice-users] Re: More mailmerge woes

2012-03-17 Thread Andreas Säger
Am 17.03.2012 11:15, Mark Stanton wrote: The File / Print menu will ask if you want to print a mail merge. Just say yes then enjoy the olde OOo v1 wizard. So it does! That's cute. Unfortunately it only lists tables as data sources, and mine is a query :-( Mark Stanton One small step for

[libreoffice-users] Re: Urgent Base problem

2012-03-17 Thread Andreas Säger
://user.services.openoffice.org/en/forum/viewtopic.php?f=61t=46324 I'm sure this helps, Andreas Säger -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

[libreoffice-users] Re: handling of quotes before text in Calc 3.4 and 3.5 changed compared to 3.3

2012-03-17 Thread Andreas Säger
Tinkerer wrote Hi Cor The way it is now is ideal for what I do, but needs vary. Your question implies that I might need something extra, I cannot think what though. So. If it ain't broke, don't fix it. Best, Tink. It used to work as usual. It has been broken in 3.5. It needs

[libreoffice-users] Re: BASE and HSQLDB 2

2012-03-17 Thread Andreas Säger
Am 17.03.2012 20:30, RustyRiley wrote: presuming that's worked out OK, what should I read next -- haven't used this type of technology, and haven't created anything but embedded databases before (unaware this was not the best /option). [Tutorial] Avoiding data loss with built in HSQLDB

[libreoffice-users] Re: Urgent Base problem

2012-03-17 Thread Andreas Säger
Am 17.03.2012 21:20, Mark Stanton wrote: I would suggest replacing the bastard (are we really talking like this? :-) ) with MySQL or perhaps even better MariaDb (mebbe even Postgres). Replacing one excellent databse engine with another excellent (much bigger) database engine will not solve

[libreoffice-users] Re: handling of quotes before text in Calc 3.4 and 3.5 changed compared to 3.3

2012-03-16 Thread Andreas Säger
Am 16.03.2012 10:30, Cor Nouws wrote: Hi all, Anyone an idea? Cor Nouws wrote (08-03-12 18:33) This is a petty because the leading apostrophe could be used to supress auto-correction and auto-completion of text values just like it supresses evaluation of numeric and formula expressions.

[libreoffice-users] Re: AutoFilter Change

2012-03-16 Thread Andreas Säger
Am 16.03.2012 17:23, Shari wrote: I guess I'm just not sure what it adds to change this simple filter. It worked and did what it was intended to do. Yes, if there isn't going to be an additional filter type, then then at least what your suggesting would make it usable. I guess I'm from the

[libreoffice-users] Re: handling of quotes before text in Calc 3.4 and 3.5 changed compared to 3.3

2012-03-16 Thread Andreas Säger
Am 16.03.2012 16:31, Tinkerer wrote: Cor Showing the apostrophe in front of a number is a great help. If I total a column it immediately tells me which numbers are included in the total and, more important, which numbers are not. Real text does not need the apostrophe. Tink. And it still

[libreoffice-users] Re: Address Books

2012-03-16 Thread Andreas Säger
Am 16.03.2012 15:40, Nino Novak wrote: On Friday 16 March 2012, 15:00:41 Andreas Säger wrote: Am 16.03.2012 11:09, Nino Novak wrote: It could be used as reference on how to use Base. Well, this would be like a reference on how to use a programming language. Either you can actually use

[libreoffice-users] Re: Calc changes cells with . to 0

2012-03-15 Thread Andreas Säger
Am 15.03.2012 03:41, Andrew Koeser wrote: New question. When I selected the quoted field as text box in the import prompt, I never had to do this again. The setting was changed for future uses. However, when saving, the quote all text cells box is always unchecked. Is there anyway way I could

[libreoffice-users] Re: Generic formulas or inverse scenarii

2012-03-15 Thread Andreas Säger
May be a use case for multiple operations? [Solved] Automatically generate data from a set of values: http://user.services.openoffice.org/en/forum/viewtopic.php?f=9t=48274 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Re: Generic formulas or inverse scenarii

2012-03-15 Thread Andreas Säger
Scenarios have a property Copy Back. If this option is unset, you can still edit the scenario but when you switch to another one this one will be preserved. So this type of Don't Copy Back scenario works like a template. You can edit the template, then create a new one from the edited range and

[libreoffice-users] Re: Address Books

2012-03-15 Thread Andreas Säger
Am 14.03.2012 21:22, Stephanie Dutcher wrote: I work for a non-profit youth organization, and we are trying to figure out a way to organize all of our members' information without a big cost to us. Would I be able to create something like an address book using a template in the LibreOffice

[libreoffice-users] Re: Calc changes cells with . to 0

2012-03-14 Thread Andreas Säger
Am 14.03.2012 23:40, Andrew Koeser wrote: Hey everyone, I notice that Calc will sometimes change the value of a cell from a period to a zero. I notice it mostly when I save from .ods to csv. This is an issue, as one of the stats software programs I use denotes missing data with a . Is there an

[libreoffice-users] Re: malfunction opening docx document

2012-03-13 Thread Andreas Säger
Am 12.03.2012 22:39, Maurizio Sapienza wrote: the attached document when opened by Writer 3.4 is totally blank. Using the previous 3.3 release, it appeared missing of some formulas (that drove me to install the new relelase). The pdf file is how it appear using

[libreoffice-users] Re: Base and new Report Builder in 3.5

2012-03-13 Thread Andreas Säger
Am 13.03.2012 12:11, Fernand Vanrie wrote: It would be handy to see some examples of how you make reports with calc. We have questions on how to Make headers , footers and grouping somes results ? Greetz Fernand Page headers and footers can not have database content unless you write a

[libreoffice-users] Re: Base and new Report Builder in 3.5

2012-03-12 Thread Andreas Säger
Am 11.03.2012 19:48, tops wrote: Hi all, I have been using OO and LibreOffice prior to 3.5 with Base and Reports. Now the Reports in 3.5 can not be used any further, instead I had to try (despair) and create new Reports using the Oracle Reports Tool. IMHO this is a major leap backwards… It

[libreoffice-users] Re: OOoBean

2012-03-12 Thread Andreas Säger
Am 12.03.2012 19:16, Robson Peixoto wrote: Hi, I'd like to embed the Write in a java application, but on Mac OS X doesn't has the libofficebean and OOoBean. Is possible embed the Writer without it ? How? Hi, http://www.oooforum.org/forum/viewtopic.phtml?t=9883 This is a macro which

[libreoffice-users] Re: Enable JRE Alert when starting Writer document

2012-03-11 Thread Andreas Säger
Am 11.03.2012 22:44, bernie12 wrote: Any ideas here? Thanks! This office suite runs perfectly well without any Java. Disable the use of Java in ToolsOptionsJava. The following features will not work: FileWizardsLetter,Fax,Agenda,Web page FileExportXHTML Connections to Java databases. A new

[libreoffice-users] Re: CELL() doesn't show the cell content of another CALC file

2012-03-10 Thread Andreas Säger
The CELL function is there for some historic reasons. Very old documents from other applications may use it. Except for the filename option there is no use for it in Calc. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Re: CELL() doesn't show the cell content of another CALC file

2012-03-10 Thread Andreas Säger
Am 10.03.2012 19:59, csanyipal wrote: Andreas Säger wrote The CELL function is there for some historic reasons. Very old documents from other applications may use it. Except for the filename option there is no use for it in Calc. So which function can be used instead of CELL function

[libreoffice-users] Re: This is how I got LibreO installed and working

2012-03-09 Thread Andreas Säger
Am 09.03.2012 13:40, Pertti Rönnberg wrote: 4 the Java/JRE is said to be a must for both OO and LO; This is a rumor. Both suites run fine without any Java. You can check it out when you disable the use of Java components in the Office options. It is rather unlikely that the avarage user

[libreoffice-users] Re: Calc macro to open tab delimited data file?

2012-03-08 Thread Andreas Säger
Am 08.03.2012 06:54, Andrew Douglas Pitonyak wrote: I believe that a sample solution can be found in AndrewBase.odt, search for the macro listing Prompt for a CSV file, and then display the data. Right, your AndrewBase.odt demonstrates how to load plain text database data into the database

[libreoffice-users] Re: Calc macro to open tab delimited data file?

2012-03-07 Thread Andreas Säger
Am 07.03.2012 00:35, fork wrote: I can provide any more info if anyone would like. A couple of lines of actual data copied from a text editor tell more than thousand words. P.S. -- I don't really want to get good at macro writing, so I am hoping for the very quickest quick hack, rather

[libreoffice-users] Re: Calc macro to open tab delimited data file?

2012-03-07 Thread Andreas Säger
All that Inelligent Technology is about data processing. Input Processing - Output. Without knowing anything about the input there is no way to write any program to process data. Programmers are lazy because they know how to write routines to solve the same problem once for all times. You are

[libreoffice-users] Re: Calc macro to open tab delimited data file?

2012-03-07 Thread Andreas Säger
May be you did not notice that LibreOffice remembers the import settings for text files. If you need to open the same type of file repeatedly, you can specify the import options once and next time you simply confirm the dialog. -- For unsubscribe instructions e-mail to:

[libreoffice-users] Re: Calc macro to open tab delimited data file?

2012-03-07 Thread Andreas Säger
Am 07.03.2012 19:24, fork wrote: Andreas Sägervilleroyat t-online.de writes: May be you did not notice that LibreOffice remembers the import settings for text files. If you need to open the same type of file repeatedly, you can specify the import options once and next time you simply

[libreoffice-users] Re: Calc macro to open tab delimited data file?

2012-03-07 Thread Andreas Säger
Again, it is technically and logically impossible to write a program without knowing anything about the input. If you can not copy a few lines of text from a text editor, then I will have to explain too many details anyway. End of discussion. Bye. -- For unsubscribe instructions e-mail

[libreoffice-users] Re: Table Format

2012-03-06 Thread Andreas Säger
Screenshot http://www.mediafire.com/i/?r49k545au99e2wb -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List

[libreoffice-users] Re: Table Format

2012-03-06 Thread Andreas Säger
Am 06.03.2012 16:00, Sylvain Bromberber wrote: That picture was very helpful! However I still can't do it. I cannot get that Form Navigation tool bar to show up, as in your picture, or that icon to be added to any toolbar. I click on Form Navigation for toolbars when in a form and the option is

[libreoffice-users] Re: Table Format

2012-03-06 Thread Andreas Säger
Am 06.03.2012 19:25, Sylvain Bromberber wrote: Hi Pertti, All that worked as you described. I found 'Navigation bar'. It was already marked yes! But no visible navigation bar with the icon on your example! Picking Parent form instead of yes made no difference. What is going on? Let me say again

[libreoffice-users] Re: Subforms in LibreO-Base

2012-03-06 Thread Andreas Säger
Am 06.03.2012 19:28, Pertti Rönnberg wrote: Andreas Säger, In your answer to Sylvain Bromberber (about Table format) you mentioned that you set /that property to Parent Form for all subforms of the main form/. Do you mean that you in LibreO-Base can have two or more subforms in one main form

[libreoffice-users] Re: Spell check problems

2012-03-06 Thread Andreas Säger
Am 06.03.2012 15:16, Edwin Matheson wrote: I want to thank everyone for trying to help me with my spell check problem. However, I still have the problem. Spell check tells me that every word in my doc. is spelled wrong. I still have OpenOffice on my computer and I was able to get into the system

<    4   5   6   7   8   9   10   11   12   13   >