Help - Open Office Gurus Please

ferring seagull

Well-known member

Dec 30, 2010

4,607

• Jul 8, 2017

• #1

Open Office Spreadsheet, I am trying to make use of the predictive function ( in the same column in the spreadsheet having already loaded the options as parameters in that column.

It seems to work sometimes and not others. Can anyone suggest what I may be missing here ?

And yes, I have tried turning it off and turning it on again !

Any help would be much appreciated.

 

P

PeterOut

Well-known member

Aug 16, 2016

1,238

• Jul 8, 2017

• #2

"trying to make use of the predictive function" - I am not sure what you mean by that.
Can you post a screenshot of a sample of your sheet, or give a description of what it is you are trying to do? Which Function are you using - an in-built one, or an externally-supplied one? Or are you simply trying to get auto-complete to behave nicely?

 

ferring seagull

Well-known member

Dec 30, 2010

4,607

• Jul 8, 2017

• Thread starter
• #3

PeterOut said:

"trying to make use of the predictive function" - I am not sure what you mean by that.
Can you post a screenshot of a sample of your sheet, or give a description of what it is you are trying to do? Which Function are you using - an in-built one, or an externally-supplied one? Or are you simply trying to get auto-complete to behave nicely?

Click to expand...

Thanks PO, trouble is I'm not sure which function I should be using or disabling.

In a spreadsheet where there are recurring items, I want them to 'autofill' which in some spreadsheets they do but not in others. I am referring to this function in a column within a spreadsheet where all the 'possibilities' are already in that column (albeit at the bottom of the likely usage)

The strange thing is that it seems to work sometimes but not others which makes we think I may have inadvertently switched something ON or OFF without realising it.

So, as you say, trying to get autocomplete nicely may be the answer.

Grateful if you can suggest anything and thanks !

 

B

BensGrandad

New member

Jul 13, 2003

72,015

Haywards Heath

• Jul 8, 2017

• #4

Have you tried the Open Office forum? May be worth a try.

 

BN9 BHA

DOCKERS

NSC Patron

Jul 14, 2013

21,521

Newhaven

• Jul 8, 2017

• #5

BensGrandad said:

Have you tried the Open Office forum? May be worth a try.

Click to expand...

All that asking for advice on here has paid off, you are now an Open Office GURU I see.

 

dazzer6666

Well-known member

NSC Patron

Mar 27, 2013

52,346

Burgess Hill

• Jul 8, 2017

• #6

ferring seagull said:

Open Office Spreadsheet, I am trying to make use of the predictive function ( in the same column in the spreadsheet having already loaded the options as parameters in that column.

It seems to work sometimes and not others. Can anyone suggest what I may be missing here ?

And yes, I have tried turning it off and turning it on again !

Any help would be much appreciated.

Click to expand...

Don't worry, we're all struggling with the new loyalty points system..........

 

B

BensGrandad

New member

Jul 13, 2003

72,015

Haywards Heath

• Jul 8, 2017

• #7

bn9 bha said:

All that asking for advice on here has paid off, you are now an Open Office GURU I see.

Click to expand...

Not really I just ask them as you dont get the know it alls telling you what an idiot you are, but it takes all sorts to make a world.

 

BN9 BHA

DOCKERS

NSC Patron

Jul 14, 2013

21,521

Newhaven

• Jul 8, 2017

• #8

BensGrandad said:

Not really I just ask them as you dont get the know it alls telling you what an idiot you are,.

Click to expand...

Sounds dull to me

 

P

PeterOut

Well-known member

Aug 16, 2016

1,238

• Jul 8, 2017

• #9

"When making an entry in a cell, OpenOffice Calc automatically suggests matching input found in the same column. This function is known as AutoInput.
To turn the AutoInput on and off, set or remove the tick mark in front of Tools - Cell Content - AutoInput."
From the Help file in OpenOffice.

If it works in some sheets, but not in others, check the settings in each sheet individually - I believe that each has it's own settings 'tied in' to that sheet?

 

P

PeterOut

Well-known member

Aug 16, 2016

1,238

• Jul 8, 2017

• #10

Alternatively, if you know that you will only ever be filling values / data from a known and fixed list, consider using a 'List Box' - it will offer a list of the 'correct answers' and you just pick the one you want. It makes life a lot easier later, when you realise you have not spelled the same value 3 different ways ...
Just search for 'list box' in Help for info on how to do this.

 

ferring seagull

Well-known member

Dec 30, 2010

4,607

• Jul 9, 2017

• Thread starter
• #11

PeterOut said:

"When making an entry in a cell, OpenOffice Calc automatically suggests matching input found in the same column. This function is known as AutoInput.
To turn the AutoInput on and off, set or remove the tick mark in front of Tools - Cell Content - AutoInput."
From the Help file in OpenOffice.

If it works in some sheets, but not in others, check the settings in each sheet individually - I believe that each has it's own settings 'tied in' to that sheet?

Click to expand...

Thanks for that !
The function doesn't work from 'imported' data which is what I hadn't taken into account ie. ignores cells where the data is coming from a separate Worksheet, eg. = Sheet2.a5.
Silly me !

 

P

PeterOut

Well-known member

Aug 16, 2016

1,238

• Jul 9, 2017

• #12

Glad you got it sorted