Any way to get around truncated array evaluation?

English
#1

Sorry if this has already been asked before but I’ve been searching for an answer to this on multiple websites including this one. I also tried to upload a screenshot but it declined me.

For the sake of a very simple example, I have =IF(A1:A8=B1:B8). If I hover over the formula in the formula bar and press F9 I get #VALUE!, so I went into the Formula Wizard and clicked the Array checkbox in the bottom left corner, and the function result is now {1;1;1;"";"";""…

Any way to get the full readout besides actually printing it out in a column with CTRL+SHIFT+ENTER and then having to undo it every time?

#2

Would you mind to explain what you expect the example formula to achieve? The IF function should be called with three parameters.
What is a “truncated arrayvaluation”?
What do you have to “undo every time” and for what reason?

#3

If I leave the other two parameters out, it returns either TRUE or FALSE, so it seems to work. =IF(1=1) returns TRUE.

I tried to show what I mean with a screenshot, but it said I need 3 karma to upload.

If you have:
A, A
B, D
C, C

in cells A1:B3, and then do =IF(A1:A3=B1:B3) it will return {1;0;1}, as it should. If longer it becomes truncated in the wizard and I’d like to see the whole thing for troubleshooting in real projects. It’s something excel can do and just wondering if Calc can too.

#4

Regarding what I was talking about with “undoing every time”, one way to see the whole result is to type the =IF(A1:A3=B1:B3) statement, and the use CTRL+SHIFT+ENTER, and it will print out 1, FALSE, 1 in a column of three cells. It’s a sloppy solution and I’d prefer another way if there is one, if not then thank you for letting me know. I don’t want to actually have it placed in any cells, I only want to see it for troubleshooting purposes, like anything else with highlight+F9.

#5

Views of different humans are inevitably different. In my opinion to use a preview function, in specific with the formula wizard, is more complicated and a bit sloppier than to actually enter the formula. Having done so, a simple Ctrl+Z makes it undone (Including the restoration of accidentally overwritten contents).

#6

Working on this thread, I experienced for the first time in 20 years of using Calc that the preview feature of the formula wizard is too small, and the results are truncated and badly formatted in some cases. (I rarely use the wizard.)
You may file a bug report and / or a feature request (no technical difference) to this site.

#7

This is how it works. Or what do you expect the Formula Wizard to display for a range of one million rows?

#8

Never said one million, but say, a simple 8 or 15? There would be plenty of room in a pop-up window for example.

I’m not really sure why two out of two people seem to have snapped at me just for asking a question. I apologize if i misinterpreted. I thought that’s what this website was for. Excel does the exact thing that I’m talking about, and I was simply curious if Calc could do the same or not. It would appear not, so now I know.

The question is welcome to be closed, then.

#9

Sorry! I surely did not intend to “snap at you”. Being not a natiove speaker of English (American E) I may use some words without knowing a specific implication.
If I simply do not understand a questioners intentions, I must be allowed to ask in return, however.
Formulae are to use to calculate results and to return them to one (scalar result) or more (array result) cells. The preview function of the wizard is rather casual (IMO). I do not know how Excel (which one?) does it.
Sorry again.

#10

@ewik99frvl: Please feel sure to be welcome with your questions and contributions here.

#11

The formula =IF(A1:A3=B1:B3) is simply a bit more complicated than actually needed. It should produce the identical result as =(A1:A3=B1:B3) does (even without the parentheses).
A result shown as {1;FALSE;1} is most likely due to a previously happened formatting of some of the used cells. Select the preferred format (number or logical) for all the cells explicitly to get rid of the effect.

#12

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.