Hi,
ever since I changed the directory for temporary files in the settings
from /tmp to another directory, LO always wants to recover a file, or
some files, when it's started despite these files don't need any
recovery. The recovery fails.
It is a very bad idea to use /tmp as the directory from
On Wed, 2023-07-12 at 08:25 -0400, James wrote:
> You need to turn on macros in the settings (google how, I forgot) and
> the
> setting is enabled to record it (google where :-)). I think you can
> assign the macro to a key.
Thank you very much! I have enabled macro recording, recorded a macro
On Wed, 2023-07-12 at 11:41 +0100, Brad Rogers wrote:
> On Wed, 12 Jul 2023 12:09:29 +0200
> hw wrote:
>
> Hello hw,
>
> > Why can't that happen automatically when loading a file, or at
> > least
>
> IME 'optimal width' results in a cell
On Wed, 2023-07-12 at 07:51 -0500, Michael H wrote:
> "function" here would mean an action somewhat related to the
> advertisement
> in the menu name.
The empty field does not have a menu, or does it? Function would mean
that something happens when you right or middle click the empty field.
Curre
On Wed, 2023-07-12 at 10:35 +0100, Brad Rogers wrote:
> On Wed, 12 Jul 2023 11:13:41 +0200
> hw wrote:
>
> Hello hw,
>
> And adding to my previous;
>
> If you select the entire sheet, then right click on a column and select
> "Optimal Width...", guess wha
On Wed, 2023-07-12 at 10:18 +0100, Brad Rogers wrote:
> On Wed, 12 Jul 2023 11:13:41 +0200
> hw wrote:
>
> Hello hw,
>
> > field at the top left sets all columns to optimal width. That field
> > currently has no function at all.
>
> It selects the entire sh
On Tue, 2023-07-11 at 15:07 -0400, James wrote:
> It's a great idea for a feature.
>
> I don't know how hard it would be to add a checkbox beside column type
> to make the column the automatic width.
No checkbox needed, just make it so that a right click on the empty
field at the top left sets a
Nobody has an idea? It should be possible using a macro, shouldn't it?
On Sun, 2023-07-09 at 11:50 +0200, hw wrote:
> Hi,
>
> how can make it so that when opening files, especially CSVs, with calc,
> the whole sheet is automatically being set to optimal column width?
>
Hi,
how can make it so that when opening files, especially CSVs, with calc,
the whole sheet is automatically being set to optimal column width?
I have to do that manually every time and that's really annoying,
especially since there's no easy way to do that, like right-clicking on
the top left e
Am 15.05.2015 um 10:03 schrieb Brian Barker:
Another contributor suggested that the original enquirer's problem may
have been caused by (unwisely) saving spreadsheets in Microsoft Excel
format, and it appears that this may well have been so. My experiments
suggest that spreadsheets saved with
Am 15.05.2015 um 08:58 schrieb Mike Scott:
>
Now, if I reload doc1 and doc2 simultaneously, showing in 2 windows,
both spreadsheets show the same results as before. Furthermore, checking
the (expected-to-be-global) Tools option for case sensitivity shows
different values when the dialogue is op
Am 14.05.2015 um 11:55 schrieb Brian Barker:
At 20:32 12/05/2015 +0200, Honly Wonly wrote:
Am 12.05.2015 um 19:53 schrieb Brian Barker:
At 12:45 12/05/2015 +0200, Honly Wonly wrote:
I need, of course, formulas to be case sensitive. This can be set in
the options for calc. The option is not sav
Am 12.05.2015 um 13:16 schrieb Gary Collins:
To make a formula that is case sensitive, you should be able to use the string functions
(I think) to convert to a known case before performing the comparison, e.g. if(UPPER(A1)
= "X";...)
That would make the formula case insensitive.
--
To unsu
Am 12.05.2015 um 19:53 schrieb Brian Barker:
At 12:45 12/05/2015 +0200, Honly Wonly wrote:
I need, of course, formulas to be case sensitive. This can be set in
the options for calc. The option is not saved permanently and every
time I open a spreadsheet, I need to set the option again.
I'm s
Am 12.05.2015 um 12:45 schrieb hw:
Hi,
I need, of course, formulars to be case sensitive. This can be set in
the options for calc. The option is not saved permanently and every
time I open a spreadsheet, I need to set the option again.
How can I save this option permanently so I don
Hi,
I need, of course, formulars to be case sensitive. This can be set in
the options for calc. The option is not saved permanently and every
time I open a spreadsheet, I need to set the option again.
How can I save this option permanently so I don't need to set it over
and over again?
Hi,
how can I add an image to a spreadsheet cell in such a way that when the
mouse pointer is over the image, a larger version of the image is displayed?
The larger, original version of the image resides on a web server. The
scaled down image is inserted into the spreadsheet with the
'inse
Am 07.04.2015 um 16:43 schrieb Brad Rogers:
On Tue, 07 Apr 2015 16:20:57 +0200
hw wrote:
Hello hw,
Is it entirely impossible to integrate images?
No.
Insert menu -> Image... -> From File...
Does it for me.
The image is created on demand with a cgi-script and is different for
Hi,
so far, I have had no success whatsoever with including images into
spreadsheets, texts or reports.
Such images either reside in a directory on a server and are accessible
via a samba share and http, or they are generated on the fly and
accessible via http.
Putting a hyperlink into a s
Am 23.03.2015 um 18:28 schrieb Brian Barker:
At 17:01 23/03/2015 +0100, Honly Wonly wrote:
Am 16.03.2015 um 18:07 schrieb Andreas Säger:
Am 16.03.2015 um 15:57 schrieb Honly Wonly:
Creating LO documents directly would be nice and might have the
advantage to be able to specify some formatting
Hi,
how can I put images into a report?
I have a query on a database that, amongst others, has a field with the
file name of an image. All images are stored in a particular directory,
so the relevant table in the database holds the file name of the image,
for example "abc.jpg". I need the i
Am 16.03.2015 um 18:07 schrieb Andreas Säger:
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
Am 19.03.2015 um 14:07 schrieb Andreas Säger:
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
Am 17.03.2015 um 21:34 schrieb Andreas Säger:
Am 17.03.2015 um 13:22 schrieb hw:
Ok, so I want to import data from a CSV file and would like to have some
formatting applied automatically, like specifying a particular width and
conditional formatting for some of the columns when I open the
Am 17.03.2015 um 21:41 schrieb Andreas Säger:
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
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 spreadsheet with the
data obtained from the
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 of the
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 of the import range.
You mean to the size
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 requirements.
That's partly becaus
Am 06.03.2015 um 15:44 schrieb Alexander Thurgood:
Le 06/03/2015 10:18, Andreas Säger a écrit :
Hi Andreas,
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
Am 06.03.2015 um 22:31 schrieb Andreas Säger:
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
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
Hi,
how would I create a spreadsheet from a table in a database?
I know I can copy and paste, and I want to avoid that. Basically, users
should be able to click an icon in LO (or on their desktop) and be
presented with a spreadsheet which displays an export from a table I
have in a mysql da
Am 25.02.2015 um 17:14 schrieb Regina Henschel:
Hi,
hw schrieb:
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
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 net
Am 21.02.2015 um 21:02 schrieb Andreas Säger:
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
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 macro(s) somewhere central for others to us
37 matches
Mail list logo