Issue 125526 - Data loss warning should be shown BEFORE saving
Summary: Data loss warning should be shown BEFORE saving
Status: UNCONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: 4.1.1
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-08-27 14:30 UTC by Pedro
Modified: 2014-10-28 11:18 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description Pedro 2014-08-27 14:30:22 UTC
When exporting a spreadsheet with more than 256 columns to xls I get a wrong error message (see Bug #85945) only AFTER saving.

I believe there should be a check on the file prior to saving and (if it applies) a warning saying: The document contains more rows and/or columns than supported in the selected format. There will be data loss. Do you still want to proceed? Yes/No

This allows the user to go back and choose another format (e.g csv or ODS rev 1.1 for those who know how...)

What is the point of warning the user *after* an incomplete file has been created?
Comment 1 oooforum (fr) 2014-08-28 07:31:33 UTC
Why create another report?
It will be better to add comment on issue 85945 directly.

Just remember that XLS is an outdated format.
I don't know if developer team put resource to maintain it.
Now, Microsoft use and recommand XLSX.
Comment 2 oooforum (fr) 2014-10-28 11:09:19 UTC
To be continuted on #85945

*** This issue has been marked as a duplicate of issue 85945 ***
Comment 3 Pedro 2014-10-28 11:18:47 UTC
(In reply to oooforum from comment #1)
> Why create another report?
> It will be better to add comment on issue 85945 directly.

You should NOT dismiss this as a DUPLICATE. This is a separate issue. One problem is that the message is WRONG and the other problem is that the message is shown AFTER. Any of these problems can be fixed without fixing the other so they are NOT duplicates.
 
> Just remember that XLS is an outdated format.
> I don't know if developer team put resource to maintain it.

Agreed. But since it is the ONLY file format that can be exchanged without problems, it is the DE FACTO common file format.

> Now, Microsoft use and recommand XLSX.

This is a joke, right? Since when does Open Source Software follow Microsoft's recommendation?

I hope you are aware that XLSX (and DOCX, PPTX) is NOT a single file format but that it changes between MS Office versions to force users to buy the new version.