Issue 14673

Summary:	use http references as values in cell formulas
Product:	Calc	Reporter:	Unknown <non-migrated>
Component:	code	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	OOo 1.1 Beta2
Target Milestone:	---
Hardware:	PC
OS:	Linux, all
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---

Description Unknown 2003-05-20 15:55:04 UTC

it would be useful to be able to access data over http and use it in cell
references.

example: you might have a servlet-based web application that does budgeting.  an
accountant might want to use some of those services in a spreadsheet.  We might
use a cell formula like this:

   =(http://intra.example.org/budgeting/GetLabor?quarter=2002q2)

this would access the GetLabor servlet and return the labor cost for the second
quarter of 2002, which the accountant could then use in the spreadsheet for his
own purposes.

From the organization's perspective, this has several benefits: 

1) it allows reuse of server-based logic in desktop apps.

2) sometimes organizations have logic redundantly scattered throughout office
documents, but a wholesale reimplementation of all the spreadsheet functionality
as a web app can be a huge job.  this feature would allow the developers at
example.com to move the logic over to (say) servlets gradually, and use them
immediately within the existing spreadsheets.

Comment 1 frank 2003-05-21 09:08:11 UTC

Hi Bettina,

1 4 u

I think this would be a great improvement.

Frank

Comment 2 ace_dent 2008-05-16 02:39:31 UTC

OpenOffice.org Issue Tracker - Feedback Request.

The Issue you raised has the status 'New' pending further action, but has not
been updated within the last 4 years. Please consider re-testing with one of the
latest versions of OOo, as the problem(s) may have already been addressed.
Either use the recent stable version: http://download.openoffice.org/index.html
or consider trying the new OOo 3 BETA (still in testing):
http://download.openoffice.org/3.0beta/
 
Please report back the outcome so this Issue may be Closed or Progressed as
necessary - otherwise it may be Resolved as Invalid in the future. You may also
wish to search for (and note) any duplicates of this Issue that may have
advanced further by checking the Issue Tracker:
http://www.openoffice.org/issues/query.cgi
 
Many thanks,
Andrew
 
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~
http://marketing.openoffice.org/3.0/announcementbeta.html

Comment 3 bettina.haberer 2010-05-21 14:49:37 UTC

To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".