Download it now!
Bug 126305 - Data validaty on Error Alert action value lost on save xlsx (Always Stop), but on xls is ok
Summary: Data validaty on Error Alert action value lost on save xlsx (Always Stop), bu...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.4 all versions
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: dataLoss, filter:xlsx
Depends on:
Blocks: XLSX
  Show dependency treegraph
 
Reported: 2019-07-09 10:38 UTC by Nerijus
Modified: 2019-12-12 14:54 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Nerijus 2019-07-09 10:38:56 UTC
Description:
Data validaty on tab "Error Alert" Action value lost on save xlsx (Always Stop), but on xls is ok

Actual Results:
Data validaty on tab "Error Alert" Action value lost on save xlsx (Always Stop), but on xls is ok

Expected Results:
Data validaty on tab "Error Alert" Action value lost on save xlsx (Always Stop), but on xls is ok


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 Jacques Guilleron 2019-07-10 10:10:53 UTC
Hi  Nerijus,

Can you please join a small sample file showing the bug?
Thank you.
Comment 2 Roman Kuznetsov 2019-12-12 14:54:10 UTC
Confirm in

Версия: 6.5.0.0.alpha0+ (x64)
ID сборки: 67ee8818e68a2793d89331dd715989c468fe5680
Потоков ЦП: 4; ОС:Windows 10.0 Build 18362; Отрисовка ИП: по умолчанию; VCL: win; 
Локаль: ru-RU (ru_RU); Язык интерфейса: ru-RU
Calc: threaded

Steps:

1. Create a new calc spreadsheet
2. Select A1 cell
3. Select menu Data->Validity
4. In the dialog select "Whole numbers" in "Allow:" drop-down list on "Criteria" tab
5. On tab "Error alert" check "Show error message..." option
6. Select "Info" from "Action:" drop-down list
7. Type some info to "Title" and "Error message" fields
8. Press OK
9. Check that after entering 123,3 into A1 you see a Info message with OK and Cancel buttons
10. Save file as XLSX and close doc
11. Open it XLSX
12. Try enter 123,3 into A1 cell
13. Look at Stop message with only one OK button
14. Select Data->Validity
15. Go to tab "Error alert" in the dialog
16. Look at selected "Stop" variant instead "Info" in Action drop-down list