[Solved] Working with external data

Discuss the spreadsheet application
Post Reply
CaseyC
Posts: 9
Joined: Tue Jan 19, 2016 5:32 pm

[Solved] Working with external data

Post by CaseyC »

I have a sheet which has several links to external data. Every time I open the sheet the values are updated.

I would like to display the difference in the values between updates. In other words, prior to update value1 was $5.00, after update it was $5.10. I want to create a cell that shows the difference $.10.

Is there a way to accomplish that??

Thank you,
Klaus Cook
Houston, Texas
Last edited by MrProgrammer on Sun Dec 27, 2020 10:47 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved]
OpenOffice 4.1.1 on Windows 10
User avatar
MrProgrammer
Moderator
Posts: 4909
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Working with external data

Post by MrProgrammer »

CaseyC wrote:I would like to display the difference in the values between updates.
Begin by reading Save old data when web query refreshes.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
Post Reply