Am 14.09.2012 16:41, John Clegg wrote:
where I wouldn't be able to get at it without Internet access? (Dropbox of
course keeps local copies which it synchronises). Or is this one use use
where embedded HSQL really is the right answer??
All views appreciated!
Of course you can not access cloud
Am 14.09.2012 12:25, Richard Quadling wrote:
Hello.
I'm new to using a Mac and some of the things I can do in Windows I'm
unable to even work out the question for on a Mac, so please bear with me.
The files are generated from an automated system, several hundred a day and
have a .tsv extension
Am 10.09.2012 22:30, Andreas Säger wrote:
Am 10.09.2012 19:40, Andreas Säger wrote:
Base is our database component. It is very, very underdeveloped,
nevertheless underestimated. Even the worst database tool does a better
database job than the best spreadsheet can do.
Since nobody ever
Am 13.09.2012 11:54, Andreas Säger wrote:
Am 13.09.2012 05:03, JAMES MAJESKI wrote:
My only queries of the data are handled adequately by the calculations
done
in adjacent columns. Nothing special, complex, or complicated will easily
replace it nor be more useful.
Calc can do all this
Am 13.09.2012 05:03, JAMES MAJESKI wrote:
My only queries of the data are handled adequately by the calculations done
in adjacent columns. Nothing special, complex, or complicated will easily
replace it nor be more useful.
Calc can do all this without very easily with the help of the Base
com
Am 13.09.2012 05:18, JAMES MAJESKI wrote:
So far nobody has come up with a reason for me to switch to a database where
I risk loosing data if I attempt to make a change to the layout.
--
View this message in context:
http://nabble.documentfoundation.org/Date-will-not-format-or-sort-when-impor
Am 13.09.2012 00:49, JAMES MAJESKI wrote:
Name one feature that makes a database better than a spreadsheet when
flexibility of input is required.
--
View this message in context:
http://nabble.documentfoundation.org/Date-will-not-format-or-sort-when-imported-into-calc-ods-tp4004907p4007128.ht
Am 12.09.2012 07:52, Nicolas ABEL wrote:
I would need a way to fill user informations from a Sun LDAP on a few
hundred computers (Libreoffice 3.5.6.2 already installed).
The best would be to update informations from the LDAP at each restart
or on demand.
Any clue to help us do that ?
Thanks in ad
Am 12.09.2012 15:23, Enda wrote:
OS: Ubuntu
Calligra does not create a dot file when viewing files, is there an option to
turn this off in LibreOffice?
I give up.
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/ma
Am 12.09.2012 15:35, a a wrote:
Hey,
When i am creating a diagram i can change the numeric values of the y-axel,
but when i try the same procedure for the x-axel, the template with options
stay grey and imposible to change. How can i do to make this grey area
black again so i can change the numer
Am 12.09.2012 08:00, JAMES MAJESKI wrote:
My research has convinced me that I do not have neither the time nor the
resources to set up and maintain a database. I might consider it if all of
the data were received in the same layout, but the layout is as varied as
are the sources. Since I am the o
Am 12.09.2012 07:23, JAMES MAJESKI wrote:
Two digit years have always been a problem. I always presume that the use two
digit years was obsolete after the Y2K publicity, but bad habits continue.
We are no longer in the era of eighty column punch cards, so there is no
excuse for two digit years.
Am 11.09.2012 22:34, Girvin R. Herr wrote:
Greetings,
I have several real old dBASE data files from 1985 that I would like to
get the data from and convert to LO Base. I keep reading about LO being
able to access a dBASE file, but I am having trouble doing so. I tried
the new database wizard an
Am 11.09.2012 20:28, Brian Barker wrote:
At 18:10 11/09/2012 +0200, Andreas Säger wrote:
Am 11.09.2012 18:01, Enda Noname wrote:
Can Libreoffice not create a dot file in same folder as document when
opening it for viewing?
.~lock.file.doc#
That's what it does.
I think the question
Am 11.09.2012 18:01, Enda wrote:
Can Libreoffice not create a dot file in same folder as document when opening
it for viewing?
.~lock.file.doc#
- Enda
That's what it does.
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/ge
Am 10.09.2012 09:57, alci wrote:
When using LibreOffice, I like to have the navigator and the stylist panels
open.
But to save space, I need to have them on top of the other, not side by
side. I can achieve that by using Ctrl + moving the panel where I want it to
be.
But when I re-open the appli
Am 10.09.2012 19:40, Andreas Säger wrote:
Base is our database component. It is very, very underdeveloped,
nevertheless underestimated. Even the worst database tool does a better
database job than the best spreadsheet can do.
Since nobody ever uses Base for plain text databases, here is
Am 10.09.2012 18:56, JAMES MAJESKI wrote:
The following is a reply to my query from a private source:
Data bases are for fixed data columns and standardized input methods and
require manipulation by sql type query tools. Unless you are getting
automatic feeds of significant amounts of data from
Am 10.09.2012 01:49, JAMES MAJESKI wrote:
You are correct in that 12/31/12 is not ambiguous, but that is a special
case. When each element is unique and without knowing the source preference,
there are six different dates that may be generated from "10/11/12":
2010-11-12
2010-12-11
2011-10-12
201
Am 10.09.2012 16:37, Dan Lewis wrote:
What operating system are you using? Is it 32 bit or 64 bit? What
version of Java are you using? (1.7 or 1.6.)? Is it 32 bit or 64 bit?
Basic macros, Python macros and the macro recorder work without any Java.
--
For unsubscribe instructions e-mail
Am 09.09.2012 21:17, naomi.br...@gmail.com wrote:
Hi,
I'm very new to Base, so any help is appreciated! I've created the fields
postcode and email address, amongst others, and I want to create an input
mask for each of them.
I've started with the postcode mask, and entered AANNNAA and I've trie
Am 09.09.2012 20:52, naomi.br...@gmail.com wrote:
Hi,
I've just had the same problem, I want to enter a year in the format ,
which I can't using the date/time field type. Having read this post I tried
to choose an integer and have it set the length to 4, but it won't let me
change the length
Am 09.09.2012 11:54, Tinkerer wrote:
Use the extension CT2N.
It Converts Text to Numbers.
Simples.
Tink.
Nobody needs to install any extension to convert between numbers and
text. CT2N may fail in this situation (dmy vs. mdy).
If all the dates have been imported as text, a simple regex re
Am 09.09.2012 12:19, IGraham wrote:
Calc
How do i (can i) place in a cell a message - that isn't part of the active
spreadsheet
I want to tell the user the data type they should be entering as 'date type
01/01/2012' and that the message will disappears as the user starts typing
Thanks for any hel
Am 09.09.2012 07:32, Roger Davis wrote:
How do I change the Calc default of adding 1 (+1) when a cell is drag-copied?
I just want it to copy to the location(s) drug to, NOT add 1 to each cell in
sequence.
I know that holding CTL when doing this will prevent the addition, but I
need this to be th
The data are dumped into a blank new sheet. In a blank new sheet there is
only the "General" number format which applies one distinct number format
per number format category.
You must not try to edit text tables in a spreadsheet and expect numbers to
be resaved in the same number format as they ha
Please avoid the term "formatting". No, the locale setting does not format
anything. This option specifies the assumed language to be used for the
*interpretation of text strings*.
For instance, a "German(Germany)" locale for this particular text import
tells the program that ...
123.456 needs to
Tanstaafl wrote
>
>
> This makes no sense.
>
> Is there some reason that the install routine can't automate this?
>
> I just don't see thousands (or millions) of users having to do this
> manually.
>
Only you and a couple of others. You must not think that this is a general
problem that has
Peter Pervers wrote
>
> Following problem:
>
> - I am using LibreOffice 3.6.0.2 on Kubuntu 12.04.
> - I am using a English US locale where the decimal separator is the
> period.
> - when I copy these three numbers out of this text box:
>
> 2.09
> 2.40
> 2.12
>
> and paste them into Calc cell
So the topic is about importing ISO dates, right?
Calc, Writer and Base always interprete 2012-09-05 23:45:59 correctly
regardless of locale conetex when you type it into some table cell unless
the cell is explicitly prepared to accept text only.
When using the text import dialog, all you need to
Of course Calc can import and export all flavours of numbers, dates,
currencies, scientific numbers, plain text, numeric text, booleans and
fractions in 180 different languages. Just do it.
btw: There is no formatting in a text editor (gedit). So you can not remove
any formatting.
--
View this
Am 04.09.2012 11:42, chimak111 wrote:
Peter Pervers wrote
Following problem:
- I am using LibreOffice 3.6.0.2 on Kubuntu 12.04.
- I am using a English US locale where the decimal separator is the
period.
- when I copy these three numbers out of this text box:
2.09
2.40
2.12
and paste the
Am 02.09.2012 18:24, Sandy Miller wrote:
Following problem:
- I am using LibreOffice 3.6.0.2 on Kubuntu 12.04.
- I am using a English US locale where the decimal separator is the period.
- when I copy these three numbers out of this text box:
2.09
2.40
2.12
and paste them into Calc cells B2
Am 02.09.2012 21:33, anne-ology wrote:
Please keep us informed ...
it might be nice to have the program be able to inject
dd-mon-year and/or dd-mo-year for genealogical research projects ;-)
It can do this easily for thousands of different csv formats.
--
For unsubscri
Am 01.09.2012 14:04, JAMES MAJESKI wrote:
How do I get rid of the single quote format character so I can work with the
dates from imported cvs or xls files?
--
View this message in context:
http://nabble.documentfoundation.org/Date-will-not-format-or-sort-when-imported-into-calc-ods-tp4004907
Am 31.08.2012 20:38, JOE CONNER wrote:
How do I format a calc cell to show an angle in degrees, with a range of
0 to 360 degrees
while internally using 0 to 2pi, (similar to the date display using a
double number internally)?
This has nothing to do with number formats.
http://wiki.openoffice.
Am 31.08.2012 09:55, zig wrote:
I solved the problem following the advise of the first answer (save the
document as .doc) and it is readable in LO,OO and Word.
If you think it can be useful I can post a bug-report
Thanks
No, I don't think it would be useful. There is no way to implement all
th
Am 30.08.2012 14:29, webmaster-Kracked_P_P wrote:
Are you saying projects like the NA-DVD might have a "modified" version
of LO hiding something that should not be there?
Do you trust any site like this one?
http://www.bestfreewaredownload.com/freeware/k-presentation-domination-scam-t-free-lib
Am 30.08.2012 02:21, Dan wrote:
To make sure I understand: Norton deletes the LO 3.6.1 download file?
Otherwise, you should not have Norton running when you install the
upgrade; you should not be physically connected to the Internet either.
Disconnect from Internet, turn off anti-vir
Am 29.08.2012 22:50, Rafał Piszczek wrote:
Hi,
Ver. 3.6.1 still bad recognition date.
Up to ver. 3.5.6 when I wrote "23/8" or just "23 /" changed to 23.08.2012 -
now despite cell format as a date - nothing changes ... For me it falls
off. Daily I have to write on a sheet about 150 dates. So I am
Am 29.08.2012 18:55, Peter Hillier-Brook wrote:
On 29/08/12 16:03, Peter Hillier-Brook wrote:
I've just updated to LibO 3.6.1 and hit the following problem when
trying to access my address book
Does anyone recognise it, Google doesn't?
___
Am 29.08.2012 17:00, Walther Koehler wrote:
Hi,
how to find out the FilterName of a loaded document?
(other than try to "save under" and look what is marked)
I would like to find it by a Basic Makro, but didnt find a hint even in Andrew
Pitonyaks marvellous guide.
a sequelae: Does anybody know,
Am 29.08.2012 17:00, Walther Koehler wrote:
Hi,
how to find out the FilterName of a loaded document?
(other than try to "save under" and look what is marked)
I would like to find it by a Basic Makro, but didnt find a hint even in Andrew
Pitonyaks marvellous guide.
a sequelae: Does anybody know,
Am 28.08.2012 00:38, Paul Morgan wrote:
Anyone with any idea how to solve this problem?
Define a print range for the new sheet or use a sheet template with
print ranges for the new sheet.
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.l
Am 27.08.2012 19:06, Bob McDonald wrote:
It seems to work fine if you take JRE 1.7 off the machine and install JRE 1.6...
Once they take Java out of the equation, it'll be fixed. Until they do,
however, take 1.7 off and Install 1.6. That seems to fix the problem.
YMMV,
Bob
Bob McDonald
Sr
Am 27.08.2012 18:59, hover2gb wrote:
SOLVED - I figured out how to modify the script and then just archive it back
into the database with a ZIP program. And it worked. I now have access to
all of my data, and everything works perfectly.
Thanks, thanks, THANKS!
--
View this message in contex
Am 27.08.2012 16:34, hover2gb wrote:
Andreas,
Thanks for the info. I believe you are correct, but I do not know what to
do now. I am not able to open the table, form or anything to remove the
embedded image. Can you help with this?
-Greg
--
View this message in context:
http://nabble.
You must not embed images in your embedded database. Any form with a
picture control will try to load the whole field. I think this is the
true bug in this affair and it was sitting there ever since.
Use a text field with relative links to picture files.
Bind a form's picture control to the text
Am 25.08.2012 11:11, Zurd wrote:
That's one solution, I just did this : right-click on a sheet, choose
Select all sheet, and copy them to another spreadsheet which now opens very
fast.
So this is the solution to fix your broken file.
--
For unsubscribe instructions e-mail to: users+h...@glo
Am 25.08.2012 09:13, Zurd wrote:
Hi, hoping someone can help me with this problem I'm facing.
When opening a spreadsheet, it takes around 2m10 seconds for LibreOffice to
open it.
It's an old .ODS file created years ago with OpenOffice, not a big file,
only 56 KB, nothing complicated in it, just
This is not a typical Windows program so re-installing it might not
change anything at all. Reset your user profile instead.
Unfortunately, it tries to look like a real Windows program. Turn off
the nasty quick starter for ever (disable it in a custom installation)
so you can be sure that the pr
Am 25.08.2012 08:52, Jean Elchinger wrote:
Hello,
A friend of mine is asking if it is possible to save the workspace
environnement in LibreOffice like you have in MS Office. There is the
file extension xlw for this.
I never used this features so I don't know myself.
Thanks,
Jean Elchinger
No
Am 21.08.2012 17:55, Graham Luffrum wrote:
Hi,
I have tried to put list content in a Base valuelist listbox. I have typed
in each item followed by and the list appears as say "A";
"B"; "C". When I then try to use the form the list is not there. What am
I doing wrong? I am using LO 3.5.4.2 u
Am 20.08.2012 16:40, T. R. Valentine wrote:
Is it possible to configure AutoCorrect to automatically format?
For instance, when I type 'ad' followed by a space and a number, I'd
like the 'ad' to be formatted as small capitals. I know I can use a
search-and-replace to apply the formatting, but wo
Am 20.08.2012 13:13, steelej wrote:
I have a recent install on LO 3.5 into W7. I have just installed the latest
Java which is detected ok. When I select
Options->Internet-> MediaWiki I get a dialog box JRE is Defective - I don't
actuall need this function but wanted to test out Jave compatability
Am 16.08.2012 00:28, Jay Lozier wrote:
varchar(60) is a text string up to 60 characters long. I believe the
actual memory usage is based the number of characters in the string
char(15) is a text string up to 15 characters long but enough memory is
always used for 15 characters.
The length of va
Am 17.08.2012 22:12, Tinkerer wrote:
I am using Libre Office 3.6.0.4 on an iMac 10.8
if I enter the date as 17/08/12 it is displayed as 17/08/2012.
No doubt whatsoever that the date is being accepted using ddmmyy
OK, we could collect valid input pattern for dates in 180 different locales.
1)
Am 17.08.2012 21:30, Milos Sramek wrote:
Dňa 17.08.2012 18:52, Andreas Säger wrote / napísal(a):
Am 17.08.2012 16:31, T. R. Valentine wrote:
http://www.theregister.co.uk/2012/08/15/office_2013_strict_open_xml/
This should improve compatibility between LO and M$O.
Does anybody know how far is
Am 17.08.2012 16:31, T. R. Valentine wrote:
http://www.theregister.co.uk/2012/08/15/office_2013_strict_open_xml/
This should improve compatibility between LO and M$O.
Microsoft announcments
http://peanuts.wikia.com/wiki/Football_Gag
--
For unsubscribe instructions e-mail to: users+h...@
Am 16.08.2012 19:05, Shaun Devlin wrote:
Version 3.6 of Scalc treats a date entered in the format dd-MMM-yy as
text, not as a date which can be displayed in a user selectable format.
This is not true if the date is entered as mm/dd/yy or -mm-dd.
This is a change from 3.5.X and I consider it
Am 15.08.2012 23:22, chilobo wrote:
The image files are stored in a directory "B" (german "Bilder") relative to
the directory of the spreadsheet, the other links are stored in similarly
abbreviated subdirectories.
Because some oft the other files are quite large the whole structure is
copied to
Am 15.08.2012 22:31, Thomas Taylor wrote:
It's been way too many years since I did commercial programming on
databases and I've forgotten some of the terms (formats) for numerical
data. I'm trying to create a simple database of local
facilities/doctors/stores with Base using the wizards. The for
Am 15.08.2012 20:05, leif wrote:
https://bugs.freedesktop.org/show_bug.cgi?id=39523
The bug has never been commented by humans and all later activity was
automated (except the once from my hand).
The perfect example for what went wrong here. Someone tagged it blindly
as "NEEDINFO" although
Am 15.08.2012 19:21, chilobo wrote:
Anyway: Shouldn't Calc be able to work with relative hyperlinks correctly?
Obviously, the developers have a different opinion. They block this
feature with a warning message. At this point I trust that the
developers know very well what they do.
--
Am 15.08.2012 19:01, chilobo wrote:
I found that too, but that doesn't help me. I have a growing database, now
about 1000 datasets, in future about 4000. I will have about 5000 links to
pictures and PDF-documents of which about 4500 will be generated by
formulas, about 500 entered directly, but
Am 15.08.2012 17:50, chilobo wrote:
Why can't Calc handle relative links correctly?
Let's do a simple test with a relative URL:
=HYPERLINK("./B/file.xyz")
[Click]
Security warning: "For security reasons, the hyperlink can not be executed."
Whenever you use an ordinary static hyperlink anywher
Am 15.08.2012 17:01, chilobo wrote:
Hello!
I'm working with Libre Office 3.6.0.4 on Windows 7 64-bit.
In Calc I used the formula
=HYPERLINK(VERKETTEN("B\";B974;".jpg");VERKETTEN("B\";B974;".jpg"))
to produce an Hyperlink to a local Image based on the reference to B974.
When moving the cursor abo
Am 15.08.2012 08:03, Thomas Taylor wrote:
Hi Andreas,
I am not trying to be critical but for the last 2-3 releases no email
message was received about "NEED INFO". That had been done in earlier
releases. Is there a malfunction in the bug reporting system? My
programming days are many years be
Gordon Burgess-Parker wrote
>
> On 14/08/12 21:13, Andreas Säger wrote:
>> I'm going to upgrade all our production systems to AOO 3.4.1
>
> What is "AOO"?
>
http://lmgtfy.com/?q=AOO
--
View this message in context:
http://nabble.documentfoundation.org/
Am 14.08.2012 20:48, Marc Grober wrote:
This (see the quote below) is simply unacceptable. In fact, with respect
to the bug on which I received this little gem quite a few people had
been at pains to clearly identify the problem and the potential
solution, and neither having changed at all, ther
Am 12.08.2012 22:57, Jacob Octavius Jarlskov wrote:
Everytime I press ctrl+c or ctrl+v Writer freeze and collaps. Any ideas?
Shut down Skype.
Shut down any clipboard managers.
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/g
Am 10.08.2012 22:41, Séamas Ó Brógáin wrote:
Andrew wrote:
A blank line does not have to be an empty line. (^$)
She didn’t say “blank line”: she said “white line.” A white line is a
line space between paragraphs that contains no text. (In a
word-processor file I take this to be a line create
http://nabble.documentfoundation.org/file/n4000497/AOO_mail_config.png
--
View this message in context:
http://nabble.documentfoundation.org/Problems-sending-e-mail-with-Libre-Office-tp4000385p4000497.html
Sent from the Users mailing list archive at Nabble.com.
--
For unsubscribe instruction
Am 10.08.2012 09:53, Walther Koehler wrote:
Are you refering to the postscript printer descriptions, my problem is not
related to print its just with opening a file and having an unwanted window.
Walther
No, I was using the wrong acronym. Just go to your package manager and
search for libreo
Am 10.08.2012 08:53, Walther Koehler wrote:
What is wrong? Where is the switch?
Install an additional Base package from your repositories or install the
real thing from http://www.libreoffice.org/download/
Since OOo 2 I pin the PPD versions as uninstallable and install the
latest downloadab
Am 09.08.2012 18:51, webmaster-Kracked_P_P wrote:
I have one users that only uses Windows due to his need to access a
database he created using MSO 98[?] and now using MSO 2000 or 2003. With
no real Base documentation for me to deal with, I cannot figure out how
to make it work with Base.
So thi
Am 08.08.2012 01:01, Steve Morris wrote:
Hi,
I am trying to reproduce spreadsheets created at work in Excel 2002
in Libreoffice 3.6 under Linux and can't do it because pivottables and
charts are not functionally compatible.
When I create the pivottable and drag the fields to the layout
Am 08.08.2012 18:12, teknow wrote:
I have a list of measured times in [H]:MM:SS format and I would like to sum
them. If I put in a formula:
= B2+B3+B4+B5
it works, but if I try:
=Sum(B2:B5)
I get "00:00:00" as a result. What am I missing?
I have tried both LibO 3.5.5.3 and 3.6.0.4
Thanks.
http://nabble.documentfoundation.org/file/n3999573/replace_para.png
http://www.mediafire.com/?rr03nrkrgj47t9j
--
View this message in context:
http://nabble.documentfoundation.org/LibreOffice-Stay-on-Top-property-tp3999136p3999573.html
Sent from the Users mailing list archive at Nabble.com.
-
Am 06.08.2012 13:06, Zappaz wrote:
Andreas Säger wrote
The number formats are taken from the source cells. Anything else can be
set in the styles that are generated for the pivot tables.
Hi Andreas, thanks for your reply.
Unfortunately the formatting of the cells in question does not
Am 06.08.2012 11:43, Tom Davies wrote:
Hi :)
Of course make a back-up (just a normal copy) of your file before taking our
advice. I think Andreas might have meant replace
^$^$
Contrary to you, I know very well what I mean and I use test what I suggest.
I bet, you don't even have LibreOffice i
Am 06.08.2012 08:43, carlamar...@xmsnet.nl wrote:
I want to replace two paragrah endings punctuation marks by one, because I
want to replace white lines.
How do I do that?
Carla
--
I am using the free version of SPAMfighter.
SPAMfighter has removed 12759 of my spam emails to date.
Get the free
Am 04.08.2012 04:15, Carlos Pita wrote:
Hi,
does anyone know if it's possible to list or quickly find all active
standard filters in a calc spreadsheet?
AFAIK there is no visible hint about what columns may be filtered so,
in case I don't remember where the filters are, I have to look for
them
The number formats are taken from the source cells. Anything else can be set
in the styles that are generated for the pivot tables.
--
View this message in context:
http://nabble.documentfoundation.org/Calc-Pivot-Table-format-preservation-tp3999186p3999193.html
Sent from the Users mailing list
Am 28.07.2012 15:42, Hylton Conacher (ZR1HPC) wrote:
I will gladly send this file to anyone who can assist as I need to
create and post to a public user mailing list a PDF at the end of the
month.
Yes, please.
Help is much appreciated
Hylton
Let's see what I can do for you.
--
For unsub
Am 01.08.2012 08:51, Marc Paré wrote:
Could you be trying to save in a file folder where you do not have the
rights to save to? Try saving in your "Home" or "Document" folder to see
if this is the problem.
Cheers,
Marc
This thread is symptomatic for the whole mailing list. Nobody has the
Am 31.07.2012 09:33, Grant wrote:
I'm using Libreoffice Writer on Gentoo Linux and I'm getting an error
telling me I have insufficient user rights when I try to save a
document to any filename other than the default "Untitled 1" which
saves fine. Does anyone know what could be causing this?
- G
Am 29.07.2012 15:57, Mark Stanton wrote:
Hi!
It works when you turn off the parser ("direct SQL" mode) but then you
don't have an editable record set anymore.
Ah yes, silly me. Because it complained that it had to use SQL view I
assumed it was in SQL mode, it wasn't.
Yes, selecting SQL mode
Am 29.07.2012 14:02, Mark Stanton wrote:
BASE's pre-processing, of MySQL at least, prevents the perfectly
legal SQL field specifier
field1 = field2 AS ConditionName
Does it really need to pre-process, or is this more a shortcoming of
its pre-processing?
Regards
Mark
Hi,
It works wh
Am 28.07.2012 22:03, Lynne Stevens wrote:
omega
The
Omega sector
America's Last
Line of
Defense
*Ok Thomas downloads 2 Data bases ( CVS format ) he wants to remove
Duplicates from Data Base B using Data base A and THEN Data Base A gets
deleted when done
*
OK, that is
$ cat fileA.csv f
Am 28.07.2012 14:17, Lynne Stevens wrote:
omega
The
Omega sector
America's Last
Line of
Defense
*How do I check for duplicates in a data base using another data base ?
*
SELECT "A".*
FROM "A" JOIN "B" ON "A"."ID" = "B"."ID"
returns all rows from table A with an equivalent ID in ta
Am 19.07.2012 23:48, rhubarbpie...@gmail.com wrote:
I'd like to create a macro for a user-defined date format (H:MMa/p). As
examples, 7:00 AM would display as 7:00a and 3:33 PM as 3:33p. I can
create the format manually, but I understand the LibreOffice format
can't save user-defined formats.
Am 26.07.2012 08:02, V Stuart Foote wrote:
Andreas,
No crash observed. Guess you'll stay the course a while longer...
Results as opened in LO 3.6.0.2, on Windows 7, 64-bit.
Days column were not rendered on the MediaFire file preview in IE9 or FF 14.0.1
DOB Years Months Days
01/02/
Am 26.07.2012 14:06, Regina Henschel wrote:
Hi Andreas,
Andreas Säger schrieb:
Hi,
The simple spreadsheet document
http://www.mediafire.com/view/?1s1wui59p3p2oxz crashes with LO-Dev Beta
1 (Build ID: 1f1cdd8).
I know there is a more recent build of 3.6 but 3.5 will be my last
version of
Am 26.07.2012 06:26, Andreas Säger wrote:
Hi,
The simple spreadsheet document
http://www.mediafire.com/view/?1s1wui59p3p2oxz crashes with LO-Dev Beta
1 (Build ID: 1f1cdd8).
I know there is a more recent build of 3.6 but 3.5 will be my last
version of LibreOffice.
If someone confirms the crash
Hi,
The simple spreadsheet document
http://www.mediafire.com/view/?1s1wui59p3p2oxz crashes with LO-Dev Beta
1 (Build ID: 1f1cdd8).
I know there is a more recent build of 3.6 but 3.5 will be my last
version of LibreOffice.
If someone confirms the crash with a more recent build, that would be a
Am 25.07.2012 21:29, Gordon Burgess-Parker wrote:
On 25/07/12 20:25, Andreas Säger wrote:
Every MS Office user can save the much more compatible doc and xls
easily.
One of the major problems with Windows 7 (and possibly Vista - I can't
remember) is that the "Show file extensions
Am 24.07.2012 03:03, Don Parris wrote:
I would like to take something of a straw poll, if that's ok. I simply
want to know whether any of you have shared documents using the ODF format
with MS Office users (preferably in a business environment), and what was
the reaction? What problems
-- I
Works for me.
I enter (c) and get ©
I remove the respective list entry in the replace list of the auto-correct
options, enter (c) and get (c).
--
View this message in context:
http://nabble.documentfoundation.org/turn-off-specific-autocorrect-items-tp3997604p3997635.html
Sent from the Users mai
These cultural differences can not be resolved by software. This office suite
used to handle these things gracefully.
After all those years since Excel '95 I got used to the input method "23/"
which enters this month's 23th day from any num-pad on any keyboard, in any
office component, under US lo
501 - 600 of 1399 matches
Mail list logo