[Libreoffice-bugs] [Bug 99982] FILE SAVE: formatting (and copy of formatting to new file) (from specific file) and save as XSLX give error by opening in excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=99982

--- Comment #19 from VLB  ---
I have test in
Version: 7.4.3.2 (x64) / LibreOffice Community
Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: nl-NL
Calc: CL

The issue is still present in Excel 2016.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 99982] FILE SAVE: formatting (and copy of formatting to new file) (from specific file) and save as XSLX give error by opening in excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=99982

--- Comment #18 from QA Administrators  ---
Dear VLB,

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice
from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information
from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a comment that includes the information from Help
- About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3) from
https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat:
https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 99982] FILE SAVE: formatting (and copy of formatting to new file) (from specific file) and save as XSLX give error by opening in excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=99982

VLB  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=99
   ||986

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 99982] FILE SAVE: formatting (and copy of formatting to new file) (from specific file) and save as XSLX give error by opening in excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=99982

VLB  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=13
   ||9163

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 99982] FILE SAVE: formatting (and copy of formatting to new file) (from specific file) and save as XSLX give error by opening in excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=99982

NISZ LibreOffice Team  changed:

   What|Removed |Added

 CC||er...@redhat.com,
   ||libreoff...@nisz.hu
 Blocks|113782  |

--- Comment #17 from NISZ LibreOffice Team  ---
Removing conditional formatting metabug, this is a number formatting problem.

@Eike, I thought you might be interested in this one.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=113782
[Bug 113782] [META] XLSX (OOXML) conditional formatting bug tracker
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 99982] FILE SAVE: formatting (and copy of formatting to new file) (from specific file) and save as XSLX give error by opening in excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=99982

--- Comment #16 from NISZ LibreOffice Team  ---
Created attachment 168379
  --> https://bugs.documentfoundation.org/attachment.cgi?id=168379=edit
The minimized example and its xlsx-version in Calc

Version: 7.2.0.0.alpha0+ (x64)
Build ID: e97a81e94511b52987a50b7bdb72c922899da588
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 99982] FILE SAVE: formatting (and copy of formatting to new file) (from specific file) and save as XSLX give error by opening in excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=99982

--- Comment #15 from NISZ LibreOffice Team  ---
Created attachment 168378
  --> https://bugs.documentfoundation.org/attachment.cgi?id=168378=edit
The minimized example file saved as xlsx

Calc opens this, but resets the custom formatting to the default Number -
Standard.
Excel fails to open this as seen on attachment #125348

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 99982] FILE SAVE: formatting (and copy of formatting to new file) (from specific file) and save as XSLX give error by opening in excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=99982

--- Comment #14 from NISZ LibreOffice Team  ---
Created attachment 168377
  --> https://bugs.documentfoundation.org/attachment.cgi?id=168377=edit
Minimized example file

Looks like the problem source is the custom formatting in P1 of the original
file.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 99982] FILE SAVE: formatting (and copy of formatting to new file) (from specific file) and save as XSLX give error by opening in excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=99982

--- Comment #13 from vlb  ---
I have test in wi 10 Versie: 6.3.2.2 (x64)and the bug is still present.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 99982] FILE SAVE: formatting (and copy of formatting to new file) ( from specific file) and save as XSLX give error by opening in excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=99982

Korrawit Pruegsanusak  changed:

   What|Removed |Added

 Attachment #125214|application/octet-stream|application/vnd.openxmlform
  mime type||ats-officedocument.spreadsh
   ||eetml.sheet

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 99982] FILE SAVE: formatting (and copy of formatting to new file) ( from specific file) and save as XSLX give error by opening in excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=99982

Aron Budea  changed:

   What|Removed |Added

 Blocks|87351, 108897   |113782, 104839


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=87351
[Bug 87351] [META] Conditional formatting bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=104839
[Bug 104839] [META] Saved XLSX files that MS Excel can't open
https://bugs.documentfoundation.org/show_bug.cgi?id=108897
[Bug 108897] [META] XLSX (OOXML) bug tracker
https://bugs.documentfoundation.org/show_bug.cgi?id=113782
[Bug 113782] [META] XLSX (OOXML) conditional formatting bug tracker
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 99982] FILE SAVE: formatting (and copy of formatting to new file) ( from specific file) and save as XSLX give error by opening in excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=99982

--- Comment #12 from vlb  ---
(In reply to vlb from comment #11)
> I have test in LO 6.0.0.0beta2 64 bit and issue is still present.

When i paste without format then didn't give error.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 99982] FILE SAVE: formatting (and copy of formatting to new file) ( from specific file) and save as XSLX give error by opening in excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=99982

--- Comment #11 from vlb  ---
I have test in LO 6.0.0.0beta2 64 bit and issue is still present.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 99982] FILE SAVE: formatting (and copy of formatting to new file) ( from specific file) and save as XSLX give error by opening in excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=99982

--- Comment #10 from vlb  ---
(In reply to Cor Nouws from comment #8)
> @frank: form your initial description we know that the problematic
> formatting is in the range M1:Q5.
> Can you please narrow down the range? That should make it easier to fix the
> problem.
> Thanks

When the orginal test file is open and delete all range a1:M6 and i do the
steps to reproduce it is als give the error, when you copy the range A1:Ap.

The range select A1:AO is without error.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 99982] FILE SAVE: formatting (and copy of formatting to new file) ( from specific file) and save as XSLX give error by opening in excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=99982

--- Comment #9 from vlb  ---
(In reply to Cor Nouws from comment #8)
> @frank: form your initial description we know that the problematic
> formatting is in the range M1:Q5.
> Can you please narrow down the range? That should make it easier to fix the
> problem.
> Thanks

In bug 99921 it is the same file but only formatting in the file. In that file
is the same issue i think.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 99982] FILE SAVE: formatting (and copy of formatting to new file) ( from specific file) and save as XSLX give error by opening in excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=99982

vlb  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=99
   ||921

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 99982] FILE SAVE: formatting (and copy of formatting to new file) ( from specific file) and save as XSLX give error by opening in excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=99982

--- Comment #8 from Cor Nouws  ---
@frank: form your initial description we know that the problematic formatting
is in the range M1:Q5.
Can you please narrow down the range? That should make it easier to fix the
problem.
Thanks

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 99982] FILE SAVE: formatting (and copy of formatting to new file) ( from specific file) and save as XSLX give error by opening in excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=99982

Cor Nouws  changed:

   What|Removed |Added

Summary|FILE SAVE: formatting (and  |FILE SAVE: formatting (and
   |copy of formatting to new   |copy of formatting to new
   |file) and save as XSLX give |file)   (from specific
   |error by opening in excel   |file)  and save as XSLX
   ||give error by opening in
   ||excel

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs