Issue 126974 - Trying to change a cell and getting error message
Summary: Trying to change a cell and getting error message
Status: UNCONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 4.1.2
Hardware: PC Windows 10
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2016-05-17 10:39 UTC by Mark
Modified: 2017-05-20 11:53 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description Mark 2016-05-17 10:39:55 UTC
The error message that pops up says
"Too old to sell, get out"
Comment 1 orcmid 2016-05-17 15:56:08 UTC
(In reply to Mark from comment #0)
> The error message that pops up says
> "Too old to sell, get out"

What is the name of the spreadsheet file you are attempting to change a cell in?

The error message is not one supplied by Apache OpenOffice.  It is probably supplied by the spreadsheet you are using, either directly or indirectly.

You should check with the source of the spreadsheet file.  We cannot provide further advice without (1) a copy of the file and (2) a description of the change you are attempting -- what cell, what are you attempting to enter, etc.  A readable screen capture of the complete pop-up (including any border text and titles) would also be useful.
Comment 2 orcmid 2016-05-17 15:56:48 UTC
Setting needmoreinfo keyword
Comment 3 Mark 2016-05-17 16:02:33 UTC
(In reply to orcmid from comment #2)
> Setting needmoreinfo keyword

Hi, thanks for the response.

The cell is to change how many years someone would take to pay off a policy. It then works out how much they need to pay per month.

When we try to change that cell, that message pops up.

hope that helps?
Comment 4 Marcus 2016-05-17 17:01:56 UTC
@Mark:
In any case I think we need to see this on our own. So, please attach the spreadsheet to this issue. If you have some sensible data that should be kept secret, then first please replace it with some dummy data and make sure that the issue is still occuring.

Thanks
Comment 5 orcmid 2016-05-17 20:01:50 UTC
(In reply to Mark from comment #3)
> (In reply to orcmid from comment #2)
> > Setting needmoreinfo keyword
> 
> Hi, thanks for the response.
> 
> The cell is to change how many years someone would take to pay off a policy.
> It then works out how much they need to pay per month.
> 
> When we try to change that cell, that message pops up.
> 
> hope that helps?

This is a validation condition provided by the creator of the spreadsheet.  We can look at it, as Marcus suggests, but you need to work this out with the creator.

Again, what is the name of the file, including its extension?  If it is an Excel file, we can't help at all.  If it is a Calc .ods file, we can confirm how the message arises, but you need to provide the file and also the entry you are attempting to make.
Comment 6 Kay 2016-05-17 22:40:34 UTC
(In reply to orcmid from comment #5)
> (In reply to Mark from comment #3)
> > (In reply to orcmid from comment #2)
> > > Setting needmoreinfo keyword
> > 
> > Hi, thanks for the response.
> > 
> > The cell is to change how many years someone would take to pay off a policy.
> > It then works out how much they need to pay per month.
> > 
> > When we try to change that cell, that message pops up.
> > 
> > hope that helps?
> 
> This is a validation condition provided by the creator of the spreadsheet. 
> We can look at it, as Marcus suggests, but you need to work this out with
> the creator.

Yes. We are not in a position to fix old customizations like this.

> 
> Again, what is the name of the file, including its extension?  If it is an
> Excel file, we can't help at all.  If it is a Calc .ods file, we can confirm
> how the message arises, but you need to provide the file and also the entry
> you are attempting to make.