Bug 99949 - Estamos utilizando o linux mint com o libreoffice 5, e estamos com problemas com a formula de Indice/Corresp
Summary: Estamos utilizando o linux mint com o libreoffice 5, e estamos com problemas ...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-05-19 12:20 UTC by Rafael
Modified: 2016-05-19 21:54 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Planilha de ponto. (98.81 KB, application/zip)
2016-05-19 12:20 UTC, Rafael 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Rafael 2016-05-19 12:20:51 UTC 
Created attachment 125168 [details]
Planilha de ponto.

Segue em anexo, planilha que recebemos mensalmente do Departamento Pessoal com a folha de ponto dos estagiários. 

Ao escolher na lista suspensa o nome do colaborador, não visualizamos as informações. 


ERRO -  #N/DISP
Comment 1 m_a_riosv 2016-05-19 21:54:31 UTC 
Hi @Rafael, remember this bug report system only use English as language.

You can ask for help in http://nabble.documentfoundation.org/User-f2317346.html

in any there are several hidden formulas like:
P22: =INDEX(Quadro.D:D;MATCH(Ponto.$O$20;Quadro.$B:$B;0))

they are seaching for MATCH in 'Quadro.$B:$B', 'B' it's not the right column for search, searchin in 'Quadro.$C:$C' seems to works fine.

Resolved as not a bug, please if you are not agree reopen it.