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

16 questions

Tagged
  • ×
  • ×
9
views
no
answers
no
votes
2015-10-30 05:18:40 +0200 argh.pirate

Is there any way to shorten this formula?

118
views
no
answers
no
votes
2016-02-16 20:48:51 +0200 nicoulaj

How to extend a formula using INDIRECT ?

103
views
no
answers
no
votes
2016-03-31 04:07:58 +0200 spyong.hsl

Calc Crash on deleting row containing indirect() formula

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

Calc: INDIRECT() function with Column/Row labels

166
views
1
answer
no
votes
2016-03-13 02:31:13 +0200 m.a.riosv flag of Spain

Trying to use vlookup with indirect

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

calc - function to define cellrange

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

Display Cell as Blank and not #REF!

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

vlookup() inside indirect()

76
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

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

How to escape double quote in INDIRECT()

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

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

Resources

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

Contributors

gtomorrow gravatar imageJim K gravatar imageLupp gravatar imagem.a.riosv gravatar imageargh.pirate gravatar imageSM_Riga gravatar image-rob- gravatar imageDiesNuts gravatar imagebdenn gravatar imageLCL999 gravatar imagemoodma gravatar imagebkucharski gravatar imageerotavlas gravatar imageMichaud79 gravatar imageA lame attempt at anonymity gravatar imagemanwenc gravatar image