Fluke wrote:Hi,
I've just got round to downloading the c-b Libreoffice version, I see that the latest data sheet was updated recently so started by trying to update it. The first step to select all > clear contents presented me with a sub-menu giving me a choice of things to delete - text/date time/comments/numbers/formulas - I just selected delete all. This left me with a blank data sheet except for the label in the first row 'Select your start row....' I mention this because the video shows a completely blank sheet.
Then downloaded the latest data sheet did the select all > copy - but the next step - past special > text - didn't work, nothing pasted, however when I did a command V it did paste so went to the HYP tab and tested it by getting the share price for BP, as expected this produced an error.
com.sun.star.uno.RuntimeException: Error during invoking function getPriceSrc in module vnd.sun.star.tdoc:/6/Scripts/python/HypTopUp.py (<class 'UnboundLocalError'>: local variable 'response' referenced before assignment
File "/Applications/LibreOffice.app/Contents/Resources/pythonscript.py", line 915, in invoke
ret = self.func( *args )
File "vnd.sun.star.tdoc:/6/Scripts/python/HypTopUp.py", line 4811, in getPriceSrc
File "vnd.sun.star.tdoc:/6/Scripts/python/HypTopUp.py", line 2060, in HypUpdYahooPriPy_3
)
I'm using Mac OS 14.2.1 with Libreoffice version 7.5.7.1 which is an older version but still (I think) ok to use.
Can't see that anybody else has reported this.
I'm not sure what's happening here.
The video was created using Excel on Windows, so there are some minor differences for LibreOffice on other OS.
I'm using LibreOffice on Windows 11 and when I pasted the new data sheet using Command+V as you did, it pasted all of the data in Column A of the data sheet, which is clearly wrong. On LibreOffice, use right-click / Paste Special / Unformatted text, select TAB as the separator and click OK .
An easier way is to use the more automated process. Download the data sheet to your PC (typically the Downloads folder, but anywhere will do). Then select cell A1 and click on the box in cell A1 "Select your start row etc". This provides a file selection window. Locate your downloaded file and click on OK and the data will be updated. See page 17 of the User Guide.
However, this does not explain your problem. Updating share prices does not actually use the data sheet. You can delete all the data in the data sheet and you will still get updated prices when you click on the "Get Prices" button (IF you are using Yahoo as the price source, which is the default)
It sounds like you have corrupted something, so I suggest downloading a fresh copy of HYPTUSS and try again.
--kiloran