Bug 136154 - Conditional formatting for duplicate value lost after saving
Summary: Conditional formatting for duplicate value lost after saving
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.0.3 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-08-26 17:45 UTC by Anderson Sirtolli
Modified: 2022-01-11 08:17 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
show spanish errror in B93 (59.70 KB, image/png)
2021-06-13 23:56 UTC, paulo g.
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Anderson Sirtolli 2020-08-26 17:45:21 UTC
Description:
após fazer uma condicional de "valor duplicado" no calc, após slavar o arquivo e abrir novamente, o mesmo perde a condicional criada.

Steps to Reproduce:
1.clicar na coluna;
2.clicar em "formatar, condicional, gerenciar"
3.clicar em "adicionar, Condicional 1, valor da célula, é duplicado, salvar, OK, OK.
4. salvar o documento, fechar, e abrir novamente.


Actual Results:
5. abrir o documento, e o número serial informado na célula que está DUPLICADO, não segue a regra de condicional aplicada anteriormente.

Expected Results:
manter a condicional de valor duplicado.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
não funcionava, nem nas outras versões anteriores.
Comment 1 Erick M 2020-08-27 17:46:57 UTC
Olá Anderson, tudo bem camarada? Seguinte, tomei a liberdade de traduzir seu texto para que consiga ter resposta, pois o forum é em inglês. Espero que dê tudo certo pra ti. Abraço, segue:


Gentlemen, I translated the friend's message! Follow: 

* Description:
After doing a "duplicate value" conditional in Calc, after saving the file and opening it again, it loses the created conditional.

* Steps to Reproduce:
1. Click on the column;
2. Click on "format, conditional, manage";
3. Click on "add", Conditional 1, cell value is doubled. Save, OK, OK;
4. Save the document, close and open it again.

* Actual Results:
5. Open the document and the serial number entered in the cell that is DUPLICATED, it does not follow the conditional rule applied previously.
Comment 2 Buovjaga 2021-03-31 14:42:15 UTC
Please attach an example document.
Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided the document.
Comment 3 Jorge C 2021-06-11 17:26:20 UTC
Tengo una situación que parece similar. Al escribir en la celda B93 el número 7363. En la parte superior en la barra de fórmula, se ve el valor correcto de 7363, pero en la celda se ve 7363736373637363736373637363 y sigue repitiendo 7363 si hago la celda más ancha. Se llena la celda con el número que se capture. Si no tiene número y es texto, se ve correctamente. Si cambio el numero a 1234 se repite el número 123412341234123412341234 En esa y otras celdas de la misma columna se repite el número que escriba. La celda tiene text aligment horizontal: filled y vertical default. Y en Properties activado Wrap text automatically. En otras celdas no sucede eso. Al copiar el formato de otra celda en la que si se ve el  7363 correctamente, se arregla y ya no muestra lo duplicado.
En Format Cells, Alignment, al cambiar Text Aligment, Horizontal de Filled a Default se soluciona el problema o bien si copio el formato de otra celda que no tiene ese problema.
Comment 4 paulo g. 2021-06-13 23:56:06 UTC
Created attachment 172851 [details]
show spanish errror in B93
Comment 5 paulo g. 2021-06-13 23:59:07 UTC
Comment on attachment 172851 [details]
show spanish errror in B93

The error exists in 7.2 alpha.
Comment 6 QA Administrators 2021-12-11 04:22:20 UTC Comment hidden (obsolete)
Comment 7 QA Administrators 2022-01-11 03:53:46 UTC Comment hidden (obsolete)
Comment 8 Buovjaga 2022-01-11 08:17:44 UTC
For the record, I tried the steps from comment 1 from scratch and the condition works fine and is not lost after saving and reloading. If someone is still experiencing this, please give more details.

Arch Linux 64-bit
Version: 7.4.0.0.alpha0+ / LibreOffice Community
Build ID: 71be70b16b37fb3c1b6331ab3581300556ecc7aa
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 7 January 2022