Hi
OK, let me go back to square 1.
First of all I am not talking about a situation in which LibreOffice
base needs to access data tables in separate files that use different
database structures, e.g. one table is in MySQL and another is in
PostgreSQL. This may be something that others need
Brian Jamison wrote:
Steps to reproduce:
On Sheet1 put data in fields A1, A2
On Sheet2 reference A1 and A2 in cells (e.g. =$Sheet1.$A$1, =$Sheet1.$A$2)
Protect Sheet2
Cut the data in cell A1
Paste the data into A2
Cut the data in cell A2
Paste the data into A1
Both field references in
Le 13/10/11 08:14, John Talbut a écrit :
Hi John,
Now, to my situation. First of all I am using Debian GNU/Linux testing
distribution. I use LibreOffice and for my database needs I use base. I
use the built in HSQLDB database application and have my data tables
embedded in the .odb file.
Le 13/10/11 03:23, NoOp a écrit :
Hi all,
I like this part/comment:
Rainer Bielefeld 2011-10-09 23:52:53 PDT
...
Yes, it's dataloss, but are there really many users who still need .sxd?
Now that's the spirit!
Just so that you all know, the engineering committe decided that
Le 11/10/11 19:07, Barbara Tobias a écrit :
Hi Barbara,
After opening Tools/Mail Merge Wizard, we can select starting document
and select document type with no problem. Under Insert address block
we select the same Access table that we have been using for several
years, but step 2,
I think the simple answer to your question (Is this the same in LO)
is yes. But, as others have suggested, it is because you haven't
quite got the right way of looking at it.
Using a database rather than a spreadsheet allows you to group things
according to the content of the data rather than
Hi Alex
Thanks for your response.
On 13/10/11 09:19, Alexander Thurgood wrote:
Le 13/10/11 08:14, John Talbut a écrit :
This has worked adequately (clunkily I would say, but I will keep other
difficulties out of this discussion). However, base has recently become
unusably slow in response
Hi,
Linking tables from different database is impossible.
I know one partial work-around for this limitation:
You can create a form on a stand-alone document, say some Writer
document with a MainForm bound to some table/query in data source
Source A.
Then you can add a subform, say SubForm
Le 13/10/11 10:54, John Talbut a écrit :
Hi John,
I am aware of this. I am not really interested in who is to blame, it
needs sorting for current versions of JDK. If you or anyone has any
idea what the change is in JDK that has led to this problem please
answer at
Hello,
I was finally able to connect my LO database with my mysql database, now I just
have to adjust the fields so they match. in my mysql database I have fields
with drop down lists using the field type SET. In LO its that equivalent to
List Box in the Forms View? if yes how do I get the
Hi :)
Oracle seem to have been treating this community as a competitor since before
the split away from OpenOffice. Apparently there have been a lot of attempts
at co-operating with them but Oracle tend to refuse to respond. Both normal
Java and openJDK are run by Oracle. The LO devs have
Hello,
I don't know if this is the best place to ask this question but I could not
find any better : there is a function in Calc that has been removed between
LO3.3.3 ad LO3.4.3, but I don't know if that was made on purpose or not.
If it as removed accidentaly, then maybe I could list it as a
Dears
I migrated from openoffice to libreoffice 3.4.3
I'm getting a crash on all software from libreoffice when I access the
fonts pull down list.
My system is:
[ota@squitch /usr/ports/editors/libreoffice]$ make showconfig
=== The following configuration options are available for
John
On Thu, 2011-10-13 at 07:14 +0100, John Talbut wrote:
Hi
OK, let me go back to square 1.
First of all I am not talking about a situation in which LibreOffice
base needs to access data tables in separate files that use different
database structures, e.g. one table is in MySQL and
On Thu, 2011-10-13 at 09:39 +0100, Mark Stanton wrote:
I think the simple answer to your question (Is this the same in LO)
is yes. But, as others have suggested, it is because you haven't
quite got the right way of looking at it.
Using a database rather than a spreadsheet allows you to
Am 13.10.2011 08:14, John Talbut wrote:
Hi
OK, let me go back to square 1.
First of all I am not talking about a situation in which LibreOffice
base needs to access data tables in separate files that use different
database structures, e.g. one table is in MySQL and another is in
PostgreSQL.
Am 13.10.2011 05:50, Brian Jamison wrote:
Steps to reproduce:
On Sheet1 put data in fields A1, A2
On Sheet2 reference A1 and A2 in cells (e.g. =$Sheet1.$A$1, =$Sheet1.$A$2)
Protect Sheet2
Cut the data in cell A1
Paste the data into A2
Cut the data in cell A2
Paste the data into A1
This is
Am 13.10.2011 13:06, Michael Guillet wrote:
Hello,
I was finally able to connect my LO database with my mysql database, now I just
have to adjust the fields so they match. in my mysql database I have fields
with drop down lists using the field type SET. In LO its that equivalent to
List Box
Doesn't it work if you simply press Ctrl+Arrow?
I don't know your OS, but in Win XP it jumps to the first/last cell with
data, unless I misunderstood your question...
--
View this message in context:
Readers,
Is it possible to use the 'find' dialogue window to replace text that
a style can be applied to? For example find text 'abc' and replace
with 'abc' whereby a style (emphasised) is applied to the result.
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Le 13/10/11 13:06, Michael Guillet a écrit :
Hi Michael,
Hello,
I was finally able to connect my LO database with my mysql database, now I
just have to adjust the fields so they match. in my mysql database I have
fields with drop down lists using the field type SET. In LO its that
Hi :)
If you are talking about the pasted text having the same format as the text
surrounding where you are placing it then i think that is posted as a
bug-report already. It was a very long time ago tho so it might be worth
bumping the thread if you have soemthing useful to add (assuming you
Readers,
Is there a word processor equivalent to the \thinspace instruction in
LaTeX and ideally a keyboard shortcut to enter into documents?
Thanks.
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems?
Hi Alexander,
Alexander Thurgood schrieb:
Le 13/10/11 03:23, NoOp a écrit :
Hi all,
I like this part/comment:
Rainer Bielefeld 2011-10-09 23:52:53 PDT
...
Yes, it's dataloss, but are there really many users who still need .sxd?
Now that's the spirit!
Just so that you all know,
Hi Otalcilio,
Otacílio schrieb:
Dears
I migrated from openoffice to libreoffice 3.4.3
I'm getting a crash on all software from libreoffice when I access the
fonts pull down list.
There have been some bug reports for OOo about fonts, which lead to a
crash. Please search the Bugzilla [1], to
Andreas Säger-2 wrote:
This is expected and wanted behaviour in all spreadsheet applications.
That's odd. How can I truly protect the field references on a protected
sheet from change?
--
View this message in context:
Hello
This topic has rather hijacked my question about base and external data
tables so I am starting a separate thread.
I am well aware of the problem, as summarised here:
http://wiki.documentfoundation.org/Base
The current workaround involves using an older version of openjdk-jre.
(Not
On 13/10/2011 12:12, Regina Henschel wrote:
Hi Otalcilio,
Otacílio schrieb:
Dears
I migrated from openoffice to libreoffice 3.4.3
I'm getting a crash on all software from libreoffice when I access the
fonts pull down list.
There have been some bug reports for OOo about fonts, which lead to
Le 13/10/11 17:02, Regina Henschel a écrit :
Hi Regina,
As far as I understand it, only the binary formats will be disabled for
writing. That's the file format from StarOffice5.2 with file extensions
like sdw.
The SX* formats are packages with content.xml and styles.xml, similar to
the
Hi Alexander,
Alexander Thurgood schrieb:
Le 13/10/11 17:02, Regina Henschel a écrit :
Hi Regina,
[..]
I just had a thought that maybe this SXD export business is due to an
incorrect mimetype setting similar to the one we encountered on bugzilla
with the FlatXML ODG export filter and which
Am 13.10.2011 17:47, Brian J. wrote:
Andreas Säger-2 wrote:
This is expected and wanted behaviour in all spreadsheet applications.
That's odd. How can I truly protect the field references on a protected
sheet from change?
--
You mean: How can I refer to one particular cell address?
Am 13.10.2011 16:35, e-letter wrote:
Readers,
Is it possible to use the 'find' dialogue window to replace text that
a style can be applied to? For example find text 'abc' and replace
with 'abc' whereby a style (emphasised) is applied to the result.
Use the Find All button to select all
Andreas Säger-2 wrote:
You mean: How can I refer to one particular cell address?
=OFFSET($SheetX.$A$1;2;3;4;5)
No, I mean how can I refer to a particular cell address no matter what a
user does to that cell. Moving, cutting, pasting, overwriting, anything. I
always want to point to,
Hi.
What about trying
=INDIRECT(sheet1.a1)
If my understanding of your requirement is correct, this seems to work.
steve
On 14/10/11 13:49, Brian J. wrote:
Andreas Säger-2 wrote:
You mean: How can I refer to one particular cell address?
=OFFSET($SheetX.$A$1;2;3;4;5)
No, I mean
On 10/13/2011 01:26 AM, Alexander Thurgood wrote:
Le 13/10/11 03:23, NoOp a écrit :
Hi all,
I like this part/comment:
Rainer Bielefeld 2011-10-09 23:52:53 PDT
...
Yes, it's dataloss, but are there really many users who still need .sxd?
Now that's the spirit!
Just so that
Hi :)
Can you name a cell? In Excel you could define a name for a cell by just
typing it in on the formula bar just before the f(x)Sigma bit. Normally the
drop-down there contains the cell's address, such as A!, but you can just type
something else into there to rename it. Try calling it
Hi :)
Would it be reasonably easy to generate a script to upgrade all the sxd's to
ODF using 3.4.2 as a headless horseman?
Regards from
Tom :)
--- On Thu, 13/10/11, Regina Henschel rb.hensc...@t-online.de wrote:
From: Regina Henschel rb.hensc...@t-online.de
Subject: Re: [libreoffice-users] Re:
Hi :)
So do you need replacement fonts? There might be someone around in a day or so
that might be able to help :)
Regards from
Tom :)
--- On Thu, 13/10/11, Otacílio otacilio.n...@ee.ufcg.edu.br wrote:
From: Otacílio otacilio.n...@ee.ufcg.edu.br
Subject: Re: [libreoffice-users] LibreOffice
Hi :)
OpenJDK is on Oracles list of OpenSource projects it runs
http://oss.oracle.com/
The OpenJDK website mentions Oracle a bit
http://openjdk.java.net/faq/
About 2nd or 3rd main sub-heading is Oracle's plans for OpenJDK.
The Wikipedia page gives soem background
On 14/10/2011 12:37 PM, Tom [via Document Foundation Mail Archive] wrote:
Hi :)
Would it be reasonably easy to generate a script to upgrade all the
sxd's to ODF using 3.4.2 as a headless horseman?
Regards from
Tom :)
The document converter wizard in 3.4.3 converts all the existing SXD
No one else here having this issue ?
--
View this message in context:
http://nabble.documentfoundation.org/Windows-Explorer-Extension-tp3414735p3420569.html
Sent from the Users mailing list archive at Nabble.com.
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Hi Tom
On 14/10/11 02:56, you wrote:
The OpenJDK website mentions Oracle a bit
http://openjdk.java.net/faq/
About 2nd or 3rd main sub-heading is Oracle's plans for OpenJDK.
That page mentions Oracle quite a lot! However, they make a very clear
commitment to open source and to welcoming
42 matches
Mail list logo