Bug 122895 - formatage conditionel
Summary: formatage conditionel
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.7.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-01-23 11:22 UTC by toblerone_53
Modified: 2019-02-01 18:51 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
la valeur de la colone A, modifie le style de la ligne (27.44 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-01-23 11:24 UTC, toblerone_53
Details

Note You need to log in before you can comment on or make changes to this bug.
Description toblerone_53 2019-01-23 11:22:22 UTC
Description:
Le formatage conditionnel est modifié à chaque copier coller sur la feuille
Menu : Format\Formatage conditionnel\Gerrer...


Steps to Reproduce:
1.Definir un formatage conditionnel sur une plage de cellule
2.Copier des cellules
3.Les coller dans la plages du formatage conditionnel

Actual Results:
Ca ajoute des plages dans la fenettre de gestion des formatage conditionnel

Expected Results:
Le résultat attendu est de mettre de la couleur + mise en forme police


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 toblerone_53 2019-01-23 11:24:15 UTC
Created attachment 148549 [details]
la valeur de la colone A, modifie le style de la ligne
Comment 2 Oliver Brinzing 2019-01-23 18:19:38 UTC
Description:
Conditional formatting is changed with each copy paste on the sheet
Menu: Format \ Conditional formatting \ Gerrer ...


Steps to Reproduce:
1.Defining a conditional formatting on a cell range
2.Copy cells
3. Paste them into the conditional formatting range

Actual Results:
Adds tracks in the conditional formatting management window

Expected Results:
The expected result is to put color + font formatting


Reproducible: Always


User Profile Reset: No



Additional Info:

Created attachment 148549 [details]
the value of colone A, changes the style of the line
Comment 3 Oliver Brinzing 2019-01-23 18:38:11 UTC
do you mean, for example:

- select A2:A13 from sheet "Listes"
- copy
- paste to cell A2 on sheet "Mouvements"
- result: conditional format is lost

this is the normal behaviour if you copy cells, the cell format will be replaced. 

if you want to copy cell data to column A, use "Menu Edit/Paste Special..." with 
[x] Text
[x] Numbers
[x] DateTime
Comment 4 toblerone_53 2019-01-31 21:11:15 UTC
OK, il me semblait avoir testé.
Sans formatage dans le collage, ca ne modifie pas le formatage conditionnel.
Fausse alerte !
Comment 5 Oliver Brinzing 2019-02-01 18:50:30 UTC
OK, I seemed to have tested.
Without formatting in the collage, it does not modify the conditional formatting.
False alert!
Comment 6 Oliver Brinzing 2019-02-01 18:51:54 UTC
so setting this issue to resolved/notabug