Ask Your Question
RSS
Sort by » date activity ▼ answers votes

44 questions

Tagged
  • ×
21
views
1
answer
no
votes
2021-05-06 20:14:08 +0200 erAck flag of Germany

Calc: Indirect problem with file reference

29
views
1
answer
no
votes
2021-01-30 20:01:40 +0200 Opaque

How to format reference to external worksheet?

155
views
1
answer
no
votes
2020-12-12 12:09:57 +0200 anandmahey

Using Indirect to reference multiple cells

34
views
no
answers
no
votes
2020-12-07 15:55:39 +0200 Genesis

string subtitution on a external reference fails?

35
views
1
answer
no
votes
2020-05-23 01:11:43 +0200 Opaque

how to add strings to address?

196
views
2
answers
no
votes
2020-04-30 22:43:07 +0200 erAck flag of Germany

Migrating from Excel and indirect formula not working in Calc

37
views
no
answers
no
votes
2020-01-18 13:59:10 +0200 johnarch

CALC external file reference no longer working

79
views
1
answer
no
votes
2019-09-01 00:26:21 +0200 Mike Kaganski flag of Russia

INDIRECT and arithmetic

244
views
1
answer
no
votes
2019-08-14 14:15:10 +0200 erAck flag of Germany

Problem with hlookup and indirect [closed]

2k
views
1
answer
no
votes
2019-01-10 21:35:42 +0200 SM_Riga flag of Latvia

How to escape double quote in INDIRECT()

385
views
no
answers
no
votes
2018-12-27 21:19:20 +0200 SM_Riga flag of Latvia

Calc: INDIRECT() function with Column/Row labels

190
views
1
answer
no
votes
2018-07-15 13:42:33 +0200 m.a.riosv flag of Spain

Optimizing a Calc spreadsheet with 1000s of INDIRECT entries

130
views
1
answer
no
votes
2018-01-22 22:09:57 +0200 Jim K flag of United States of America

vlookup() inside indirect() [closed]

302
views
2
answers
no
votes
2017-07-24 10:56:59 +0200 Lupp

=INDIRECT(A4 & ".O$17") doesn't work [closed]

153
views
1
answer
no
votes
2017-01-12 12:07:45 +0200 Lupp

Display Cell as Blank and not #REF! [closed]

932
views
1
answer
no
votes
2016-11-21 17:09:24 +0200 mark_t flag of Canada

calc - function to define cellrange [closed]

123
views
1
answer
no
votes
2016-11-07 19:15:30 +0200 mark_t flag of Canada

calc - vary column in indirect [closed]

684
views
1
answer
no
votes
2016-11-06 19:41:48 +0200 karolus flag of Germany

calc - filename from cell [closed]

Resources

Did you find this site useful? Support the LibreOffice community!

Contributors

007Charlette gravatar imagem.a.riosv gravatar imageArchetype gravatar imageJim K gravatar imageLupp gravatar imageLeroyG gravatar imageOpaque gravatar imagekarolus gravatar imagegtomorrow gravatar imageerAck gravatar imageargh.pirate gravatar imageSM_Riga gravatar imageDiesNuts gravatar imageChamiLG gravatar image-rob- gravatar imagemark_t gravatar image