At 10:30 27/01/2016 +0700, Ken Heard wrote:
One setting I could not find was to change the footnote anchor. Is
it possible to use a symbol such as an asterisk instead of a number
as the anchor?
Yes: select Character (and insert the required character) instead of
Automatic in the Insert Footno
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 2016-01-27 03:35, Mirosław Zalewski wrote:
> How about Tools -> Footnotes/Endnotes... ? Are settings there the
> same in both documents?
No they were not. In Tools -> Footnotes/Endnotes for one of the
documents there was no period in the ‘After’
Yes there are two Tom
Menu/Tools/Options/LibreOffice calc/Formula - Formula Options - Formula
syntax.
and another one in
Menu/Tools/Options/LibreOffice calc/Formula - Detailed calculation settings
- Custom - Details - Reference syntax.
Miguel Ángel.
--
View this message in context:
http://n
Hi,
Some of the configurations you are referring to are done via the
regional settings (at least in the version of Excel I use): this means
that your separator may not always be the "!" in Excel (I have seen the
"." as well). When I need to have compatible workbooks (Excel and
Calc), I have a confi
Or if you have active regular expression (Menu/Tools/Options/LibreOffice
calc/Calculation)
=COUNTIF(C152:C228;"=H|K|Sze|Cs|P")
Inner help.
|Finds the terms that occur before the "|" and also finds the terms that
occur after the "|". For example, "this|that" finds "this" and "that".
Miguel
Hi :)
Isn't there a setting to change the way cells are addressed in Calc?
Something like;
Tools - Options - Calc
errr, somewhere in there? I think you have to be in Calc to get those
options.
Regards from
Tom :)
On Tuesday, 26 January 2016, Ian McCarthy wrote:
> On 1/26/2016 1:17 PM, Andreas
On 1/26/2016 1:17 PM, Andreas Säger wrote:
Am 26.01.2016 um 13:53 schrieb Ian McCarthy:
Hi I'm porting a spread sheet from Excel to LibreOffice Calc and I've
fallen over an incompatibility
as spread sheet will be used by both tools is there a switch I can use.
The problem
=CELL("filename",A1)
On Tue, 26 Jan 2016, Bob Holtzman wrote:
On Tue, Jan 26, 2016 at 12:29:54PM +, Tom Davies wrote:
Hi :)
Phil, i know you think you probably think you are just an atheist and
acting reasonably but this topic didn't arise in all the years that we
have seen Christian messages in various people'
How about Tools -> Footnotes/Endnotes... ? Are settings there the same
in both documents?
--
Best regards
Mirosław Zalewski
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + m
What I would do is to add a column, fill it with AND() statement to mark
row to add or not, hide it, then use a COUNTIF() using this column as a
condition.
As far as I know, the COUNTIFS() function should do the job but for some
reason I have difficulties to make it works right now :\ you might wa
Am 24.01.2016 um 09:04 schrieb Hank Alper:
> Hi Ian,
> I frequently import Calc Spreadsheets into my MySQL database using
> phpMyAdmin.. My version of phpMyAdmin asks to locate the File you wish to
> import.Specifically, it offers a Browse option. Locate the Calc file you
> wish to import.by browsi
I would suspicion you've uncovered a bug ;-)
From: Ken Heard
Date: Tue, Jan 26, 2016 at 4:39 AM
Subject: [libreoffice-users] Identical footnote settings work in one file
but not another
To: LibreOffice Users
I am using LO 4.3.3.2 with Debian wheezy. In two odt documents I have
added
On Tue, Jan 26, 2016 at 12:29:54PM +, Tom Davies wrote:
> Hi :)
> Phil, i know you think you probably think you are just an atheist and
> acting reasonably but this topic didn't arise in all the years that we
> have seen Christian messages in various people's signatures. The
> discussion only
Hi,
in a range I have characters: "H", "K", "Sze", "Cs", "P" so so in each cell
there is just one of these characters.
I want to count howmany cells are in a range that contains either of these
characters.
Can I do this in a more elegant way than by using this function bellow?
=COUNTIF(C152:C22
Le 24/01/2016 09:04, Hank Alper a écrit :
Hi Hank,
> Hi Ian,
> I frequently import Calc Spreadsheets into my MySQL database using
> phpMyAdmin.. My version of phpMyAdmin asks to locate the File you wish to
> import.Specifically, it offers a Browse option. Locate the Calc file you
> wish to impor
On 26 January 2016 at 12:42, Ian "Witty" Whitfield wrote:
> On 01/24/2016 10:04 AM, Hank Alper wrote:
>
>> Hi Ian,
>> I frequently import Calc Spreadsheets into my MySQL database using
>> phpMyAdmin.. My version of
>>
>> phpMyAdmin asks to locate the File you wish to
>> import.Specifically, it
On 01/24/2016 10:04 AM, Hank Alper wrote:
Hi Ian,
I frequently import Calc Spreadsheets into my MySQL database using
phpMyAdmin.. My version of phpMyAdmin asks to locate the File you wish to
import.Specifically, it offers a Browse option. Locate the Calc file you
wish to import.by browsing to it
Virgil,
On 2016-01-27 01:19, Virgil Arrington wrote:
Chill, Phil.
I can't believe the level of antagonism coming through your keyboard.
I'm "clueless" for not knowing Nasrin's gender? Harsh, man. While I
have many contacts with Muslims from around the world, I had never
heard the name Nasrin b
On Wed, 27 Jan 2016, Philip Rhoades wrote:
Sure - but I will still respond as I originally did if I come across more
proselytising (by anyone) . . it is inappropriate and offensive and should
not be condoned or encouraged.
by one standard definition of 'proselytize'/'proselytise' your last
s
Hi :)
I feel really bad now, that you seem to be forced into defending
yourself. And Virgil needing to defend himself doubtless with others
on all sides feeling more and more pushed into defending their views
or beliefs.
A belief-system that defines all other's beliefs as being
"superstitions" so
On 01/26/2016 09:02 AM, Larry Evans wrote:
> On 01/26/2016 08:42 AM, Larry Evans wrote:
>> On 01/26/2016 07:18 AM, Andreas Säger wrote:
>>> Am 26.01.2016 um 11:47 schrieb Larry Evans:
I've checked that the value returned by the YIELD function:
https://help.libreoffice.org/Calc/Financ
Tom,
On 2016-01-26 23:29, Tom Davies wrote:
Hi :)
Phil, i know you think you probably think you are just an atheist and
acting reasonably but this topic didn't arise in all the years that we
have seen Christian messages in various people's signatures. The
discussion only arose after the only I
On 01/26/2016 08:42 AM, Larry Evans wrote:
> On 01/26/2016 07:18 AM, Andreas Säger wrote:
>> Am 26.01.2016 um 11:47 schrieb Larry Evans:
>>> I've checked that the value returned by the YIELD function:
>>>
>>> https://help.libreoffice.org/Calc/Financial_Functions_Part_Two#YIELD
>>>
>>> can be gotten
Andy,
Have you cleared your user profile and allowed it to rebuild?
https://wiki.documentfoundation.org/UserProfile
That really is the first step.
Otherwise, seems like a problem with the registered temp folder.
Here is a clip of a correctly configured Tools -> Options -> Paths panel for
LO 5.
Virgil,
On 2016-01-27 01:19, Virgil Arrington wrote:
Chill, Phil.
I can't believe the level of antagonism coming through your keyboard.
I'm "clueless" for not knowing Nasrin's gender? Harsh, man. While I
have many contacts with Muslims from around the world, I had never
heard the name Nasrin b
Well said, Tom.
On Tue, 26 Jan 2016 12:29:54 +
Tom Davies wrote:
> Hi :)
> Phil, i know you think you probably think you are just an atheist and
> acting reasonably but this topic didn't arise in all the years that we
> have seen Christian messages in various people's signatures. The
> disc
On 01/26/2016 07:18 AM, Andreas Säger wrote:
> Am 26.01.2016 um 11:47 schrieb Larry Evans:
>> I've checked that the value returned by the YIELD function:
>>
>> https://help.libreoffice.org/Calc/Financial_Functions_Part_Two#YIELD
>>
>> can be gotten by using [Tools>Goal Seek...] and the PV function:
Some more information . If I try to open an .odt file in File Explorer
with Libre Office, I get "locked for editing by unknown user." I can
however open the file with Wordpad (though this is no use for editing.)
I can save a new file to one of the problem directories with Wordpad,
and also re-
Chill, Phil.
I can't believe the level of antagonism coming through your keyboard.
I'm "clueless" for not knowing Nasrin's gender? Harsh, man. While I have
many contacts with Muslims from around the world, I had never heard the
name Nasrin before and recalled nothing in her emails that betraye
At 12:53 26/01/2016 +, Ian McCarthy wrote:
I'm porting a spread sheet from Excel to LibreOffice Calc and I've
fallen over an incompatibility as spread sheet will be used by both
tools is there a switch I can use. The problem =CELL("filename",A1)
in LO returns 'file:///C:/Users/Ian
Mac/Desk
Dear Stuart,
Thank you for this very prompt reply.
Tools -> Options -> Paths entry for "Documents" is blank and I can't
edit it. (The others point to ok-looking appdata/roaming directories for
the correct user)
For My Documents, Explorer -> Properties -> Security for all users /
groups
Am 26.01.2016 um 11:47 schrieb Larry Evans:
> I've checked that the value returned by the YIELD function:
>
> https://help.libreoffice.org/Calc/Financial_Functions_Part_Two#YIELD
>
> can be gotten by using [Tools>Goal Seek...] and the PV function:
>
> https://help.libreoffice.org/Calc/Financial_
Am 26.01.2016 um 13:53 schrieb Ian McCarthy:
> Hi I'm porting a spread sheet from Excel to LibreOffice Calc and I've
> fallen over an incompatibility
> as spread sheet will be used by both tools is there a switch I can use.
> The problem
> =CELL("filename",A1) in LO returns
> 'file:///C:/Users/Ian
I've checked that the value returned by the YIELD function:
https://help.libreoffice.org/Calc/Financial_Functions_Part_Two#YIELD
can be gotten by using [Tools>Goal Seek...] and the PV function:
https://help.libreoffice.org/Calc/Financial_Functions_Part_One#PV
Is there some way I could use a som
Hi I'm porting a spread sheet from Excel to LibreOffice Calc and I've
fallen over an incompatibility
as spread sheet will be used by both tools is there a switch I can use.
The problem
=CELL("filename",A1) in LO returns
'file:///C:/Users/Ian Mac/Desktop/Accounts15-16.xls'#$Sep 15
where as in Ex
Launch as your normal user and have a look at the LibreOffice main menu Tools
-> Options -> Paths panel. Is it pointing to expected folder? Or, to
folders of the administrators group member user you used for the
installation?
If it is point to your user, but you can't edit--you may need to change
I just upgraded Libre Office to Version: 4.4.7.2 in Win 7 Home Premium and it
has wrecked all my file permissions. I can no longer save files ( "You do
not have permission to save here, do you want to save in Documents
instead?") or open them.
The problem may have come from the fact that you can
Amen
https://en.wikipedia.org/wiki/Amen
Met vriendelijke groeten, Salutations distinguées, Kind Regards,
DRIES FEYS
CORPORATE SERVICES • Specialist Software Developer
TVH GROUP NV
Brabantstraat 15 • BE-8790 WAREGEM
T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com
Watch our company movies on w
Hi :)
Phil, i know you think you probably think you are just an atheist and
acting reasonably but this topic didn't arise in all the years that we
have seen Christian messages in various people's signatures. The
discussion only arose after the only Islamic quote in all these years.
This has happe
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am using LO 4.3.3.2 with Debian wheezy. In two odt documents I have
added a footnote. In one case the number of the footnote at the
bottom of the page has a period after the number, but in the other
case there is no period there even though the set
40 matches
Mail list logo