Am 20.03.2015 um 05:56 schrieb Emil Payne:
On 19/03/15 08:28 PM, James wrote:
Column A has text strings that are DD/MM/ format.
I want to make them real dates.
I tried these 2 datevalue formulas but I can't make it work.
14/03/2015Err:502
14/03/2015Err:502
Am 20.03.2015 um 13:08 schrieb xavier2:
Hi there, yes that is right, but what is completely weird is that LibreOffice
Base, using a modified SQL don't have a reference book showing all these
modifications and notations? then where can we find reference for that
modification of the SQL
Am 20.03.2015 um 12:21 schrieb Kaj:
Do you have the used date pattern defined? Look at (menu) - Tools -
Language Settings - Languages at Date acceptance patterns.
No. Do you?
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
Am 19.03.2015 um 11:37 schrieb hw:
For a LibreOffice user there is only one built-in tool to do reporting
with pictures. It is the report tool.
Hm, I'm not too happy with that because the defaults aren't too useful,
and when I wanted to make a report to display data from a table, the
Am 19.03.2015 um 11:49 schrieb hw:
Copying icons?
Indeed. In order to copy table or view contents from one DB to another
DB you copy the table _icon_ from one database window, select the table
icon in the other database window (the DB where you have write access)
and paste.
A dialog pops up
Am 18.03.2015 um 16:00 schrieb xavier2:
Hello I'm starting with queries and functions. Right now I know how to tackle
queries, but I don't know very well how may I use functions on queries. I
would like to master all functions, so I need examples with functions. The
problem is I don't know
Am 18.03.2015 um 23:10 schrieb xavier2:
Hi Andreas, thanks for the amazing info you gave me.
Well, I was not meaning to SQL, because what I want to do right now are
queries using the gird, the queries window.
The grid (do you mean the design view?) creates an SQL statement as
you can see when
Am 17.03.2015 um 13:14 schrieb hw:
Am 16.03.2015 um 18:04 schrieb Andreas Säger:
Am 16.03.2015 um 16:18 schrieb hw:
Exactly: What the perl script does is way beyond the capabilities of a
query and of formulas in a spread sheet.
In which way? You are rather unspecific about your
Am 17.03.2015 um 16:37 schrieb hw:
Am 16.03.2015 um 15:57 schrieb hw:
Some experimentation is required at this point ... Thank you for all
the replies so far!
Ok so I made a new spreadsheet and dragged a query from the datasources
view into it. Apparently that fills rows in the
Am 17.03.2015 um 13:36 schrieb hw:
Sorry, this is the wrong answer to the right post --- still a question,
though.
The answer to this post should have been that I would need the images to
appear in the spread sheet.
Pictures in Calc are no spreadsheet data. Pictures are decorative,
Am 17.03.2015 um 13:22 schrieb hw:
Am 16.03.2015 um 18:00 schrieb Andreas Säger:
Am 16.03.2015 um 16:21 schrieb hw:
Without any coding it is be possible to create a field of hyperlinks.
Just add a HYPERLINK formula next to the import range. The adjacent
field expands to the size
Am 16.03.2015 um 16:21 schrieb hw:
Without any coding it is be possible to create a field of hyperlinks.
Just add a HYPERLINK formula next to the import range. The adjacent
field expands to the size of the import range.
You mean to the size of the image? It doesn't scale the images to
Am 16.03.2015 um 16:18 schrieb hw:
Exactly: What the perl script does is way beyond the capabilities of a
query and of formulas in a spread sheet.
In which way? You are rather unspecific about your requirements.
Even letting aside that using the BASIC dialect of LO is very awkward
(just
Am 16.03.2015 um 15:57 schrieb hw:
Creating LO documents directly would be nice and might have the
advantage to be able to specify some formatting --- which I might need
to do sooner or later.
Formatting is a matter of style, cell styles in this case. Linked import
ranges filled with
Am 15.03.2015 um 01:18 schrieb charles meyer:
Hi Folks,
I’ve never printed business cards using Libre Writer and it didn’t go
well using the Avery online template.
I have blank sheets of cardstock (bought at Office Depot) to print my
own business cards with logo - one sided only.
Am 12.03.2015 um 02:36 schrieb Sabine Gonelli:
Hi,
I have tried to install Libre Office 4.4.1.2 Win x 86 (English Version)
several times now. When installing it tells me:
Files in Use. Some files that need to be updated are currently in use. The
following applications are using files that
Am 06.03.2015 um 13:59 schrieb Cor Nouws:
Cor Nouws wrote on 22-01-15 21:39:
Dave Barton wrote on 18-01-15 14:06:
The solution is simple. Just log in to the forum and post the announcement.
Ah yes. Will do that. IIRC there will be some major release shortly ;)
I guess some of the moderators
Am 05.03.2015 um 18:36 schrieb SOS:
1. I cannot use
2. LO Base is missing options
LibreOffice Base is not a database development platform. It is hardly
more than a bridge between databases and office documents. Yes, there is
a limited set of form controls and yes, it comes with macro
Am 06.03.2015 um 09:08 schrieb Alex Thurgood:
Le 04/03/2015 10:59, hw a écrit :
Hi,
In a future step, I would like to integrate graphics into the
spreadsheet which could be created by a perl script with gnuplot from
data in the database; the images could reside in a directory and rows in
Am 06.03.2015 um 16:06 schrieb Jaroslaw Staniek:
On 5 March 2015 at 17:32, SOS s...@pmg.be wrote:
Stefan ,
Macro's can live in any document so also in a Standalone form , better
is to place your macro's in the LO application, who makes is fast more easy
to Update and distribute for several
Am 04.03.2015 um 10:59 schrieb hw:
In a future step, I would like to integrate graphics into the
spreadsheet which could be created by a perl script with gnuplot from
data in the database; the images could reside in a directory and rows in
the database would have a field referring to the file
Tom, It is too obvious that you never use LibreOffice Base.
--
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
Am 05.03.2015 um 19:38 schrieb Andreas Säger:
Am 05.03.2015 um 16:46 schrieb Stefan Geith:
Am 05.03.2015 um 16:21 schrieb Peter Goggin:
Macros are available from within LibreBase forms. I use them for
switching between forms etc,
Are Macros also available, if the form is saved
Regarding the interface to the big irons:
Base can not handle arrays field types.
Base can not handle binary field types. It crashes (possibly losing the
embedded database) when you load a form with many records having
pictures (normal size as in typical photos).
Form grids become unusable when
Am 05.03.2015 um 16:46 schrieb Stefan Geith:
Am 05.03.2015 um 16:21 schrieb Peter Goggin:
Macros are available from within LibreBase forms. I use them for
switching between forms etc,
Are Macros also available, if the form is saved as a *standalone form* ?
I've heard, that not...
Am 04.03.2015 um 10:59 schrieb hw:
Hi,
how would I create a spreadsheet from a table in a database?
[Tutorial] Using registered datasources in Calc
https://forum.openoffice.org/en/forum/viewtopic.php?f=75t=18511
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Am 04.03.2015 um 11:03 schrieb Tom Davies:
Hi :)
I think Noel ( Marion)'s good experience of H2 being sooo much better than
Base is purely down to them moving away from the internal back-end in
Base. The version of HsqlDb mentioned by Noel is the 1.8 which Andreas
identified as being the
Am 03.03.2015 um 16:06 schrieb Peter Goggin:
Much of the e-mails on Base have focussed on negative aspects. It is
worth remembering that for moderate size data bases (a few thousand
records, a dozen tables) it is perfectly adequate. I have now converted
all of my data ase applications for MS
Am 02.03.2015 um 21:23 schrieb Tom Davies:
Hi :)
Apparently another great database program to use as a back-end is
Postgresql. Some of the Postgresql people worked with the LibreOffice
people to make a really good connector and then got that connector into
LibreOffice main trunk.
This is
Am 02.03.2015 um 19:33 schrieb Florian Reisinger:
Just a short note: Base can connect to a MySql database using a connector.
I even think, knowing not much about Base, that an external database for
storage is a very good way to go...Am 02.03.2015 16:54 schrieb Peter Goggin
Am 01.03.2015 um 22:31 schrieb Jay Lozier:
I have not kept up with Base, I tend to use MariaDB/PostgreSQL directly;
not through the Base front end. I vaguely remember some chatter about
replacing HSQL with something else.
Replacing an excellent database engine with another excellent
Am 01.03.2015 um 22:01 schrieb Jay Lozier:
What is the current backend for Base?
I remember at one time is HSQL 1.8 but one could install a later
version.
Jay
When you create a new database document without Java support, then you
get a directory of flat dBase files handled by
Sigh!
Each and every aspect of OpenOffice, LibreOffice, Java and Base in
particular:
https://forum.openoffice.org/en/forum/viewtopic.php?f=74t=69896
Linux distros do not install Base because most people do not understand
this drunken cousin of a component anyway. Linux users can install the
Am 25.02.2015 um 12:38 schrieb hw:
How do you build an installation package?
The code needs to live in your own name space (not library Standard).
ToolsMacrosOrganizeBasic...
[Organizer...]
Tab [Libraries]
[Export]
Non-Standard libraries can be imported from documents and templates. For
Am 23.02.2015 um 13:20 schrieb Andreas Säger:
Am 23.02.2015 um 13:02 schrieb hw:
Would it be possible to have one file this Standard library is saved
in for multiple users, or would that give problems with several users
accessing the same file? Perhaps I could put it on a network share
Am 23.02.2015 um 13:02 schrieb hw:
Would it be possible to have one file this Standard library is saved
in for multiple users, or would that give problems with several users
accessing the same file? Perhaps I could put it on a network share and
allow only read-only access to it.
Yes.
Am 21.02.2015 um 19:17 schrieb hw:
Hi,
how can I make a self-written function (i. e. a macro) available for all
spreadsheets so that I can use this function for any spreadsheet I
create or load and modify?
Ideally, this should work with multiple users in that I'd like to deploy
the
P.S. to the special case where you imported normal dates in US context
ending up with a column of wrong dates and text.
Assuming that you don't have the original data at hand so you can not repeat
the data import with appropriate import options, this is how to correct
wrong values:
1) Switch the
1. Do not type dates into cells that are formatted as text and do not type
dates with a leading apostrophe
2. Do not import dates as text values from csv or html files.
3. When you paste content from another program, then do not hit Ctrl+V. Use
the paste-special command, import raw text data and
So it's a Calc sheet actually. I would simply use Calc to concatenate the
proper field contents and then use that calculated field for the mail merge.
Something like =TRIM($A2 $B2 $C2) with a column title in the firs
row copied down along the list.
A database query would be easier to handle
That wizard is counter productive and irritating for several reasons. You can
create serial letters easier without it. Once you have a registered database
connection to your list (F4 shows your database and tables), all you need to
do is this:
Select your table or query in the left pane and then
Composing the lines of an addressing area is easy to do with a query. Details
depend on the type of your database.
In Writer you can use a conditional field with a nested data source field
like this:
If condition: DataSource.QueryName.Title !=
Then:
--
View this message in context:
Virgil Arrington-2 wrote
That said, it might be interesting to see how the poll might fare if
there were an option of MS Office running under Wine. Does anybody
actually do that?
Four free Microsoft downloads to view file formats rtf, doc(x), xls(x),
ppt(x) flawlessly under Wine:
Download this artbitrary database document with an embedded HSQLDB:
https://forum.openoffice.org/en/forum/download/file.php?id=22304
Run this:
SELECT * INTO TEXT exportTable1 FROM Table1
which creates exportTable1.csv in the same directory where the document
lives.
--
View this message in
Mark Stanton wrote
Hmm
Wild! I don't see a text export though, other than saving the Writer file
as
a text file.
Well, yes. Saving in any other file format than ODF is an export indeed.
So we can use Calc, Writer and the underlying database engine to export
database data as plain text.
You must not copy any opened table or query. You copy and paste the _icon_ of
a query or table.
You can also link record sets to spreadsheet ranges and pivot tables which
gives quite a powerful report engine.
[Tutorial] Using registered datasources in Calc
Am 18.01.2015 um 18:43 schrieb Rich Shepard:
Than, when I clicked the 'Finish' button I get a LO save dialog with the
default name of 'New Database' (with a space that needs to be removed, no
less!). If I give it a name, does the new *.odb contain the schema and data
of the existing
Am 18.01.2015 um 00:07 schrieb Charles-H. Schulz:
I am curious why you are pushing the OpenOffice forum rather than the
LibreOffice Forum (access via Nabble or the other forum, http://
www.libreofficeforum.org ; or Ask.libreoffice.org ). Obviously you are a
volunteer there but please
So much for topic support options.
--
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:
Am 16.01.2015 um 14:48 schrieb Andreas Säger:
As far as content matters,
https://forum.openoffice.org/en/forum/index.php
is the major resource of user knowledge for both OpenOffice and
LibreOffice users. This mailing list is somewhat disappointing.
More specificly:
A considerable
Am 15.01.2015 um 19:07 schrieb dave boland:
The problem with gmane.org is that I can't seem to append to a thread.
I can follow the thread, so it is somewhat helpful.
In this aera of spam and fraud you need to subscribe to a mailing list
in order to send messages. There is a switch (nomail
Am 14.01.2015 um 19:23 schrieb Wade Smart:
Ive stumbled into one of those totally frustrating things that you
cant see the reason for:
C65=countif(C3:C61, Lt Blue)
E65=countif(E3:E61, Lt Blue)
G65=sum(c65+e65) = 2
And what is wrong? (apart from the obsolete sum of an addition which
makes
Am 14.01.2015 um 22:49 schrieb dave boland:
Can't we find a way to offer support that is easy and convenient? I get
that new groups are considered old fashioned, but they work very well,
news://news.gmane.org:119/gmane.comp.documentfoundation.libreoffice.user
--
To unsubscribe
Am 13.01.2015 um 22:09 schrieb Andreas Säger:
Am 13.01.2015 um 11:45 schrieb Tom Davies:
Hi :)
That link didn't work on the lock-down system i am currently working
on. They block tons of sites here so i suspect it's that. On the
other hand the Open Office forums had a few problems back when
Am 13.01.2015 um 08:47 schrieb Angus Wood:
On opening Libre Office via the dock icon, a dialogue box comes up telling me
that the program previously unexpectedly quit while opening a document. The
action button “reopen” is pre-selected (by blue shading) Both buttons do
nothing and the
Am 13.01.2015 um 13:00 schrieb Budgie:
Hi Tom,
Thanks for the reply. No joy so far. The problem is expanding the x
axis which is using dates. It is set up for date format but I cannot
find how to expand the scale. I have a screen shot which illustrates my
problem. I shall try and attach
Am 13.01.2015 um 11:45 schrieb Tom Davies:
Hi :)
That link didn't work on the lock-down system i am currently working
on. They block tons of sites here so i suspect it's that. On the
other hand the Open Office forums had a few problems back when Oracle
owned their sites.
The link works.
Am 10.01.2015 um 16:32 schrieb Heinrich Stöllinger:
Hello,
I want the following to work in writer (LO 4.3.5.2, Linux-Mint 17):
if db.table.field != - print db.table.field else print nothing.
In other words - if a field in a DB-tuple isn't empty I want LO
to print that field, otherwise don't
Am 06.01.2015 um 08:46 schrieb bishoplowe:
I have been seeking a way to batch convert WordPerfect files to the .doc
format. I was reading that this could previously be done on some versions of
Libreoffice. There was something about a command line where this could be
done. I have been unable to
Am 01.01.2015 um 23:03 schrieb Andrew Douglas Pitonyak:
The code contains the Turkish dotless i, but it fails (as it should) on
my computer. I am hesitant (perhaps lazy) to mess with my computer's
locale since I don't have a good handle on the implications of changing
it or whether or not I
You are free to enter any text value you want. As far as the arithmetic
calculators named Calc, Excel, Gnumeric etc. are concermed, the
number format is completely unimportant as long as the actual _value_ of
a cell is correct.
All the following formatted numbers represent the exact same value:
Am 31.12.2014 um 14:36 schrieb Marc Paré:
Is there an equivalent Calc function for the Google Sheets function
QUERY? When I downloaded my spreadsheet from Google Sheets as a Calc
file, the QUERY function was not translated into an equivalent Calc
function.
My original Google Sheets function
Am 30.12.2014 um 03:16 schrieb anne-ology:
Thank you for this information -
I did not realize that PDFs were not merely a strange sort of
word document ;-)
(I have not liked PDFs;
have not understand the continual use of them - although some
seem to
Am 19.12.2014 um 04:21 schrieb Andrew Douglas Pitonyak:
And, when you can solve a problem without a macro, that is generally the
better path :-)
And for most of the rest we have:
http://extensions.libreoffice.org/extension-center/access2base
--
To unsubscribe e-mail to:
Am 17.12.2014 um 00:16 schrieb Hedley Finger:
All:
Why not stay with the advantages of LibreOffice instead of trying to make
it as hideous as MS Office!!?
Can MS Office be more hideous than this?
I decided to make a small database of bicycle spare parts in Calc, in which
I would
Am 19.12.2014 um 16:57 schrieb T. R. Valentine:
I suspect you would have more success using the ISO format of
-MM-DD instead of a non-standard format.
Why? Load a Calc document and apply English .MM.DD or German
.MM.TT, Spanish .MM.DD or anything like that. Checking this out
Am 16.12.2014 um 21:43 schrieb Joel Madero:
Hi All,
I have a form based on a table with FirstName and LastName, I want the
form to have a dropdown with SELECT CONCAT(FirstName,,,LastName)
Is there a way to do this?
Thanks!
Best,
Joel
If you want to pick one distinct
Am 17.12.2014 um 18:37 schrieb Rafnews:
Hi,
I'm working on a central document in CALC that should be later convert
to PDF.
in a column i would like to have relative path in such manner that if a
user click on the link it open the file at this path.
However i discover that everything is not
Am 17.12.2014 um 03:05 schrieb Joel Madero:
Hi All,
I have a form that has bookID as a unique key. I want to have a button
that is to open a second form and do the following:
(1) search for the bookID in another table (Series);
(2) If bookID does not exist in Series, create a new record
Am 10.12.2014 um 03:04 schrieb Joel Madero:
pasteSheet.getCellByPosition(1,pasteRow).String = pasteValue
Well, you set the string of a cell.
Set the formula instead.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
Am 10.12.2014 um 18:23 schrieb Joel Madero:
I literally have no clue where those are coming from. They should be:
This is because you hack upon something you do not understand.
1) First of all you need to understand (almost) each and every aspect of
the spreadsheet component. Otherwise there is
Am 10.12.2014 um 21:43 schrieb Joel Madero:
give up the macro and stick with the limited abilities of kmymoney
to do graphs and what not.
Amen!
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
Am 10.12.2014 um 21:43 schrieb Joel Madero:
I'll try to figure out what you mean by what you said - worst case I'll
just give up the macro and stick with the limited abilities of kmymoney
to do graphs and what not.
At least we know know waht you are talking about.
Am 10.12.2014 um 23:08 schrieb Joel Madero:
I extracted the kmymoney file and the info in it seems to be incredibly
conveluted, I'd be surprised if I could just bring it into base without
additional problems. Perhaps I'm terribly wrong though.
Terribly wrong, indeed. You do not bring
Am 28.11.2014 um 10:03 schrieb Mark Stanton:
It seems that Base has a list of keywords and functions for SQL, is
that right?
On the one hand it might be a good thing, on the other, unless the
list is kept up to date then it's a real pain.
For example, ADD_DATE (or DATEADD) in MariaDb,
Am 23.11.2014 um 18:14 schrieb Rob Jasper:
Tom,
I think this is really well explained.
I've been professionally involved in defect reporting for years, and the
problems seem to be the same in all organisations.
Problems in defect reporting:
1- Qualification of type (A bug is
Am 21.11.2014 um 08:34 schrieb Ricky Charlet:
Howdy,
I hope I have a work flow problem. I'll describe what I want, then describe
what I did. And hopefully someone can show me 'the right way'.
I'm writing a book. I have chosen the path of creating a chapter template +
a master document + a
Am 21.11.2014 um 15:12 schrieb Jay Ridgley:
Folks,
I looked on the net and the suggested fix for this message was reinstall
libre-office, and libre-writer, so I did that. I still get the message
what else did I miss?
Install the whole meta package libreoffice with Writer, Calc, Math,
As long as the most prominent member of this list has zero technical
knowledge, this lengthy discussion about standards, file types and wishful
thinking will not stop. Kindly worded excuses can not replace technical
support.
--
View this message in context:
Am 19.11.2014 um 21:19 schrieb Matt Price:
Thank you Andreas. Unfortunately I don't seem to be able to install either
version of the MRI tool -- the unreleased 1.1.4 appears not to be a valid
zipfile, whiel 1.1.2 throws this error:
(com.sun.star.uno.RuntimeException) { { Message = class
Am 20.11.2014 um 01:29 schrieb Jim Byrnes:
On 11/19/2014 12:30 PM, Matt Price wrote:
Yes, lack of more comprehensive documentation is a real pain. Hopefully
someone with more knowledge than myself will comment on what I am about
to write if I am wrong. With the exception of ThisComponent,
Am 20.11.2014 um 21:20 schrieb fred.spurr...@talktalk.net:
Can you please tell me which type of documents WRITER will read. e.g.
Word, Works,? Open office,PDF etc.
Thank you for your help
Fred
menu:FileOpen...
see the list of file types
The list of types in menu:FileSave As... shows the
Am 19.11.2014 um 05:20 schrieb Urmas:
Tom Davies:
I still think that Rtf is well worth avoiding if at all possible but
sadly
a whole load of people fell for MS's marketing. Even to this day
there are
people who believe in using it, despite the findings of the court case.
Which court
Am 19.11.2014 um 13:33 schrieb Virgil Arrington:
On Windows, I have found Atlantis to be very well behaved. It's default
file format is RTF. It doesn't do tables, but everything else it does,
it does well.
.atlantiswordprocessor.com
Virgil
Thank you.
It doesn't do tables. So
Am 19.11.2014 um 14:05 schrieb Urmas:
Andreas Säger:
Which non-MS
application can handle every flavour of RTF you throw at it?
The degree of support RTF in application is not related to the
'complexity' of RTF spec. It has to do with the feature set of
particular app. Once again, if your
Am 19.11.2014 um 15:49 schrieb Tom Davies:
Also Rtf is not plain text as it contains tons of spurious coding and
formatting.
Open rtf in a text editor. Just like HTML, it is plain text indeed.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
Am 19.11.2014 um 17:33 schrieb Tom Davies:
I'm really not getting plain text. When i right-click and open in a
text-editor i get this sort of thing;
Which is plain text in plain 7 bit ASCII. I can paste your rtf into any
plain text editor, save as tom.rtf and open tom.rtf with any rtf capable
Am 19.11.2014 um 19:23 schrieb Tom Davies:
Hi :)
Ahh, ok. If that counts as plain text of a 5 (ish) letter document then
that explains a few misunderstandings i've had.
Regards from
Tom :)
It is a plain text description of an electronic document.
--
To unsubscribe e-mail to:
Am 19.11.2014 um 18:59 schrieb Matt Price:
Jim,
That was it! Or, almost. I changed the line to:
oText.insertTextContent(oVC, oAnno, True)
And the annotation now gets attached to the whole range.
I wish I knew how to find the documentation for these functions! I don't
know what
Hi,
Store all picture files in the same directory as your Base file.
Call menu:ToolsSQL and execute:
ALTER TABLE PicTable DROP COLUMN Pics;
ALTER TABLE PicTable ADD COLUMN Pics VARCHAR(100);
SHUTDOWN COMPACT;
where PicTable should be replaced with the actual name of your table
and Pics with the
Am 29.09.2014 um 02:04 schrieb Carole Edwards Caruso:
I am using LibreOffice 4.3.0.4 with Windows 7.
Hi,
RTF is an awkward file format.
http://diaryproducts.net/for/geek/microsoft_rtf_specification_nightmare
Windows comes with a perfect RTF editor called WordPad.
Greetings,
Andreas
--
Am 14.11.2014 um 23:58 schrieb Jean-Francois Nifenecker:
Le 14/11/2014 21:22, Andreas Säger a écrit :
It is possible to use Calc as reporting engine. Hit F4 and drag your
query onto a spreadsheet cell. When the database content changed, click
any cell in that import range and call
Am 14.11.2014 um 16:03 schrieb Jean-Francois Nifenecker:
Hi,
I've got a working report in Base (connected to a Query, the data source
being a Calc sheet).
This is an accounting report that groups data according to some code in
a column. A subtotal amount is accumulated for each group. I'm
Am 05.11.2014 um 01:23 schrieb Virgil Arrington:
I fully agree with you. Just learning how styles control so much in
Writer is very helpful. But, I have spent literally hours setting up and
modifying styles. While it has been a labor of love for me, it has been
a labor and a major investment
Am 05.11.2014 um 02:51 schrieb Mark LaPierre:
Hey Tom,
It would be nice to post the solution here on the string that is
labelled [Solved] so that people searching for the solution can find
it. Maybe Peter should do that since he seems to have a better grip on
the solution.
The clean
Am 03.11.2014 um 14:54 schrieb Marc Paré:
Is there a way to define the order the tab key (on the keyboard) would
cycle through the cells. Is this possible in Calc?
I would like to define which cells a user is sent to by using her/his
tab key.
Marc
You can do all this and much more
Am 03.11.2014 um 17:48 schrieb Marc Paré:
Should I put it up as a requested feature tiem on the bugzilla?
Marc
It won't be implemented because this is too far away from the intended
purpose of an arithmetic calculator. And this feature is not part of the
ODF standard, so it can't be
Am 03.11.2014 um 18:26 schrieb Marc Paré:
Yes, I did look at Base, but, would rather like to stay with Calc as
there are more people who would be able to trouble-shoot on spreadsheet
software that on LibreOffice Base.
Database design is development work. With a database no user would ever
Hi,
First of all, no professional IT person would do in a spreadsheet what you
perfectly describe as a relational database.
VLOOKUP is the key to mis-use a spreadsheet as a relational database. First
you have to ensure that ToolsOptionsCalcCalculate: Enable Regular
Expressions is OFF and Match
Am 01.11.2014 um 16:30 schrieb Tanstaafl:
On 10/31/2014 4:12 PM, Andreas Säger ville...@t-online.de wrote:
Am 31.10.2014 um 20:32 schrieb Tanstaafl:
If Libreoffice requires Java to do certain things (yes, I understand
that iits reliance on Java is less and less as time goes on, but it
still
301 - 400 of 1278 matches
Mail list logo
