Fai la tua domanda

jamesb's profile - attività

2020-09-20 02:25:03 +0200 received badge  Domande famose (source)
2020-09-15 17:02:51 +0200 received badge  Domande famose (source)
2020-09-15 17:02:51 +0200 received badge  Domanda notevole (source)
2020-09-10 15:29:53 +0200 received badge  Domande famose (source)
2020-09-10 14:33:58 +0200 ha accettato una risposta File name link concatenation

Hello

In Calc, using the following I can, of course, call in data into my current spreadsheet file:

='file:///home/jamesb/Documents/List.ods'#$'R&D'.H22

However, I'd like to be able to reference the last two digits, "22", from another cell, say A1, in my current spreadsheet file, something like this:

=CONCAT("'file:///home/jamesb/Documents/List.ods'#$'R&D'.H",N(A1))

or

=CONCAT("=","'file:///home/jamesb/Documents/List.ods'#$'R&D'.H",N(A1))

Where the value in cell A1 is "22".

Unfortunately, as you'll know, this simply results in a cell displaying the following, but not the data contained in the remote file's cell:

'file:///home/jamesb/Documents/List.ods'#$'R&D'.H22

The method is eluding me, despite much searching.

I'd be most grateful if someone could help.

Thank you.

2020-08-31 19:29:58 +0200 received badge  Domanda notevole (source)
2020-06-06 00:35:36 +0200 received badge  Domanda notevole (source)
2019-09-05 18:23:55 +0200 received badge  Autodidatta (source)
2019-09-05 18:23:55 +0200 received badge  Insegnante (source)
2019-09-04 12:14:26 +0200 ha commentato una risposta Calc formula not appearing in clipboard or pasting into another sheet

Hi erAck See my "Further edit". Seems KRDC remote desktop connection client is breaking clipboard.

2019-09-04 12:13:48 +0200 ha modificato una risposta Calc formula not appearing in clipboard or pasting into another sheet

So... The problem has gone away, but I don't know why! Here's what I did: 1 - Install Gnome desktop (I already had KD

2019-09-04 10:08:31 +0200 received badge  Domande famose (source)
2019-09-02 22:01:46 +0200 ha modificato una risposta Calc formula not appearing in clipboard or pasting into another sheet

So... The problem has gone away, but I don't know why! Here's what I did: 1 - Install Gnome desktop (I already had KD

2019-09-01 07:15:11 +0200 received badge  Domanda notevole (source)
2019-08-31 17:39:53 +0200 ha risposto a una domanda Calc formula not appearing in clipboard or pasting into another sheet

So... The problem has gone away, but I don't know why! Here's what I did: 1 - Install Gnome desktop (I already had KD

2019-08-31 15:57:39 +0200 received badge  Domanda gettonata (source)
2019-08-31 13:19:51 +0200 ha commentato una domanda Calc formula not appearing in clipboard or pasting into another sheet

Hi ve3oat Thanks for taking the time to reply. Yes, your suggestion would and does work fine. However, Ctrl-c should (

2019-08-30 22:28:13 +0200 ha posto una domanda Calc formula not appearing in clipboard or pasting into another sheet

Calc formula not appearing in clipboard or pasting into another sheet Having searched around I have only found answers t

2018-09-13 15:55:07 +0200 ha commentato una risposta Summary from sheet with blank rows

Hi JohnSUN. Thanks again. As I said, all cells contain the identical formula, relative to their position in the sheet. N

2018-09-13 15:54:50 +0200 ha commentato una risposta Summary from sheet with blank rows

Hi JohnSUN. Thanks again. As I said, all cells contain the identical formula, relative to their position in the sheet. N

2018-09-13 15:54:37 +0200 ha commentato una risposta Summary from sheet with blank rows

Hi JohnSUN. Thanks again. As I said, all cells contain the identical formula, relative to their position in the sheet. N

2018-09-13 11:34:23 +0200 received badge  Domanda gettonata (source)
2018-09-13 11:32:40 +0200 ha commentato una risposta Summary from sheet with blank rows

Hi JohnSUN Thank you kindly for your reply. I'm most grateful. Although this method works for non-calculated data, it d

2018-09-13 11:31:50 +0200 ha commentato una risposta Summary from sheet with blank rows

Hi JohnSUN Thank you kindly for your reply. I'm most grateful. Although this method works for non-calculated data, it d

2018-09-13 07:54:56 +0200 received badge  Domanda gettonata (source)
2018-09-12 20:49:49 +0200 ha posto una domanda Summary from sheet with blank rows

Summary from sheet with blank rows Hi I have a sheet which produces results something like this: I'd like to display

2018-09-12 20:36:37 +0200 received badge  Domanda notevole (source)
2018-07-14 08:44:57 +0200 received badge  Domande famose (source)
2018-07-14 08:44:57 +0200 received badge  Domanda gettonata (source)
2018-07-14 08:44:57 +0200 received badge  Domanda notevole (source)
2018-04-23 22:31:13 +0200 received badge  Domanda notevole (source)
2018-03-07 05:33:27 +0200 received badge  Domanda notevole (source)
2018-03-07 05:33:27 +0200 received badge  Domande famose (source)
2018-02-23 00:09:03 +0200 received badge  Domanda gettonata (source)
2018-02-23 00:00:09 +0200 received badge  Entusiasta
2018-02-22 23:34:53 +0200 ha modificato una risposta =MATCH confuses "AV." with "AVV"

Ah! Got it! =MATCH(T(B19),T(HL_download.$B$1:$B$202),0) It's the missing second T() modifier that I need. Stupid me!

2018-02-22 23:27:28 +0200 ha risposto a una domanda =MATCH confuses "AV." with "AVV"

Ah! Got it! > =MATCH(T(B19),T(HL_download.$B$1:$B$202),0) > It's the missing second T() modifier that I need. St

2018-02-22 23:24:13 +0200 ha commentato una risposta =MATCH confuses "AV." with "AVV"

Thanks for this. =VLOOKUP(B19,HL_download.$B$1:$B$202,1,0) still returns the "AVV" and not "AV." entry. In my =MATCH

2018-02-22 22:35:53 +0200 ha posto una domanda =MATCH confuses "AV." with "AVV"

=MATCH confuses "AV." with "AVV" I'm using the following formula to look up a stock code and return it's line number:

2016-11-29 20:34:23 +0200 received badge  Domanda gettonata (source)
2016-11-16 18:12:15 +0200 ha risposto a una domanda Hyperlink to Yahoo charts error following close and open of file - Calc v5.2

Hi Ratslinger

Thanks for taking the time to look at this. Oddly, even using your suggestion, the link fails to remain working between saves of the file.

Simply by removing the last bracket in the statement, and hitting enter (allowing Calc to correct the entry) the link then works fine.

I just can't fathom this out. I'm totally stumped!! I feel it's going to be something simple, but I can't find it...

:-)

2016-11-10 13:15:27 +0200 received badge  Organizzatore (source)
2016-11-10 13:12:46 +0200 ha posto una domanda Hyperlink to Yahoo charts error following close and open of file - Calc v5.2

Hi

Has anyone come across this behaviour in Calc?

  • Ensure macros are enabled
  • Create cell entry to a Yahoo thus:

=HYPERLINK(CONCATENATE("http://finance.yahoo.com/chart/",T(C18),"#eyjtdwx0aunvbg9ytgluzsi6zmfsc2usimjvbgxpbmdlclvwcgvyq29sb3iioiijztiwmdgxiiwiym9sbgluz2vytg93zxjdb2xvcii6iim5ntuyzmyilcjzag93u21hijp0cnvllcjzbwfdb2xvcnmioiijzjaxmjzmiiwic21hugvyaw9kcyi6ijuwiiwic21hv2lkdghzijoimsisinntyudob3n0aw5nijoimcisinnob3dfbweionrydwusimvtyunvbg9ycyi6iimxywm1njcilcjlbwfqzxjpb2rzijointailcjlbwfxawr0ahmioiixiiwizw1hr2hvc3rpbmcioiiwiiwibwzptgluzunvbg9yijoiizq1ztnmziisim1hy2reaxzlcmdlbmnlq29sb3iioiijzmy3yjeyiiwibwfjze1hy2rdb2xvcii6iim3oddkodiilcjtywnku2lnbmfsq29sb3iioiijmdawmdawiiwicnnptgluzunvbg9yijoii2zmyjcwmcisinn0b2nos0xpbmvdb2xvcii6iinmzmi3mdailcjzdg9jaermaw5lq29sb3iioiijndvlm2zmiiwicmfuz2uioii1esj9"),"Yahoo")

...where cell C18 contains the value "TCM.L" or any other stock ticker/code.

  • Check the hyperlink works - it does!
  • Save the file and open it again
  • Check the hyperlink again - it fails with

"Yahoo" is not an absolute URL that can be passed to an external application to open it.

Is there some limit to the hyperlink statement length? There seem to be 705 characters in it. What else might be going on?

I'm running CentOS7, Gnome desktop and LibreOffice 5.2.

Thanks! :-)

2016-08-16 22:37:14 +0200 received badge  Domanda gettonata (source)
2016-08-16 08:21:19 +0200 received badge  Domanda gettonata (source)
2016-08-15 15:16:56 +0200 ha modificato una domanda Calc frequency array <-

In a frequency array I have the following:

0.00 | 6

-0.01 | 0

-0.02 | 3

←0.02 | 5

The last entry in the first column should read "<-0.02". Where do I stop "<-" becoming "←" on a per sheet basis? I don't seem to be able to find this out.