[Libreoffice-bugs] [Bug 147141] Calc header/footer not backwards compatible (office version 1.3 > 1.2)

2022-10-31 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=147141

Eike Rathke  changed:

   What|Removed |Added

   Assignee|libreoffice-b...@lists.free |er...@redhat.com
   |desktop.org |

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

[Libreoffice-bugs] [Bug 147141] Calc header/footer not backwards compatible (office version 1.3 > 1.2)

2022-10-31 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=147141

Eike Rathke  changed:

   What|Removed |Added

 Status|NEW |ASSIGNED

--- Comment #16 from Eike Rathke  ---
Or maybe 1.2-extended would be ok when using the lo-ext namespace.

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

[Libreoffice-bugs] [Bug 147141] Calc header/footer not backwards compatible (office version 1.3 > 1.2)

2022-10-31 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=147141

Eike Rathke  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1

--- Comment #15 from Eike Rathke  ---
The proper way out it seems would be to save the *first only when saving to
>=1.3 but not <1.3 (1.2 or 1.2-extended).

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

[Libreoffice-bugs] [Bug 147141] Calc header/footer not backwards compatible (office version 1.3 > 1.2)

2022-04-02 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=147141

--- Comment #14 from Wittich  ---
... still running at least once a month over that issue!

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

[Libreoffice-bugs] [Bug 147141] Calc header/footer not backwards compatible (office version 1.3 > 1.2)

2022-03-05 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=147141

--- Comment #13 from Wittich  ---
Any updates, further thoughts on this topic?

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

[Libreoffice-bugs] [Bug 147141] Calc header/footer not backwards compatible (office version 1.3 > 1.2)

2022-02-04 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=147141

Timur  changed:

   What|Removed |Added

 CC||rb.hensc...@t-online.de

--- Comment #12 from Timur  ---
hi Regina, please see if you can.

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

[Libreoffice-bugs] [Bug 147141] Calc header/footer not backwards compatible (office version 1.3 > 1.2)

2022-02-04 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=147141

--- Comment #11 from Wittich  ---
I search a little on the OASIS Open page and as far I understand the
OpenDocument schema 1.2 and 1.3 the h/f-first style is only valid in office
version 1.3. From this standpoint, LO 6.4 and before don't have correctly
implemented OpenDocument 1.2. 

I guess there is no fix as long it's not fixed in LO 6.4.

Here are the details from 1.3 schema:

> The  element represents the content of a header for a 
> first page, if different from the left/right page in a  
> element.
> 
> The term "first page" means the first page to which the page style is 
> applied, regardless of any numbering. If a different page style is applied in 
> between two applications of a page style that has the  
> element, each of the applications of the page style has its own first page.

Source:
https://docs.oasis-open.org/office/OpenDocument/v1.3/cs01/part3-schema/OpenDocument-v1.3-cs01-part3-schema.html#a_16_10__style_header_

In the 1.2 schema, this style element doesn't exits:
https://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part1.html#a16_10_style_header_

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

[Libreoffice-bugs] [Bug 147141] Calc header/footer not backwards compatible (office version 1.3 > 1.2)

2022-02-04 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=147141

--- Comment #10 from Wittich  ---
Created attachment 178071
  --> https://bugs.documentfoundation.org/attachment.cgi?id=178071=edit
Test file created with LO 7.3 with first and rest H/F actived

As I wrote above, you can fix the second issue with removing the header-first
and footer-first style... so that got me thinking what is this option *-first,
so with LO 7.2* you have this option "Same content on first page" when you
uncheck it you can enter two different H/F. One called H/F (first) and one H/F
(rest). Now if you fill out both the first and the rest it works in LO 6.4.

So if I got this right, LO 6.4 read the first as main H/F as it doesn't know
about a second H/F (rest). 

No clue how to fix this...

For me, works at the moment the following commands as a fix:

file='147141 test 74 13e.ods'
unzip -p "$file" styles.xml > styles.xml
sed -i -r 's///g2'
styles.xml
unzip -p "$file" styles.xml > styles.xml

Et voilĂ !

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

[Libreoffice-bugs] [Bug 147141] Calc header/footer not backwards compatible (office version 1.3 > 1.2)

2022-02-04 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=147141

--- Comment #9 from Timur  ---
Created attachment 178047
  --> https://bugs.documentfoundation.org/attachment.cgi?id=178047=edit
Test in LO 7.4+ opens OK

Seems like there may be 2 issues:
- opening ODS with empty H/F in older LO makes them disabled, which makes no
damage and is WontFix
- opening attached ODS, not all, in older LO looses H/F, which is a problem,
but not clear what exactly makes it - and it doesn't exist with new LO.

Here is ODS from master 7.4+.

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

[Libreoffice-bugs] [Bug 147141] Calc header/footer not backwards compatible (office version 1.3 > 1.2)

2022-02-04 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=147141

Timur  changed:

   What|Removed |Added

 Status|RESOLVED|UNCONFIRMED
 Resolution|WONTFIX |---

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

[Libreoffice-bugs] [Bug 147141] Calc header/footer not backwards compatible (office version 1.3 > 1.2)

2022-02-04 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=147141

Timur  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 Resolution|--- |WONTFIX

--- Comment #8 from Timur  ---
I reproduced by making ODS with empty H/F in Linux with 7.2 latest and
reopening in same 7.2, not sure what's important. 
Also repro by opening ODS from 7.4+ in 7.2, so it wasn't old versions only.
No repro by opening ODS from 7.4+ in 7.4, so not current versions. 

Problem seems to be only with empty H/F. 
Meaning that I confirm the report but don't consider it a bug, there's no
damage. 
I mark WontFix. 

Please test more. If you reproduce a bug with H/F that have some content,
please set Unconfiormed.

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

[Libreoffice-bugs] [Bug 147141] Calc header/footer not backwards compatible (office version 1.3 > 1.2)

2022-02-03 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=147141

--- Comment #7 from Wittich  ---
(In reply to Timur from comment #6)
> I reproduce with that sample. Not clear why not from scratch.

Can you compare the styles.xml from my sample with your file? Just rename the
*.ods file into *.zip then you can have a look into it (I used xmllint to
format the file pretty/readable: `cat styles.xml | xmllint --format - >
styles2.xml`). 

Also, you wrote that you created the file with LO 7.4+, I have only reproduced
it with 7.2 and 7.3.

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

[Libreoffice-bugs] [Bug 147141] Calc header/footer not backwards compatible (office version 1.3 > 1.2)

2022-02-03 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=147141

--- Comment #6 from Timur  ---
I reproduce with that sample. Not clear why not from scratch.

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

[Libreoffice-bugs] [Bug 147141] Calc header/footer not backwards compatible (office version 1.3 > 1.2)

2022-02-03 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=147141

--- Comment #5 from Wittich  ---
Created attachment 178018
  --> https://bugs.documentfoundation.org/attachment.cgi?id=178018=edit
Test file created with LO 7.2

Test file has an activated HF with a custom content:

- Header Center area: Test Sheet 1
- Footer Center area: Test Footer

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

[Libreoffice-bugs] [Bug 147141] Calc header/footer not backwards compatible (office version 1.3 > 1.2)

2022-02-03 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=147141

--- Comment #4 from Wittich  ---
I can reproduce it also on a Windows 10 system:

Version: 6.2.5.2 (x64)
Build ID: 1ec314fa52f458adc18c4f025c545a4e8b22c159
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: en-US (en_DE); UI-Language: en-GB
Calc: threaded

Not only the HF is disabled but, if I reactivate it, the content is "lost".

I will attach a test file.

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

[Libreoffice-bugs] [Bug 147141] Calc header/footer not backwards compatible (office version 1.3 > 1.2)

2022-02-03 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=147141

Timur  changed:

   What|Removed |Added

 OS|Linux (All) |All
   Severity|normal  |minor
   Hardware|x86-64 (AMD64)  |All
   Priority|medium  |low

--- Comment #3 from Timur  ---
I don't reproduce. Tried with saving in LO 7.4+ in Windows as 1.3 extended and
opening LO 6.4 in Linux and Windows. HF are enabled .

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

[Libreoffice-bugs] [Bug 147141] Calc header/footer not backwards compatible (office version 1.3 > 1.2)

2022-02-02 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=147141

--- Comment #2 from Wittich  ---
(In reply to Wittich from comment #1)
> A quick analyze of the difference of a document which works (version 1.2)
> and one which doesn't work (version 1.3) shows that the only main difference
> concerning the header and footer of these documents are the lines 
> 
> 
> 
> [...]
> 
> [...]
> 
> [...]
> 
> 
> 
> So if I remove this header-first and the footer-first style, everything
> works as it should.
> 
> Hope that helps to solve the issue.

Here is a way to fix corrupted files so that they show the header/footer
correctly with an old calc installation:

1. unzip -p file.ods styles.xml > styles.xml
2. sed -i -r 's///g2'
styles.xml
3. zip file.ods styles.xml 

This works for me as I get regularly ODS which are saved as office version 1.3
and I lose the header and footer at the moment.

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

[Libreoffice-bugs] [Bug 147141] Calc header/footer not backwards compatible (office version 1.3 > 1.2)

2022-02-02 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=147141

--- Comment #1 from Wittich  ---
A quick analyze of the difference of a document which works (version 1.2) and
one which doesn't work (version 1.3) shows that the only main difference
concerning the header and footer of these documents are the lines 



[...]

[...]

[...]



So if I remove this header-first and the footer-first style, everything works
as it should.

Hope that helps to solve the issue.

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

[Libreoffice-bugs] [Bug 147141] Calc header/footer not backwards compatible (office version 1.3 > 1.2)

2022-02-02 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=147141

Wittich  changed:

   What|Removed |Added

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

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