Bug 61469 - No force recalculation in page preview mode
Summary: No force recalculation in page preview mode
Status: RESOLVED WONTFIX
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: bibisected40
Keywords: regression
Depends on:
Blocks:
 
Reported: 2013-02-25 22:37 UTC by Hugues
Modified: 2013-03-20 19:34 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
bibisect40 log (2.85 KB, text/plain)
2013-03-19 23:59 UTC, Jorendc
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Hugues 2013-02-25 22:37:56 UTC
As a teacher I used to use Openoffice a lot (especially Calc) in order to do automatic worksheets in math and French.
In print preview mode, I could generate automatically anything just by pressing Ctrl+Alt+F9, which was very convenient.

Unfortunately, since I installed Libreoffice 4 (all versions), the preview mode does not allow to force recalculation, and that is a very useful feature Openoffice has.
Comment 1 Hugues 2013-02-25 22:42:32 UTC
Comment:

This feature is really important because in print preview, fullscreen, we can create automatically any quizz and test we want. But without it, we have to use the normal view with the grid, and it's impossible to see just the cell we want (define print range, etc.).

It's not really practical.
Comment 2 Hugues 2013-02-25 22:46:28 UTC
Sorry, it's not "print preview" but "page preview".

And because I don't know how to edit my own message, I had to add - another - comment...

Thanks in advance,

Hugues
Comment 3 Joel Madero 2013-02-26 17:54:13 UTC
Can you provide a document that we can see this behavior? Just not clear on the issue. 

Marking as NEEDINFO - once you provide a test document mark as UNCONFIRMED and I will triage the bug ASAP
Comment 4 Hugues 2013-02-27 01:33:31 UTC
Ok, here is one example that I use on a video projector in class. On Openoffice, I just click on "page preview" and "fullscreen" and I generate tables they have to fill up (simple additions).

It works beautifully on Openoffice, but on Libreoffice, when I press Ctrl+Alt+F9, nothing happens (on page preview)


Document:
http://dl.dropbox.com/u/9447719/example.ods
Comment 5 Hugues 2013-03-18 00:50:38 UTC
(In reply to comment #3)
> Can you provide a document that we can see this behavior? Just not clear on
> the issue. 
> 
> Marking as NEEDINFO - once you provide a test document mark as UNCONFIRMED
> and I will triage the bug ASAP

Done!
Comment 6 Jorendc 2013-03-19 23:54:01 UTC
(In reply to comment #0)
> In print preview mode, I could generate automatically anything just by
> pressing Ctrl+Alt+F9, which was very convenient.

PS: for clarity: I think the right shortcut combination is Ctrl+Shift+F9

I can reproduce this behavior using Linux Mint 14 x64 with LibreOffice 4.0.2.1
Bibisecting now.
Comment 8 Jorendc 2013-03-20 00:06:03 UTC
@kohei: am I right this is introduced with this patch: http://cgit.freedesktop.org/libreoffice/core/commit/?id=1227601d74ecddb06dcbe69e260aa32835900ed3 ?

Thanks for your time,
Joren
Comment 9 Hugues 2013-03-20 01:18:41 UTC
(In reply to comment #6)
> (In reply to comment #0)
> > In print preview mode, I could generate automatically anything just by
> > pressing Ctrl+Alt+F9, which was very convenient.
> 
> PS: for clarity: I think the right shortcut combination is Ctrl+Shift+F9
> 
> I can reproduce this behavior using Linux Mint 14 x64 with LibreOffice
> 4.0.2.1
> Bibisecting now.

Yes indeed.

Nothing happens by pressing Ctrl+Alt+F9 in "page preview". If this bug gets fixed, that would be amazing, I could use LO for my presentations in class.

Thanks in advance for your time. You're all doing an amazing job!
Comment 10 Kohei Yoshida 2013-03-20 13:47:32 UTC
But it's very weird to allow recalculation in "print" preview mode.  Previously a lot of functionality was still enabled in print preview *unintentionally* which caused problems in other places, and I had to disable them.

Note that recalculation may cause re-pagination of the printed areas which may cause major problem in print preview.  I'm not in favor of allowing that in print preview mode.  Print preview is primarily for preview before print, all the others need to be done in the normal window.
Comment 11 Kohei Yoshida 2013-03-20 13:59:16 UTC
If I understand the use case correctly, you can achieve something very similar by turning off the column row headers (in the Options dialog) and turning off grid display (either in the Options dialog or there is an icon in the toolbar, far to the right) in normal mode, then go to full screen mode.
Comment 12 Hugues 2013-03-20 18:15:10 UTC
Yes, but it does not look the same. That's why we use OpenOffice that does it perfectly.

Check this file, you will find many examples that automatically generate new operations, but not with LO.

https://dl.dropbox.com/u/9447719/math%20simple.ods
Comment 13 Kohei Yoshida 2013-03-20 18:22:23 UTC
I did.  You can tweak the sheet to make it the way you want it to look.

Still, print preview is the static snapshot of what's to be printed; it's never intended to be used for pretty display, or editing the content (which recalculation is).  The fact that recalculation was allowed before was what I consider an accidental loophole.
Comment 14 Hugues 2013-03-20 19:05:04 UTC
Well, it was a very convenient loophole, then! Everything was centered and clean.

Thanks for your explanation, I will have to find something else...
Comment 15 Jorendc 2013-03-20 19:34:36 UTC
Thanks to the help of Kohei, we can mark it as WONTFIX. If would like to get this option "back", we'll break lots of printing-stuff, and it is also not a "proper" use case of the preview window.

Thanks for your understanding,
Joren