Just some feedback for the Devs on an install problem which I have managed to
workaround - so no reply necessary - unless the Devs want further details.
System: Acer X1420 - AMD Athlon dual core CPU / 4GB RAM, running Windows 8.1.
I downloaded the install file on two occasions - both
At 10:17 11/01/2014 -0800, James E Lang wrote:
Please fill in the blank (___) below with a function name or tell
me there is no such function:
SUM(range) is to SUMIF(range1,criteria,range2) as COUNT(range) is to
___(range1,criteria,range2)
COUNTIF would seem to be the logical answer but I
Thanks som
I redid the arrangement of some of the colors in the original large
color file and put that in the ownCloud folder. Plus I added a few more
colors I found.
I found Hex codes for colors like
Silver, Copper, Wood, etc..
So I added it to the second one.
I found a set of Hex codes
Happy New Year Dear LibO experts,
Since years back I have copied my bank's digital listing of my bank
account(s); first using MSOWord and later on MSOExcel.
My intension is to transform these listings so I can calculate with the
currency values in LibO-Calc.
The bank's table has four cols:
I haven't so much tried to answer your question directly, instead I
attempted to solve the same problem you did. For me, this gives a
simpler answer. Given:
Col A: The initial bank value as text
Col B: =IF(RIGHT(A1,1)=-,Debit,Credit)
Col C: =LEN(A1)
Col D: =LEFT(A1,C1-1)
Col E: =FIND(,,D1)
Col F:
Is there a way to get spell check to ignore website addresses?
--
View this message in context:
http://nabble.documentfoundation.org/Get-spell-check-to-ignore-website-addresses-tp4091851.html
Sent from the Users mailing list archive at Nabble.com.
--
To unsubscribe e-mail to:
On 09/01/14 15:36, Tom Davies wrote:
Hi :)
It might be worth contacting the openSuSE forums to ask in there,
http://forums.opensuse.org/
errr, right now their forums are down for maintenance but will
probably be up by the time you read this. Jic it isn't this wiki
might be more help
2014/1/12 John King johnmking...@yahoo.co.uk
On 09/01/14 15:36, Tom Davies wrote:
Hi :)
It might be worth contacting the openSuSE forums to ask in there,
http://forums.opensuse.org/
errr, right now their forums are down for maintenance but will
probably be up by the time you read this.
Additionnaly, how did you install LibreOffice on your system? Did you use
some distribution-specific repositories, or got it from the Libreoffice
website ? Maybe there is something opensuse-specific that cause this. If it
doesn't happen with the version downloaded from the website, you'll have to
I inadvertently created a Default Template.
It arrived very time I opened Writer, so in Manage Templates I deleted it.
Now when I open Writer I get the following Message:
Users/jt/Library/Application
Support/LibreOffice/4/user/template/LettersJT.ott does not exist.
It is still calling for the
I have downloaded a c,s.v file from my Bank and created a Template for the
Bank listing.
I can load the Bank file into a new Spreadsheet and I then have to reformat
it.
Why can I not Import it into the Template, or is there another way?
Tink.
--
View this message in context:
On 12-01-2014 20:38, Cley Faye wrote:
Additionnaly, how did you install LibreOffice on your system? Did you use
some distribution-specific repositories, or got it from the Libreoffice
website ? Maybe there is something opensuse-specific that cause this. If it
doesn't happen with the version
Running LO 3.5.7.2 on Ubuntu 12.04
If I have cells:
A1 = 2
A2 = 2
A3 = 2
A4 = =SUM(A1:A3) which equals 6
If I right click on the number 2 to the left of cell A2 to select that
row and then insert a row from the popup menu and enter the number 2 in
that blank cell, I get:
A1 = 2
I do not know whether this was correct, but I made Writer Untitled 1 my
Default Template.
Tink.
--
View this message in context:
http://nabble.documentfoundation.org/Default-Template-tp4091871p4091886.html
Sent from the Users mailing list archive at Nabble.com.
--
To unsubscribe e-mail to:
Maybe this option can help:
Menu/Tools/Options/LibreOffic calc/General - Expand references when new
columns/rows are inserted.
Miguel Ángel.
--
View this message in context:
http://nabble.documentfoundation.org/Inserting-a-row-does-not-change-formula-tp4091882p4091887.html
Sent from the
Tinkerer wrote:
I have downloaded a c,s.v file from my Bank and created a Template for the
Bank listing.
I can load the Bank file into a new Spreadsheet and I then have to reformat
it.
Why can I not Import it into the Template, or is there another way?
Templates are used to create
On 01/12/2014 03:34 PM, mariosv wrote:
Maybe this option can help:
Menu/Tools/Options/LibreOffic calc/General - Expand references when new
columns/rows are inserted.
Miguel Ángel.
Thank you, that worked.
I'm curious why without that setting I can insert a row in the middle of
a column of
James
That is exactly what I am trying to do.
I open the CSV Template then I go to Insert Sheet from File OK and it
creates another sheet either before or after the sheet from the Template.
I finish up with a two sheet file, one sheet Formatted and the other sheet
with the Bank info.
What I want
Hi :)
Excel does exactly the same thing. When i show/train people to use
spreadsheets i try to get them to make the row above the totals row
much smaller so that people leave that row blank. Generally people
don't have time for that sort of thing and then have to spend hours
trying to work out
On Sun, 12 Jan 2014 14:52:25 -0800 (PST)
Tinkerer j_taylo...@btinternet.com wrote:
James
That is exactly what I am trying to do.
I open the CSV Template then I go to Insert Sheet from File OK and it
creates another sheet either before or after the sheet from the Template.
Tink,
You aren't
At 11:51 12/01/2014 -0800, J Taylor wrote:
I inadvertently created a Default Template. It arrived very time I
opened Writer, so in Manage Templates I deleted it. Now when I open
Writer I get the following Message:
Users/jt/Library/Application
Support/LibreOffice/4/user/template/LettersJT.ott
At 12:12 12/01/2014 -0800, J Taylor wrote:
I have downloaded a c,s.v file from my Bank and created a Template
for the Bank listing. I can load the Bank file into a new
Spreadsheet and I then have to reformat it. Why can I not Import it
into the Template, or is there another way?
At 14:52
Tinkerer wrote:
That is exactly what I am trying to do.
I open the CSV Template then I go to Insert Sheet from File OK and it
creates another sheet either before or after the sheet from the Template.
I finish up with a two sheet file, one sheet Formatted and the other sheet
with the Bank
At 17:55 12/01/2014 +0200, Pertti Rönnberg wrote:
Since years back I have copied my bank's digital
listing of my bank account(s); first using
MSOWord and later on MSOExcel. My intention is
to transform these listings so I can calculate
with the currency values in LibO-Calc. The
bank's table
24 matches
Mail list logo