I am trying to automatically remove a number from a range of cells, if it
appears in a different range.
I am creating a spreadsheet where once a number appears in B4:G11 4 times, it
changes color to Red...got that part.
Then I want to manually enter that number somewhere into J4:N21. once
Hi Tim,
Le 2012-04-17 15:10, webmaster-Kracked_P_P a écrit :
Marc, I have not kept up with this thread.
If you mean opening a .odt file from an online source in Firefox,
[instead of saving to the disk] like it use to do a few months back, I
remember the last 2 or 3 times with Firefox 10 and
Am 17.04.2012 19:35, Mike Phelan wrote:
I am trying to automatically remove a number from a range of cells, if it
appears in a different range.
I am creating a spreadsheet where once a number appears in B4:G11 4 times, it
changes color to Red...got that part.
Then I want to manually enter
Le 17/04/12 18:14, Andreas Säger a écrit :
Hi all,
The easiest improvements in my honest opinion:
- Wipe out the .odb container all together and get back to the
configuration of database access in OOo 1. Back to external databases
with configuration data in configuration files, forms and
Le 17/04/12 20:13, ptoye a écrit :
Is there any point in suggesting that LibO and OO should continue to
diverge? I'd have thought convergence would be more productive, both in
terms of the development which seems too thinly spread, and for users who
might even see a serious contender
Le 17/04/12 11:28, Ian Whitfield a écrit :
Hi Ian,
While I might agree with your statements with regard to the integrated
use of HSQLDB, I would differ with regard to hooking up Base to various
server backends, which in my experience do work rather well on the
whole, albeit with tweaking, and
Hi :)
I think Kexi and the rest of Calligra/KOffice has a Windows version just as
LibreOffice does. Calligra/KOffice uses ODF natively and presumably can use MS
formats although i'm not sure quite how well.
Regards from
Tom :)
--- On Wed, 18/4/12, Alexander Thurgood alex.thurg...@gmail.com
Le 17/04/12 06:26, frofa a écrit :
Hi,
In LO 3.5 when I click on a particular legacy report to run it, the expected
window saying Connecting to data source Importing data opens for a
brief instant, then disappears, leaving just the window with the report
template layout showing...but
On 18/04/2012 11:17, Alexander Thurgood wrote:
Le 17/04/12 11:28, Ian Whitfield a écrit :
Hi Ian,
While I might agree with your statements with regard to the integrated
use of HSQLDB, I would differ with regard to hooking up Base to various
server backends, which in my experience do work
Hi :)
The divergence has resulted in at least a doubling of the numbers of people
working on the project(s). The projects do have a lot of overlap and share a
lot. People that were colleagues working alongside each other may find
themselves split into different projects but still chatting and
Tom wrote:
How do you do that if your system (openSuSE 12.1) only allows two (2) key
composition?
I didn’t think there was such a restriction. I have a custom compose
list (on Ubuntu), and I just created a three-key combination, and it
works.
Is this something unique to SUSE (which seems
Hi :)
That sounds much easier for data-input and normal look-up use for normal users
that are barely familiar with Word/Writer and Calc/Excel.
Most normal office workers seem scared of using databases for even low level
tasks. This style of use takes away the scary front-end and gives them
Hi :)
That is exactly why i wondered if Andreas' points could be worked on while
leaving the existing package, Base, as it stands.
That way the database functionality could be moved forwards while leaving the
kludgy mess (ok, it might not be a kludge from a coders pov) to get sorted
'later'.
Hi :)
For bug-reporting these 2 guides end-up with roughly the same result. Noobs to
OpenSource might prefer the 2nd link but i suspect you might prefer the 1st one
http://wiki.documentfoundation.org/BugReport
https://www.libreoffice.org/get-help/bug/
I'm glad to hear most of your crashing is
Hi people,
First of all thanks a lot for the hard work you are carrying out.
Few weeks ago I found and issue using LibreOffice Draw product, basically
the issue is i don't see anything in the main window... looks like the
rendering is not working well on my computer. Details as follow:
Product
Hi :)
The question is a moving target and seems to be moving in our favour. More
people are using LO/OOo now even if it's often alongside MSO.
Also it's about how much power and control you have. There are many
circumstances where you are totally at the mercy of other people and have to
Hi :)
My GnuLinux repos give me a
mozilla-OpenOffice
plugin but the repos are set-up so that i would have to install OOo to be able
to use it. I think it should be grabbed, modified for LO and put on LO's
Extensions website
Regards from
Tom :)
--- On Tue, 17/4/12, webmaster-Kracked_P_P
On 4/17/12 6:01 AM, webmaster-Kracked_P_P wrote:
Most government agencies [USA] at all
levels are not allowed to use any other office package but MSO AND are
forbidden to install software on their computers, including
screen-savers and such.
It can be misleading to say something like this
I think Andreas' approach for end users is a very good idea.
I think, furthermore, that it starts to redefine how databases can be
used. that's a good thing and going dowm that track will, I'm sure,
lead to further developments.
As such, yes, I think it would be a great idea to push that
I'm almost thinking of installing something like MySQL and writing my own
front-end in Java.
I'm sorry if I'm being slow, or not following the conversation properly (lots
going
on here at the moment), but, if you're thinking like that, what's wrong with
Base?
The things you'd need to do,
On 2012-04-17 8:01 AM, webmaster-Kracked_P_P
webmas...@krackedpress.com wrote:
Well, it is always good to promote ODF, but if you work in a business
environment, you cannot get away from MSO's file formats. I create the
documents in LO and save my copy in ODF, but I still have to send
editable
On 2012-04-17 6:56 PM, e-letter inp...@gmail.com wrote:
You could send in odf, which m$ is supposed to support. Growth in the
quantity of odf documents, together with people complaining to m$
(instead of complaining to LO!), the long term effect is to force m$
to improve compatibility with odf,
Am 17.04.2012 13:50, e-letter wrote:
Readers,
M$ is allegedly seeking to invest in interoperability and open
source:
http://www.infoworld.com/d/open-source-software/microsoft-forms-subsidiary-engage-open-source-communities-190790.
Perhaps more for 'Groklaw', but isn't this a potential trojan
Hello,
I just installed the LO version 3.5.2, and Magenta's Lorem Ipsum
extension 'sticks' in full screen mode. (Windows 7 64-Bit)
I tried reinstalling the extension but it did not resolve the problem.
http://imagebin.org/208618 (installed)
http://imagebin.org/208619
Hi Manfred,
Thanks a lot for your quick response!!
So I've tried as best as I can to replicate what you've suggested.
Unfortunately, I can't seem to make the fat check mark appear anywhere.
For example, post-restart, I see under Tools Options Language Settings
Languages:
On Tue, 2012-04-17 at 12:50 +0100, e-letter wrote:
Readers,
M$ is allegedly seeking to invest in interoperability and open
source:
http://www.infoworld.com/d/open-source-software/microsoft-forms-subsidiary-engage-open-source-communities-190790.
Oh, whatever. And this sent from a gmail
Hi Christian,
On Wed, Apr 18, 2012 at 4:24 PM, cbkschroeder [via Document Foundation Mail
Archive] ml-node+s969070n3920136...@n3.nabble.com wrote:
Hi Manfred,
Thanks a lot for your quick response!!
So I've tried as best as I can to replicate what you've suggested.
Unfortunately, I can't
Intermediate free software required.
It appears to be time for an intermediate translation software be made
available.
Similar to those that change image types between png, jpg and tiff.
The idea is a free translation software that sits in between the file
and the program calling for the
Hi :)
+1
but if we keep gently pushing, where we can, things will keep making progress.
It does help to have louder campaigners such as FSF and Richard Stallman. It
would be great if e-letter could join FSF if he/she hasn't already.
Regards from
Tom :)
--- On Wed, 18/4/12, Tanstaafl
Den 18 april 2012 09:47 skrev Andreas Säger ville...@t-online.de:
Am 17.04.2012 19:35, Mike Phelan wrote:
I am trying to automatically remove a number from a range of cells, if it
appears in a different range.
I am creating a spreadsheet where once a number appears in B4:G11 4 times,
it
Hi :)
Interestingly apparently many US government agencies and departments use
GnuLinux for most of their server-side and infra-structure but had to cave
into users demands for MS on their desktops.
An interesting quiet little press release appeared on the DistroWatch website a
few days ago.
Do me a favor, try using this Canadian English dictionary. [en-CA]
http://libreoffice-na.us/English-3.4-installs/add-on-dictionaries-large-list/kpp-canadian-english-dictionary-638K-word-list.oxt
See if it over-writes some of the default files for you enough for it
to work for your needs.
Den 17 april 2012 22:32 skrev Thomas Taylor li...@comcast.net:
On Tue, 17 Apr 2012 18:09:31 +0200
Johnny Rosenberg gurus.knu...@gmail.com wrote:
Den 16 april 2012 22:36 skrev Séamas Ó Brógáin s...@iol.ie:
Regina wrote:
They are usually written via AutoCorrect. The simple hyphen is
Den 18 april 2012 02:12 skrev Thomas Taylor li...@comcast.net:
On Tue, 17 Apr 2012 10:48:22 +0100
Séamas Ó Brógáin s...@iol.ie wrote:
Doug:
Using the compose key, the default settings are:
dash (em rule) ---
en rule: --.
How do you do that if your system
Den 18 april 2012 18:19 skrev Johnny Rosenberg gurus.knu...@gmail.com:
Den 18 april 2012 02:12 skrev Thomas Taylor li...@comcast.net:
On Tue, 17 Apr 2012 10:48:22 +0100
Séamas Ó Brógáin s...@iol.ie wrote:
Doug:
Using the compose key, the default settings are:
dash (em rule) ---
Even Micro$oft Windoze has keyboards using the AltGr.
For a list of available keyboard layouts in Windoze:
http://msdn.microsoft.com/en-us/goglobal/bb964651
An example of a U.S. English (US-International) keyboard layout which
uses the AltGr:
On Wed, 18 Apr 2012 18:10:18 +0200
Johnny Rosenberg gurus.knu...@gmail.com wrote:
Den 17 april 2012 22:32 skrev Thomas Taylor li...@comcast.net:
On Tue, 17 Apr 2012 18:09:31 +0200
Johnny Rosenberg gurus.knu...@gmail.com wrote:
Den 16 april 2012 22:36 skrev Séamas Ó Brógáin s...@iol.ie:
On Wed, 18 Apr 2012 18:10:18 +0200
Johnny Rosenberg gurus.knu...@gmail.com wrote:
Den 17 april 2012 22:32 skrev Thomas Taylor li...@comcast.net:
On Tue, 17 Apr 2012 18:09:31 +0200
Johnny Rosenberg gurus.knu...@gmail.com wrote:
Den 16 april 2012 22:36 skrev Séamas Ó Brógáin s...@iol.ie:
Am 18.04.2012 17:56, Johnny Rosenberg wrote:
Den 18 april 2012 09:47 skrev Andreas Sägerville...@t-online.de:
Am 17.04.2012 19:35, Mike Phelan wrote:
I am trying to automatically remove a number from a range of cells, if it
appears in a different range.
I am creating a spreadsheet where once
Hi :)
Before Linux most of those servers would probably have been using Unix. A fair
percentage moved from Unix to Bsd too. There are apparently other unix-based
OSes out there and a few other odd ones that form almost all the remaining
percentage.
Regards from
Tom :)
--- On Wed, 18/4/12,
On 04/18/2012 12:19 PM, Johnny Rosenberg wrote:
Den 18 april 2012 02:12 skrev Thomas Taylorli...@comcast.net:
On Tue, 17 Apr 2012 10:48:22 +0100
Séamas Ó Brógáins...@iol.ie wrote:
Doug:
Using the compose key, the default settings are:
dash (em rule) ---
en rule:--.
On 4/18/12 12:20 PM, Tom Davies wrote:
Before Linux most of those servers would probably have been using Unix. A fair
percentage moved from
Unix to Bsd too. There are apparently other unix-based OSes out there
and a few other odd ones that
form almost all the remaining percentage.
That
On 04/18/2012 01:30 PM, Thomas Taylor wrote:
On Wed, 18 Apr 2012 18:10:18 +0200
Johnny Rosenberggurus.knu...@gmail.com wrote:
Den 17 april 2012 22:32 skrev Thomas Taylorli...@comcast.net:
On Tue, 17 Apr 2012 18:09:31 +0200
Johnny Rosenberggurus.knu...@gmail.com wrote:
Den 16 april 2012
Hi :)
It is quite possible that openSuSE don't allow 3 character sequences. They are
one of the longest running distros that are still active and they tend to go
their own way. I get the impression they aim slightly more at corporate users
and offer better traditional forms of tech-support
Hi, I have an ODS file that I am not able to open. It is a spreadsheet
file that I have been using daily since the first of the year. I have
opened it and updated it every day since the first of January. Yesterday
when I tried to open it, Libreoffice opened properly; then I got a Filter
Hi.
Is it possible to SUM across sheets without having to name each sheet.
i.e. something like SUM(Sheet5.E4:Sheet9.E4) instead of
SUM(Sheet5.E4,Sheet6.E4,Sheet7.E4,Sheet8.E4,Sheet9.E4)
My sheets are named Bill, Bob, Tom Dick and Harry.
Bill is Sheet5 SUM(Sheet5.E4:Sheet9.E4) doesn't work.
Hi Steve,
Steve Edmonds schrieb:
Hi.
Is it possible to SUM across sheets without having to name each sheet.
i.e. something like SUM(Sheet5.E4:Sheet9.E4) instead of
SUM(Sheet5.E4,Sheet6.E4,Sheet7.E4,Sheet8.E4,Sheet9.E4)
My sheets are named Bill, Bob, Tom Dick and Harry.
Bill is Sheet5
On 18 April 2012 16:57, Steve Edmonds steve.edmo...@ptglobal.com wrote:
Is it possible to SUM across sheets without having to name each sheet.
i.e. something like SUM(Sheet5.E4:Sheet9.E4) instead of
SUM(Sheet5.E4,Sheet6.E4,Sheet7.E4,Sheet8.E4,Sheet9.E4)
Example: =SUM(Sheet1.A1:Sheet2.C6) --
Hi :)
Can you upload the ods to Nabble so that we can have a look? Note that this
is a public access list so don't upload it if it's confidential. Just
follow the links to Nabble and reply to one of the posts in the right thread
and then click on the More button. Upload is the 1st option and
On 2012-04-19 10:09, T. R. Valentine wrote:
On 18 April 2012 16:57, Steve Edmondssteve.edmo...@ptglobal.com wrote:
Is it possible to SUM across sheets without having to name each sheet.
i.e. something like SUM(Sheet5.E4:Sheet9.E4) instead of
unable to open this file
http://nabble.documentfoundation.org/file/n3921824/2012_taxes.ods
2012_taxes.ods
--
View this message in context:
http://nabble.documentfoundation.org/Trouble-opening-ODS-file-in-LibreOffice-tp3921408p3921824.html
Sent from the Users mailing list archive at
I get 1.5 kB and empty.
steve
On 2012-04-19 12:46, trickydicky wrote:
unable to open this file
http://nabble.documentfoundation.org/file/n3921824/2012_taxes.ods
2012_taxes.ods
--
View this message in context:
52 matches
Mail list logo