Re: [libreoffice-users] Re: Calc function

Den 18 april 2012 09:47 skrev Andreas Säger <villeroy@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
> > changes color to Red.......got that part.
> >
> > Then I want to manually enter that number somewhere into J4:N21. once
> > entered
> > into J4:N21, i want that number to erase from B4:G11.
> >
> > ideally at that point i would also like all remaining numbers in B4:G11 to
> > shift up, leaving no empty cells above cells with values in them (keeping
> > them
> > in the order entered within columns).
>
> Only a small set of features adds data to your spreadsheet and nothing in
> Calc will ever remove any data automatically. You have to do that by hand or
> by means of a macro program.
> It seems to be another inventory task which should be done in a database
> program of your choice. Later you may connect your database to this office
> suite (this is what the Base component does) and use Calc or Writer as
> "output medium" for pretty printing and further calculations.

I actually think it's possible with cell functions only, but I think
it would be quite complicated. Too complicated for me, anyway.

I did something else that I also thought was impossible first, but I
solved it eventually. It was not easy (for me) though… My task was to
create a list of things that is sorted automatically. The formulas
were quite long and hard to read…


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted