On Wed, 18 Feb 2015 20:51:03 -0700 (MST)
V Stuart Foote vstuart.fo...@utsa.edu wrote:
Hello V,
You don't mention which branch of LibreOffice, but at 4.3 the Gallery
dialog has been moved exclusively to the Sidebar deck. Display of the
Not always: I'm using LO 4.3.3.2 under Debian (jessie) and
Hi Everyone!
Of course and first of all, many thanks to David Ostrovsky!!!
http://ostrovsky.org
I see the tinderbox is active!
http://dev-builds.libreoffice.org/daily/master/Win-x86_64@42/
Thanks to Florian Reisinger, I think!
I have learnt what a tinderbox is:
Hi.
What version of LO do you have . I have 4.2 and 4.3.
If I type 15 February 2015 into a cell it converts to a date (15/02/15
for me).
If I format a cell (say A2) as text and type 15 February 2015 into a
cell it shows 15 February 2015.
If I enter =DATEVALUE(A2) into cell B2 then I get a
If you right click FormatCellNumbers what comes up should be the
current formatting for the cell.
DATEVALUE() seems to work only on text. I can add spaces and remove
spaces without a problem but not add extraneous characters except using
a - as a single separator.
Steve
On 2015-02-20 06:26,
Brian. Thanks
Gee I wish it was that simple.
I reduced the font size from 10 to 6 changed the font style and increased the
column with to the rest of the page. While I do not get ### any longer, I now
see the formula =SUM(A1:A2). What is also interesting is on the format cells
menu, in the box
Best Sirs,
From mr Asaibene's message I think it is obvious -- at least we can
assume -- that he is rather familiar with using speadsheets (e.g. LO/Calc)
and knows the basics, he has reloaded the LO program -- and he described
a simple calculation that is all correct but showed the result that
Hi :)
I suspect editing and stuff got muddled there! From the general tone of
your email i suspect you meant
that the usual amount of time to develop a true 64 bit version (...) would
be IMMENSE and such a product would be incredibly costly arguments WERE
true.
After all it has taken a long
Hi Carlo
Thank you for the heads up on a x64 Win build.
carlo.strata wrote
I remember some our old others win64 discusses...
2013-11: http://nabble.documentfoundation.org/64-bit-tp4081444.html
Yes, I remember it too. I guess the fact that such a build exists is proof
that the usual amount of
Hi All
I've spent today trying to cure this problem.
I have only ONE table in my Database and needed to make the RecordID
field Auto-incrementing. (I forgot when I set it up)
Using the Base Front End it will *NOT* change the setting - as soon as
you save it reverts to 'No'
Using
Help.
I thought I was doing something wrong and have working on this situation for a
few days or nights.
I take two cells, create a formula in a third cell and the calculation results
in a ###.
First I thought it was a field not formatted for numbers. Tried formatting.
Closed Libre. Restarted
Doesn't it seem time that this become a new feature with a default setting.
-Automatically expand width of column.-
On 2/19/2015 9:18 AM, Brian Barker wrote:
At 08:57 19/02/2015 -0500, Dave Asaibene wrote:
I take two cells, create a formula in a third cell and the
calculation results in a ###.
I interpreted what you wrote to mean that =datevalue(a1) would convert the
contents of A1 into a date. It did not and produced err502. What am I
missing?
Thank you for helping so quickly :-)
Mark W. Howe
San Juan Capistrano, CA
949-496-3453 home/ office
949-525-3914 cell [not for
At 07:19 19/02/2015 -0800, Mark Howe wrote:
-Original Message- From: Brian Barker
Sent: Thursday, February 19, 2015 7:05 AM
Subject: Re: [libreoffice-users] Formatting a date
At 06:41 19/02/2015 -0800, Mark Howe wrote:
I have text: 19 February 2015. The format for the cell is date
I'm pointing the obvious, but anyway...
### as a formula result usually mean that the cell is too narrow for the
result to be displayed. Is that a possibility here?
--
Cley Faye
http://cleyfaye.net
2015-02-19 14:57 GMT+01:00 Dave Asaibene dasaib...@icloud.com:
Help.
I thought I was doing
At 08:57 19/02/2015 -0500, Dave Asaibene wrote:
I take two cells, create a formula in a third cell and the
calculation results in a ###.
As you can see from the help text (under ### error message), this
means The cell is not wide enough to display the contents. You need either to
o
At 06:41 19/02/2015 -0800, Mark Howe wrote:
I have text: 19 February 2015. The format for the cell is date
2/19/2015, but it will not acknowledge that or sort correctly. As if
it's formatted for date but not accepting that fact. What did I do wrong?
o If you format a cell as Date and then
Dear Brian,
Thank you for suggestions.
If you want URLs to be automatically detected and converted to hyperlinks,
you need to have the option(s) ticked at Tools | AutoCorrect Options... |
Options | URL Recognition.
That answers my question. Problem solved. Thank you.
Taang Zomi
On Wed, Feb
What you're describing sort of sounds like the feature that prevent
computing formula if the file originate from another office suite if it
could cause issues, but that's probably not it as it should not prevent you
from typing new formula.
Could you upload such problematic file somewhere so we
At 15:11 19/02/2015 -0500, Dave Asaibene wrote:
On 2/19/2015 9:18 AM, Brian Barker wrote:
At 08:57 19/02/2015 -0500, Dave Asaibene wrote:
I take two cells, create a formula in a third cell and the
calculation results in a ###.
As you can see from the help text (under ### error message),
At 22:51 19/02/2015 +0200, Pertti Rönnberg wrote:
From mr Asaibene's message I think it is
obvious -- at least we can assume -- that he is
rather familiar with using spreadsheets (e.g.
LO/Calc) and knows the basics, ...
I don't want to be overcritical of the original
questioner, but I
On Feb 19, 2015, at 5:27 PM, Brian Barker b.m.bar...@btinternet.com wrote:
At 22:51 19/02/2015 +0200, Pertti Rönnberg wrote:
From mr Asaibene's message I think it is obvious -- at least we can assume
-- that he is rather familiar with using spreadsheets (e.g. LO/Calc) and
knows the
Further to the formatting of cells/columns to hold dates (Format - Cells:
Category Dates)
which then have a configurable display format.
The date pattern acceptance formats can be extended (Tools - Options -
Language Settings - Languages: Language Of Date acceptance patterns)
Beyond defaults,
Hi :)
Superb :)) Nicely done!
Congrats for fixing it! :)
Regards from
Tom :)
On 19 February 2015 at 15:15, Taang Zomi libreofficez...@gmail.com wrote:
Dear Brian,
Thank you for suggestions.
If you want URLs to be automatically detected and converted to hyperlinks,
you need to have the
2015-02-17 8:58 GMT+01:00 Brian Barker b.m.bar...@btinternet.com:
At 19:09 16/02/2015 -0700, Dave Kidd wrote:
I do not see an option to select/unselect which components to install.
Here is what the Custom Setup screen looks like for me when I run the
installer.
Yeah, I tho't of that and tried changing it around to 14 Jan 2014.
The only thing that worked was changing it to Jan 14 2014 and then it worked
automatically in it’s own column making the exercise with datevalue of no value.
14 Jan 2014 Err:502
01/10/14 Err:502
01/02/14
I have text: 19 February 2015. The format for the cell is date 2/19/2015, but
it will not acknowledge that or sort correctly.
As if it’s formatted for date but not accepting that fact.
What did I do wrong? [I am not currently subscribed to the list; sorry]
Mark W. Howe
San Juan Capistrano, CA
Dear Tom,
Thank you very much for your suggestions.
Taang Zomi
On Wed, Feb 18, 2015 at 8:01 PM, Tom Davies tomc...@gmail.com wrote:
Hi :)
When you type an internet address and then put a full stop after it that
full-stop sometimes gets included in the address so that people clicking on
Hi :)
So it's picking up the USA locale for it's input? I thought LibreOffice
could have it's own locale as somethign different from the system's one?
Regards from
Tom :)
On 19 February 2015 at 17:26, Mark Howe markh...@cox.net wrote:
Yeah, I tho't of that and tried changing it around to 14
I was able to fool it by using what you all taught me with ‘concatenate’. I
split it into 3 cols with the space, then switch the cols and concatenate back
to MM DD . However I do not understand why an international program like
LiebreOffice cannot recognize DD MM .
Mark W. Howe
Fixed!
Thanks
The Formula check box was ticked as Brian indicated. It was a little difficult
getting back to this since clicking Preferences did not give me the option to
look at the Calc setting Preferences which was indicated via the Help menus.
however getting back to the basic sheet, then
30 matches
Mail list logo
